Posted: September 25th, 2022

Flight database.

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Task 1–1: Create an ERM diagram from a business or company you are familiar with.
Some examples of entities are:
1. Netflix Movie streaming service. Entities include available movies, genre, customers and rentals.
2. Student Course Registrations. Entities such as students, courses, professors, and classrooms are involved.
3. Flight Database. Entities such as airplanes, flights, airports and pilots are involved.
Ensure your ERM has at least four entities. We recommend that you use Lucidchart to create your ERM. Within the Lucidchart website, select ERD as the template.. Leverage them in the future in your other courses.
Task 1-2: Ensure to identify the Primary Key for each entity. Identify the foreign keys where needed.
Task 1-3: Identify the relationship between entities using a triangle or diamond shape. Please describe this relationship.
Task 1-4: Identify the cardinalities for each relationship.
Task 1-5: Write 1 – 2 pages describing the transaction that you’ve modelled, relationship between entities and the cardinalities identified. All submissions must use the APA format.

For This or a Similar Paper Click To Order Now