Create an ER Diagram for the movie rental stores. The data of this store contains this...

Transcribed Image Text:

Create an ER Diagram for the movie rental stores. The data of this store contains this information: employee number, supervisor, employee first name, employee address, employee phone, hire date, salary, movie number, movie title, description, rating, genre, rental rate, movie url, store number, store manager, store address, store phone, store city, store state, store zip code, rental record date, movie copy number, rental date, due date, rental status, customer number, customer address, email, customer city, customer first name, customer last name, customer state, customer zip code, credit card, credit card exp, status code, store number, payment transaction number, payment type, payment amount, payment date, payment status, check bank number, check number, e-pay vendor number, e-pay account number, credit card number, credit card exp, credit card type you need to complete an ER Diagram in ERwin. The ER Diagram should have a logical model and a physical model, and the following objects: the entities, attributes, primary keys, foreign keys, relationships, data type, etc. Submission: Please submit screenshots of your logical and physical model and the .erwin file. Create an ER Diagram for the movie rental stores. The data of this store contains this information: employee number, supervisor, employee first name, employee address, employee phone, hire date, salary, movie number, movie title, description, rating, genre, rental rate, movie url, store number, store manager, store address, store phone, store city, store state, store zip code, rental record date, movie copy number, rental date, due date, rental status, customer number, customer address, email, customer city, customer first name, customer last name, customer state, customer zip code, credit card, credit card exp, status code, store number, payment transaction number, payment type, payment amount, payment date, payment status, check bank number, check number, e-pay vendor number, e-pay account number, credit card number, credit card exp, credit card type you need to complete an ER Diagram in ERwin. The ER Diagram should have a logical model and a physical model, and the following objects: the entities, attributes, primary keys, foreign keys, relationships, data type, etc. Submission: Please submit screenshots of your logical and physical model and the .erwin file.

Answer rating: 100% (QA)

The diagram you sent is a screenshot of a question about creating an ER diagram for movie rental orders The diagram should include a digital model and ... View the full answer