Complete Short Database Management Task (MORGAN)

There are two students in the EXACT SAME CLASS….YOU WILL COMPLETE THIS TASK TWICE BUT IN DIFFERENT WAYS SO THAT IT DOES NOT LOOK LIKE THEY PLAGIARIZED OFF EACH OTHER….THEY NEED TO BE TOTALLY DIFFERENT FROM EACH OTHER…SEND EACH TASK ON ITS OWN WORD DOCUMENT AND SEND TWO TURNITIN REPORTS PLEASE

In this Project (Part 1), you will gain experience on conceptual database Design.

You need to design and develop an ER diagram based on the requirement description for the case of video shop. (See the attached file)

An ERD must contain 4 building blocks:

1. ENTITIES

2. ATTRIBUTES

3. Unique Identifiers (UIDs)

4. Relationships (including cardinality and modality) and their corresponding relationship sentences. For example, for the relationship between VIDEOTAPE and MOVIE can be described by two relationship sentences as shown below:

Each MOVIE may be copied in one or more VIDEOTAPEs.

Each VIDEOTAPE must contain one and only one MOVIE.

Submit your ERD in a timely manner.