EduVarsity, a university which prides itselfin its efforts to provide their students with the academic support, has just hired you to develop the information system they will be using to keep track of the students that have signed up for extra classes at the university. They have brought you in to specifically help them design the database their information system will be using. As part of your design job, the Eduvarsity managers asked you to provide an Entity Relationship Diagram to show the structure of the database. They would like the database to keep track of the students who have used the system to register for extra classes. Details such as their student number, frst name, last name, and date of birth are to be stored for every student that registers. The university has lecturers involved in their academic support programme. The designed database should be able to store details on the lecturers such as first name, last name and highest qualfication. Each lecturer can provide many extra class sessions, although according to university polcy, each of the extra class sessions should only be conducted by a single lecturer. For each extra class session, the database should store the subject of the class (eg. Geography, Maths, Informatics, etc.), the level of the module (e.g. 1A, 28, 3A, etc.), and the date in which the extra dass sessions started. The students at EduVarsity may register to attend extra class sessions at any time during the semester. The managers at the university would ike to know the date at which each student registers to attend extra class sessions An extra dass session can be registered for by multiple students, and each of the students may register to attend the diferent extra class sessions they want Given the information above, draw an ER Dlagram showing the following: • Entities, • Attributes, • All key attributes, • Data types for each attribute, and • All relationships between the entries NB: You may use one of the standardised ERD notations. 6.4 Draw an ERD diagram based on the information provided above.
EduVarsity, a university which prides itselfin its efforts to provide their students with the academic support, has just hired you to develop the information system they will be using to keep track of the students that have signed up for extra classes at the university. They have brought you in to specifically help them design the database their information system will be using. As part of your design job, the Eduvarsity managers asked you to provide an Entity Relationship Diagram to show the structure of the database. They would like the database to keep track of the students who have used the system to register for extra classes. Details such as their student number, frst name, last name, and date of birth are to be stored for every student that registers. The university has lecturers involved in their academic support programme. The designed database should be able to store details on the lecturers such as first name, last name and highest qualfication. Each lecturer can provide many extra class sessions, although according to university polcy, each of the extra class sessions should only be conducted by a single lecturer. For each extra class session, the database should store the subject of the class (eg. Geography, Maths, Informatics, etc.), the level of the module (e.g. 1A, 28, 3A, etc.), and the date in which the extra dass sessions started. The students at EduVarsity may register to attend extra class sessions at any time during the semester. The managers at the university would ike to know the date at which each student registers to attend extra class sessions An extra dass session can be registered for by multiple students, and each of the students may register to attend the diferent extra class sessions they want Given the information above, draw an ER Dlagram showing the following: • Entities, • Attributes, • All key attributes, • Data types for each attribute, and • All relationships between the entries NB: You may use one of the standardised ERD notations. 6.4 Draw an ERD diagram based on the information provided above.
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
Related questions
Question
100%
Transcribed Image Text:Eduvarsity, a university which prides itself in its efforts to provide their students with the academic support,
has just hired you to develop the information system they will be using to keep track of the students that
have signed up for extra classes at the university.
They have brought you in to specifically help them design the database their information system will be
using. As part of your design job, the Eduvarsity managers asked you to provide an Entity Relationship
Diagram to show the structure of the database.
They would like the database to keep track of the students who have used the system to register for extra
classes. Details such as their student number, frst name, last name, and date of birth are to be stored for
every student that registers.
The university has lecturers involved in their academic support programme. The designed database
should be able to store details on the lecturers such as first name, last name and highest qualfication.
Each lecturer can provide many extra class sessions, although according to university polcy, each of the
extra class sessions should only be conducted by a single lecturer. For each extra class session, the
database should store the subject of the class (eg. Geography, Maths, Informatics, etc.). the level of the
module (e.g. 1A, 28, 3A, etc.), and the date in which the extra dass sessions started.
The students at EduVarsity may register to attend extra class sessions at any time during the semester.
The managers at the university would ike to know the date at which each student registers to attend extra
class sessions. An extra dass session can be registered for by multiple students, and each of the students
may register to attend the different extra class sessions they want
Given the information above, draw an ER Diagram showing the following:
• Entities,
• Atributes,
• All key attributes,
• Data types for each attribute, and
• All relationships between the entties
NB: You may use one of the standardised ERD notations.
6.4 Draw an ERD diagram based on the information provided above.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
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.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education