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
Get step-by-step solutions from verified subject matter experts
