abzy1991

So, I have created a website application using Visual Studio 2010, C#. I have to create a test plan document. I am not understanding the unit testing. I understand i have to perform a white box testing. White box testing will test the flow of input and output of the …

Using SQL I have to SUM the total of each game but I can only select the games that have more than 10 scores in total . So `select GameNo,sum(goals) from tblGame, tblAthlete.` But I'm stuck on the 'where' bit.....`select GameNO where (sum(goals)>=10);` So not only do I have to …

I have an issue and I would like to know how I should go about this. I have two tables. Athlete and EachAth_Games create table Athlete ( AthleteID INTEGER NOT NULL, Firstname varchar(10) NOT NULL, Surname varchar(10), Position varchar(1), TeamID INTEGER NOT NULL, CONSTRAINT pk_Athlete primary key(AthleteID, Firstname), CONSTRAINT Player_FOREIGN_KEY …

I'm trying to create a table writing in SQL and I need to validate the 'Date of Birth' field 'Players must be over 16 years of age' So how should I validate this. my table name is : Players field name is DOB and the datatype is 'DATE' I tried …

Don't really understand Basketball and I have to do an ERD . Can someone tell me how to link the 'manager', 'coaches' and 'club' tables. e.g. would it be one manager has MANY coaches to manage. e.g. One club has MANY Coaches. Don't get it. Also I have these following …

**How to show the scoring of each match & show players individual performance for each match on an ER Diagram for a basketball system? ** Hello, I have to create a database for a basketball system. I’m confused about the 'scoring'. I have kept the scores in the ‘GameStats’ table …