Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MIS 2113 HW#2 AO: Name OUID Create the following ERDs. Please print this page and draw your ERD's on it and turn it in AT

image text in transcribed
image text in transcribed
MIS 2113 HW#2 AO: Name OUID Create the following ERDs. Please print this page and draw your ERD's on it and turn it in AT THE BEGINNING of the class, also scan or take a picture to submit it on Canvas Based on the narratives, draw the following ERDs. Make sure you add the Primary Keys, Foreign Keys, verbs that represent the relationship, and mark cardinality (both lower and upper bounds) for each diagram. Draw the diagram under the questions. Apply all 4 ERD rules. 1. Movies have many actors. An actor may only act in one movie. Actors have a first name, last name and age. A movie has a duration and a director. (10 points) 2. A car can have several passengers. But a passenger can only ride in one car. A car has a vin number, model, and year. A passenger has a first name and last name. (10 points) 3. A user can own several computers. A computer may be owned by users. A user will have a username and password. A computer will have a brand and model. (15 points) HW#2 AO: MIS 2113 4. Ateacher may teach many students at a school. A student may see many different teachers at a school. A teacher has a first name and last name. Student has first name, last name and age. (15 points) 5. A volunteer may be part of several organizations. Each organization has many volunteers. A volunteer has a city, state, and phone number. Organizations have number of volunteers, an organization name and a founder. (15 points) 6. A new grocery store is opening that specializes in fruit. The owner wants to create her own database to track all the fruit she sells. Currently, she doesn't plan to sell anything other than fruit. For now, the owner only needs to keep track of each fruit's weight, size, and price. She only keeps track of the customer's first name, last name, and email address. She only keeps track of an order's sale date. Create the entity-relationship diagram (ERD) that represents fruit, customers, and orders. (35 points - partial credit given)

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

Data Management Databases And Organizations

Authors: Richard T. Watson

3rd Edition

0471418455, 978-0471418450

More Books

Students also viewed these Databases questions