Answered step by step
Verified Expert Solution
Question
1 Approved Answer
provide a data dictionary Provide the list of tables and the links between the tables Give the role of each chosen table in the system
provide a data dictionary
Provide the list of tables and the links between the tables
Give the role of each chosen table in the system
Design a database to maintain information about school staff and students
satisfying the following properties:
Staff will have their id name, and classes they are teaching.
The student will be having the name, roll no section, class.
Another table containing the section, subject, and teacher information.
Next will contain fee information for students.
One contains salary information for teachers.
Rooms are assigned to classes keeping in mind that there is no time clash of
same room or lab, students cannot be entered in more than one section, no
student should be there who have not paid fees up to a particular date.
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