Question
This project worth 10 marks, will be distributed as following: a. Design the database, following an ER model. (2 marks) b. Normalize the tables (
This project worth 10 marks, will be distributed as following:
a. | Design the database, following an ER model. | (2 marks) |
b. | Normalize the tables ( each table should be in 3NF at least) | (2 marks) |
c. | Use MySQL or any other database to create the normalized tables. | (2 marks) |
d. | Populate your tables with 5 rows at least. | (2 marks) |
e. | Execute the sample requested queries. | (2 marks) |
Each student has to submit one report about his/her project via the Blackboard contains the following:
ER Diagram.
All schemas before and after normalization.
All SQL statements of :
creating tables
inserting data in tables
queries.
Screenshots from MySQL (or any other software you use) of all the tables after population and queries results.
Project 2 Football championship calendar This project supposed to develop a database system for football championship calendar. The system contains informati on about teams, stadiums, referees, and matches. A match is composed by local team, visitor team, date ofmatch, referee and stadium and the score. You should design the system to contain entities and attributes to store data that makes the system able manage the championship and to organize the different matches. Note that the winner has 3 points and the loser 0 point. In draw case, 1 point for each team. The referee is identified by his ID. The team is identified by his name. SQL Queries: 1.List the matches of the current day 2. List the matches with score of the last journey 3. List the winners for each 4. Insert the matches of the next joumey and the date. 5. List the available stadium with the capacity. 6. List the championship standings journey Project 2 Football championship calendar This project supposed to develop a database system for football championship calendar. The system contains informati on about teams, stadiums, referees, and matches. A match is composed by local team, visitor team, date ofmatch, referee and stadium and the score. You should design the system to contain entities and attributes to store data that makes the system able manage the championship and to organize the different matches. Note that the winner has 3 points and the loser 0 point. In draw case, 1 point for each team. The referee is identified by his ID. The team is identified by his name. SQL Queries: 1.List the matches of the current day 2. List the matches with score of the last journey 3. List the winners for each 4. Insert the matches of the next joumey and the date. 5. List the available stadium with the capacity. 6. List the championship standings journey
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started