Question: Practice 2: Imagine you are tasked with designing a database to keep track of famous painters and their paintings. Using Lucidchart, create entities for both

Practice 2: Imagine you are tasked with designing a database to keep track of famous painters and their paintings.

Using Lucidchart, create entities for both painter and painting. Be sure to give each entity a minimum of 4 attributes, including an id attribute. Create a relationship line between the two entities. Format the line so that it accurately represents the cardinality of the relationship (NOTE: you can limit yourself to these two options at each end of the line).

Practice 3: Create an ERD for McCullough's Pizzeria, based upon the discussion that took part in class today.

Practice 4: Suppose you are given the following requirements for a simple database for the National Basketball Association (NBA) or (if you prefer) the Women's National Basketball Association (WNBA): the (W)NBA has many teams, each team has a name, a city, a coach, and a set of players each player belongs to only one team each player has a name, and a position a game is played between two teams (referred to as host_team and guest_team) and has a date (such as May 11th, 2017) and a score (such as 100 to 97) Construct a clean and concise ER diagram for the database using the Crow's Foot model. List any assumptions that you make along the way.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!