Ask a question from expert

Ask now

ER Diagram, Relational Data logical model, Data dictionary, Oracle SQL Code

Answer all questions related to advance databases in electronic form using MS Word, including ER diagram and code. Use student ID as part of entity and constraint name. Provide SQL code and screenshots of execution on SAS Studio.

12 Pages1599 Words46 Views
   

Added on  2023-01-16

About This Document

This document provides information about ER Diagram, Relational Data logical model, Data dictionary, and Oracle SQL Code. It includes tasks, tables, attributes, SQL commands, and SQL statements related to these topics. The document also includes sample queries for retrieving specific information from the database.

ER Diagram, Relational Data logical model, Data dictionary, Oracle SQL Code

Answer all questions related to advance databases in electronic form using MS Word, including ER diagram and code. Use student ID as part of entity and constraint name. Provide SQL code and screenshots of execution on SAS Studio.

   Added on 2023-01-16

BookmarkShareRelated Documents
COVER PAGE
ER Diagram, Relational Data logical model, Data dictionary, Oracle SQL Code_1
Contents
Task 1 – ER Diagram....................................................................................................................................3
Task 2 – Relational Data logical model........................................................................................................3
Task 3 – Data dictionary..............................................................................................................................3
Task 4 – Oracle SQL Code............................................................................................................................5
ER Diagram, Relational Data logical model, Data dictionary, Oracle SQL Code_2
Task 1 – ER Diagram
Task 2 – Relational Data logical model
Student (studentID, firstName, lastName, major, dob, address)
Primary key (studentID)
Enrollment (enrollmentID, classID, studentID, marks)
Primary key (enrollmentID)
Foreign key (classID) references class (classID)
class (classID, subject, lecturerID, campus, semester)
Primary key (classID)
Foreign key (lecturerID) references lecturer (lecturerID)
Foreign key (subject) references subject (subjectID)
Foreign key (campus) references location (campus)
Lecturer (lecturerID, firstName, lastName,subject)
Primary key (lecturerID)
Foreign key (subject) references subject (subjectID)
Subject (subjectID, name, students)
Primary key (subjectID)
Location (campus,buildingNo,roomNo)
Primary key (campus)
ER Diagram, Relational Data logical model, Data dictionary, Oracle SQL Code_3
Task 3 – Data dictionary
Table Name Attribute
Name
Contents Type Format Range Required PK?FK FK Reference
tabke
Student
StudentID Student
registration
ID
Char(5) 12345 Y PK
firstName Student’s
firstname
Varchar2(50) Aaaaa Y
lastName Student’s
lastname
Varchar2(50) Aaaaa Y
Major Student’s
major
Varchar2(50) Aaaaa Y
Dob Student’s
date of birth
Date dd-Mon-
yyyy
Y
Address Address of
the student
Varchar2(50) AAaaa Y
Lecturer
lecturerID Lecturer’s ID Char(5) 12345 Y PK
firstName Lecturer’s
first name
Varchar2(50) Aaaa Y
lastName Lecturer’s
last name
Varchar2(50) Aaaa Y
Class
ClassID Id of the class integer 1 1-10000 Y PK
subject Title of the
course
Char(6) BIT235 Y
lecturerID Lecturer ID Char(5) 12345 Y FK Lecturer
campus The campus
offering the
course
Varchar2(50) Aaaaa Y
Enrollment
EnrollmentI
D
Unique
enrollment ID
integer 1001 1001-
999999
Y PK
classID ID of the
class
integer 1 Y FK class
studentID ID of the
student
Char(5) S001 Y FK Student
marks Grade
obtained
Char(2) HD N
Subject
subjectID Id of the
subject
Char(6) BIT235 Y PK
ER Diagram, Relational Data logical model, Data dictionary, Oracle SQL Code_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
ER Diagram, Relational Data Logical Model, Data Dictionary
|6
|563
|75