Please draw an ER diagram of the informations provided. Each course has a unique identifying code (a 4 character string, e.g., 7FXU) and a longer title(e.g., 'CS-1Q'). A course is taken by one or more students and is taught by one or more lecturers.Each student has a unique student ID (a 7 digit unsigned integer, e.g. 1234000), forename &surname, and an email address. Lecturers have a responsibility indicating the start week and endweek for their teaching duties. In addition, all lecturers are members of staff, with a unique staffnumber (a 7 digit unsigned integer, e.g. 1003594), forename & surname and a job-title (one ofprofessor, senior lecturer, lecturer, university teacher, associate lecturer, research assistant,research student, other). For each course that a student takes, there can be an associated exammark in the range 0 to 100 and a practical mark in the range 0 to 30. Each course has 0 or moreassociated tutorial groups, numbered from 1 for each course. A tutorial group has one or morestudents and exactly one tutor. It also has room numbers for the lab and tutorial rooms. Tutorsare members of staff, with an additional binary indication of their status as part-time or full-time.All staff members have exactly one manager who is also a member of staff.

Answered: Each course has a unique identifying…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Please draw an ER diagram of the informations provided.

Each course has a unique identifying code (a 4 character string, e.g., 7FXU) and a longer title
(e.g., 'CS-1Q'). A course is taken by one or more students and is taught by one or more lecturers.
Each student has a unique student ID (a 7 digit unsigned integer, e.g. 1234000), forename &
surname, and an email address. Lecturers have a responsibility indicating the start week and end
week for their teaching duties. In addition, all lecturers are members of staff, with a unique staff
number (a 7 digit unsigned integer, e.g. 1003594), forename & surname and a job-title (one of
professor, senior lecturer, lecturer, university teacher, associate lecturer, research assistant,
research student, other). For each course that a student takes, there can be an associated exam
mark in the range 0 to 100 and a practical mark in the range 0 to 30. Each course has 0 or more
associated tutorial groups, numbered from 1 for each course. A tutorial group has one or more
students and exactly one tutor. It also has room numbers for the lab and tutorial rooms. Tutors
are members of staff, with an additional binary indication of their status as part-time or full-time.
All staff members have exactly one manager who is also a member of staff.

Expert Solution

Step 1 Introduction

ENTITY RELATIONAL (ER) MODEL which refers to the high-level conceptual data model diagram. ER modeling helps you to analyze data requirements systematically to produce in a well-designed database. The Entity-Relation model that represents the real-world entities and the relationship between them. It is considered a best practice to complete ER modeling before implementing your database.

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions