Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Describe the situation ( the business you choose ) . Your description should be brief and relatively informal ( maximum length 1 A 4 page
Describe the situation the business you choose Your description should be brief and relatively informal maximum length A page If there are any unique or particularly difficult aspects of your proposed application, please point them out. Your description will be marked only on suitability and conciseness
Include a list of business rules can make assumptions as long as it is logical
Draw an ER diagram for your proposed database. You need to show attributes, primary keys, and relationships needs to use Chen and Crows feet notation
the business is Gym trainer managing clients exerciseroutines
Part B: Map the ER diagram to NF & Normalisation
Map the ER diagram to NF
Translate your ER Diagram into a schema of normalised tables. These must be in at least rd Normal Form database schema
Normalisation
Use a flat structure table include all attributes:
Determine functional dependencies
Use nf to develop the relations, show as
o Textnotation
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started