Construct an *E-R diagram* for a university registrar's office. The of

Back to the 2020 paper

Module 1: Database System Architecture

202014m

Construct an E-R diagram for a university registrar's office. The office maintains data about each class, including the instructor, the enrollment, and the time and place of the class meetings. For each class pair, a grade is recorded. Document all assumptions that you make about the mapping constraints.

Search Google Ask AI

Similar questions

Data MiningA university plans to build a data warehouse that would help them in analyzing the performance of the students in various courses in different academic sessions. They want to analyze if there is any relation between the average grade of a course and the number of students attending it. They would also like to know if there were some courses offered but did not have any students registered for them. Relative performance among boys and girls and average grades of students from various States and cities of the country for each course must be analyzed and also overall CGPA. Design a star schema for such a data warehouse clearly identifying the fact table(s) and dimension table(s), their primary key(s) and foreign key(s). Your schema should at least be able to satisfy the above-mentioned analysis requirements. You may consider other suitable attributes for the dimension table(s).202110m Database Management SystemDesign an ER diagram for a Hospital Management System containing Patients, Doctors, Departments, and Appointments. Clearly identify entities, attributes, relationships, and cardinalities.20257m Software EngineeringWrite short notes on: UML Diagrams20247m Software EngineeringDraw the first two levels of DFDs for an 'Online Examination System'. Make necessary assumptions.20217m

PreviousWhat are four main differences between file-processing system and a DBMS?NextWhat is the use of relational query language in DBMS? Use the example to explain tuple and domain relational calculus.