Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Donald A. Carpenter Fred R. McFadden

1st Edition

8178088045, 978-8178088044

More Books

Students also viewed these Databases questions

Question

What is investment banking? What is an underwriting spread?

Answered: 1 week ago

Question

Describe how language reflects, builds on, and determines context?

Answered: 1 week ago