• Presentations
  • Presentations
  • IMG 0341
  • Presentations
  • IMG 0409

List of entities and their corresponding attributes for Case Study 3

(2 votes, average 5.00 out of 5)

This is the third of three case studies that are used to guide the reader through the six steps outlined in Six-Step Relational Database Design™. Some of the outputs of the six step database design process are depicted here. Get a copy of Six-Step Relational Database Design™ to get the details of all six steps.

Scenario

Below is the scenario for Case Study 3 as described in Six-Step Relational Database Design™:

The registrar at a small college wants an application that will help their department keep track of the schedule of classes, the courses and lecturers appearing in the schedule, and the students registering for courses according to the schedule.

Courses are scheduled every semester and this is documented in the schedule of classes, which also documents the lecturers assigned to each schedule of a class. Students register for courses according to the schedule of classes.

Users (students, lecturers, and other college staff) must login to the application to gain access, and the application must keep track of user logins/logouts. In addition, users must have different levels of access, which will determine their access to different parts of the application.

 

List of entities and their corresponding attributes

Below is the list of entities and their corresponding attributes that is output from Step 1 of the six step database design process as described in Six-Step Relational Database Design™:

Students
(PK) StudentId
SSNumber
LastName
FirstName
MiddleName
Gender
DOB
Email
Mobile
HTel
AddressLine1
AddressLine2
City
State
PostCode
Courses
(PK) CourseId
CourseCode
ShortName
LongName
CourseDescription
ScheduleOfClasses
(PK) ScheduleId
ScheduleCode
Section
Day
Time
Location
Semesters
(PK) SemesterId
SemesterNumber
SemesterName
SemesterYear
StartDate
EndDate
Lecturers
(PK) LecturerId
SSNumber
LastName
FirstName
MiddleName
Gender
Email
Mobile
HTel
WTel
About
AccessLevels
(PK) AccessLevelId
AccessLevelCode
ShortName
LongName
AccessLevelDescription
Users
(PK) UserId
Login
UserName
Password
Active
LogEntries
(PK) LogEntryId
LoggedOn
LoggedOn

View the resulting Entity-Relationship diagrams for Case Study 3.