Entity relationship diagrams (ERDs) and normalization are essential tools for organizing information within a system. In this assignment, you will analyze data from a business scenario, create an ERD, and explore the concepts of normalization and denormalization.
Assignment Instructions and Requirements:
Avery’s Gym has partnered with a physical therapy business, offering special sessions for gym members. Your task is to develop an entity relationship diagram (ERD) for this partnership and explain the significance of normalization and denormalization. For written portions of this assignment, be sure to use APA paragraph formatting.
Instructions Requirements
Assignment Instructions
Tasks:
Normalize the data:
Organize the information into data fields suitable for a relational database.
Analyze the data and create a database model. Consider the need for unique IDs for primary keys.
Construct an ERD:
Use Visio to create an ERD based on the normalized data.
Identify primary and foreign keys and develop thorough attributes for each entity.
Use crow’s feet to show relations between entities.
Data Fields:
Physical Therapy Session
Session Date
Session Time
Session Details/Purpose
Member Name
Member Address
Member Phone
Member Age
Member Email
Insurance Number
Insurance Name
Insurance Address
Insurance Plan details
Trainer Name
Trainer Phone
Trainer Email
Trainer Specialty
Therapist Name
Therapist Phone
Therapist Email
Therapist Specialty
Insurance Claim Number
Claim Cost
Explain the importance of normalization (minimum 120 words):
Provide a summary of the steps for achieving 1NF, 2NF, and 3NF.
Illustrate the importance of normalization in maintaining data integrity, minimizing redundancy, and facilitating efficient data retrieval. Use real-world examples to enhance understanding.
Explain denormalization (minimum 60 words):
Briefly describe denormalization and its main reasons.
Explore scenarios where denormalization is beneficial, such as improving query performance or simplifying complex queries.
The post Avery’s Gym – Entity Relationship Diagram (ERD), Database Normalization, and Denormalization appeared first on Writeden.