Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

3. Who would the members be?

Answered: 1 week ago