Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2 . 2 Richfield University has asked you to redesign their database into a relational database. They have given you the following business rules: Students
Richfield University has asked you to redesign their database into a relational database. They have given you the
following business rules: Students at the university are either undergraduate or postgraduate. A student can also be
an employee. Employees can be an academic or administrator. An academic can be a lecturer or researcher or both. A
lecturer can either be a junior or senior lecturer. An administrator can be a manager or assistant. A manager must be
a general manager or department manager. List all the entities for this EERD. Indicate notation as well. Please note,
the only attributes you should indicate are StudNum and EmpNum. Use relational schema eg "Entity Name"
AttributeNotation
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