Database Systems and Design

Running head: DATABASE SYSTSEM AND DESIGN
Database systems and design
Name of the Student:
Name of the University:
Author Note

1
DATABASE SYSTEM AND DESIGN
Stage 1: Scenario and Conceptual Database Design Task
1.1: Selection of the case upon which the database design and implementation is to be
based
The report is used for the description of the school database has been used in this
report.
Task 1.2: Provide a conceptual database design for your scenario & the list of enterprise
rules being modelled
Business Rules

2
DATABASE SYSTEM AND DESIGN
The business rules on which the development of the database is done are described
below:
 The database should be able to store the details of the students identified by their
unique id.
 The database should be storing the details of the faculty in the system.
 The database should be able to store the details of the course in the system.
 The database should be able to store the details of the Enrolment of the students in the
system.
Stage 2: Logical Database Design and Oracle SQL Implementation/querying
Task 2.1: Provide a Logical Database Design for your scenario
Student (StudentID (pk), StudentName, StudentAddress, StudentContact)
Course (CourseID (pk), CourseName, CourseDuration)
Faculty (FacultyID (pk), FacultyName, FacultyAddress)
Enrollment (EnrollmnetID (pk), FacultyID (fk), StudentID (fk), CourseID (fk))
Task 2.2 Create the tables using Oracle DBMS
Database tables
Student

3
DATABASE SYSTEM AND DESIGN
Course
Faculty