Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ER Diagram and Participation constraints Question 2 needs doing. Answer as how i answered question 1 Will leave thumbs up if all good. COMP1121 Databases

ER Diagram and Participation constraints

Question 2 needs doing.

Answer as how i answered question 1

Will leave thumbs up if all good.

image text in transcribed

image text in transcribed

COMP1121 Databases Lecture 9: Examples of ER Diagrams Draw ER diagrams for the following including entity type. Include participation constraints on all relationship types ing purposes, including at least one attribute for each a retired general, gardening tools the matches the teams have played. He also need e (hamed after a local company that maufactures specialist gardening s of a number of football teams. The league is administered by Who is repaid for his work by being given spades, forks, and other e general needs to have a database to record information about s to know which players are in which . Th o manages cach team. The league regulations arc recorded in a large red book, which the general keeps under his bed. They specify that every team has . Each player has Just one manager, and that no one can manage more than one team to be registered for just one team, and a team consists of 16 to 20 registered players For each match it must be recorded which two teams played and the number of goal that each scored. Plaver Plays Tearn mano manage tIN name name name 1.4 2 plaued in 0. match Place

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

Graph Database Modeling With Neo4j

Authors: Ajit Singh

2nd Edition

B0BDWT2XLR, 979-8351798783

More Books

Students also viewed these Databases questions