logo

Data Management: The Queensland College database

Design a database for a new tertiary college to track staff, students, courses, and enrollments.

8 Pages1018 Words333 Views
   

Added on  2023-06-03

About This Document

This article discusses the conceptual design, logical design, and schema refinement and documentation of the Queensland College database. It includes tables and attributes, types, constraints, and foreign keys.

Data Management: The Queensland College database

Design a database for a new tertiary college to track staff, students, courses, and enrollments.

   Added on 2023-06-03

ShareRelated Documents
1
Running head: DATA MANAGEMENT
Data Management:
The Queensland College database
[Student Name]
[University Name]
Data Management: The Queensland College database_1
2
DATA MANAGEMENT
Table of Contents
Section I...........................................................................................................................................3
Task 1: Conceptual design...........................................................................................................3
Task 2: Logical design.................................................................................................................4
Task 3: Schema refinement and documentation..........................................................................5
Reference.........................................................................................................................................7
Data Management: The Queensland College database_2
3
STAFFS
Staffid
Fullname
DOB
Sex
postaladdress
Level
Position
Expertise
SCHOOL
Schoolid
Schoolname
Officelocation
Telephonenumber
Faxnumber
Headstaffid
Deputystaffid
Adminofficerstaffid
Headstartdate
Adminstartdate
OFFICE
Officeid
Roomid
Phonenumber
Building
Staffid
COURSE
Courseid
Classid
Classtype
Weekday
Time
Length
Roomno
Buidingno
Staffid
ACADEMICPROGRAM
Programid
Programname
Director
Courses
Courseid
Coursetype
Creditpoints
STUDENTS
Studentno
DOB
Sex
Nationality
Homeaddress
Dateenrolled
Email
Programid
NEXTOFKIN
Nextofkinid
Name
Phone
Address
Email
Relationship
Studentno
DATA MANAGEMENT
Section I
Task 1: Conceptual design
Data Management: The Queensland College database_3

End of preview

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