Question: I need help ASAP. Create two conceptual ERDs using Crow's Foot notation on a blank sheet of paper. When you're finished, take a picture of

I need help ASAP.
I need help ASAP. Create two conceptual ERDs using Crow's Foot notation
on a blank sheet of paper. When you're finished, take a picture

Create two conceptual ERDs using Crow's Foot notation on a blank sheet of paper. When you're finished, take a picture of your work, name them Lab2_LastFirst_1 & Lab2_LastFirst_2, and submit these as either .jpg or.png files or insert them into a copy of our Lab and download them as a PDF to attach to your Lab 2 Brightspace assignment. Note: If it's helpful, you may want to convert the descriptions below into specific business rules, however, you are not required to submit them. Business Rules Template Reminders: A entity #1] [relationship verb] (one OR many] entity #2] Always start with the singular form Read relationships in both directions (right to left and left to right) Use the one or many at the end of the line when reading . 1. The Talent Agency You are asked to build a database for a talent agency that books musical bands into nightclubs. The agent needs a database to keep track of the agency's transactions and to answer day-to-day questions. For example, a club manager often wants to know which bands are available on a certain date at a certain time, or wants to know the agent's fee for a certain band. Similarly, the agent may want to see a list of all band members and the instrument each person plays, or a list of all bands that have their members. You have talked to the agent and have observed the agency's business operation. You conclude that your database needs to reflect the following facts: 1. The Talent Agency You are asked to build a database for a talent agency that books musical bands into nightclubs. The agent needs a database to keep track of the agency's transactions and to answer day-to-day questions. For example, a club manager often wants to know which bands are available on a certain date at a certain time, or wants to know the agent's fee for a certain band. Similarly, the agent may want to see a list of all band members and the instrument each person plays, or a list of all bands that have their members. You have talked to the agent and have observed the agency's business operation. You conclude that your database needs to reflect the following facts: . . . A booking is an event in which a certain band plays in a particular club on a particular date, starting and ending at certain times, and performing for a specific fee. Bands may play more than one booking, but each booking is for just one band. A nightclub can have multiple bookings (for the same day or different days) but each booking is for only one nightclub. Each band has at least one member and an unlimited maximum number of members, Musicians play in only one band. The agent keeps track of the primary instrument a musician plays. (Vocals, drums, bass guitar, etc.)

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!