Design the database for institute registrars office

Assignment Help Database Management System

Reference no: EM133666348

Question: Design the database for Institute Registrar's Office

Institute Registrar's Office maintains data about the following entities:

1. Unit Coordinator as Academic Employee, including employee identification number, first name, last name, gender, date of birth, mobile number, contact email, address;

2. Class Sessions, including class group number, class time, and semester;

3. Units, including unit code, unit name, unit category, unit start date, and unit end date e.g. unit code is M8154002; Unit name is Database Management for Business; unit category is 88_2023; unit start date Is 9-Nov-2023; unit end date is 02-Dec-2023; Moreover, each student' grade in each enrolled Unit needs to be stored into the designed database.

4. Rooms, including room number, room type, and location;

5. Students, Including student number, student First name, student last name, gender, phone, email, and address;

Business rules (i.e., relationships):

1. A Unit Coordinator manages zero, or many Units, and a Unit is managed by one Unit Coordinator.

2. A Unit may generate one or many classes; and a class comes from one Unit.

3. A Unit may enrol one or many students, and a student may enrol in zero or many Unit in each semester.

4. A Class is held in one room but a room holds one or many Classes.

5. A department has one or many Unit Coordinators, and a Unit Coordinator is belonging to one department.

Please make sure you must convert any many - to many relationships to two one to many relationships in your solution.

Reference no: EM133666348

Questions Cloud

What type of perfusion applies to the case : What type of perfusion applies to this case? What are the appropriate assessments and interventions for this patient?

Design principles and engagement for both websites : Design principles and engagement for both websites by critically analysing. Identify 2 design features that can be improved for each website

Discuss evaluation plan for proposed nursing intervention : Summarize the evidence/literature, including connection to the proposed plan. Discuss the evaluation plan for proposed nursing intervention.

Which learning theory and principle do you think are useful : Which learning theories and principles do you think are most useful to the advanced practice nurse (APN) in providing high quality health care to clients, and w

Design the database for institute registrars office : Design the database for Institute Registrars Office - convert any many - to many relationships to two one to many relationships in your solution

How does this regulation influence the nurses role : How does this regulation influence the nurse's role? How does this regulation influence delivery, cost, and access to healthcare?

Create ppt for one or more stakeholder or leadership groups : create a PowerPoint presentation for one or more stakeholder or leadership groups to generate interest and buy-in for the plan proposal you developed.

Identify a professional practice use of the theories : Identify a professional practice use of the theories/concepts presented in article. Describe your approach to identifying and analyzing peer-reviewed research.

What do you do if you think you have been sexually assaulted : What do you do if you think you have been sexually assaulted? What can you do when someone you care about has been sexually assaulted?

User Account

All Pages