The semester project must be completed in order to pass the course. The semester project consists of an E-R diagram, a database schema, a short write-up, and a set of SQL statements that create, load, and query a database for an organization of each group's choosing. Students will work in groups of up to four to complete the project. Students should form their groups by their selves. To pass the class, a working project database must be created using SQL statements. If a working database is not created using SQL statements, the students in that group will receive a grade of "F" for the course. Tables You must have at least 5 tables. The relationships between the tables should be defined. Take care to correctly define the properties of all the fields in the tables. Queries You must have at least 5 queries. At least 3 of them should be parameterized. Parameterized means that the criteria of some of the fields of these queries must be an expression and not a constant. Forms There should be at least 5 forms. These should be data entry/updating forms. At least one of them should have a subform that depends on the main form. Take care to title the forms correctly, At least one of the controls on each form should be a calculated control. This means the control should contain an expression in its control Source property. Some suggested Database Applications: NBA Statistics Database -Player regular season stats -Player regular season career totals -Player playoff stats - Player playoff career totals - Player all-star game stats -Team regular season stats -ete. Football Federation Database -Football Players, - Football clubs, -Licenses -Team Statistics -etc. Real Estate Database -Staff-Client-Property For Rent(Adres, Type, Rooms) -Owner-Registration -etc. Oscar Academy Awards -Movie Names, -Producers -Actors, -Date of Production -Genre -etc