logo

Database Management System Assignment

   

Added on  2020-02-24

11 Pages1016 Words204 Views
 | 
 | 
 | 
ACCOUNTING AND INFORMATION SYSTEMS
Database Management System Assignment_1

Table of Contents1.Tables............................................................................................................................................22.ER Diagram.................................................................................................................................33.Queries..........................................................................................................................................43.1Query – Postcode Lookup...................................................................................................43.2Query – SuburbB.................................................................................................................43.3Query – Telephone lookup..................................................................................................53.4Query – D or HD..................................................................................................................63.5Query – Spring.....................................................................................................................63.6Query - Tech classes............................................................................................................73.7Query - Smith.......................................................................................................................84.Form.............................................................................................................................................9References..........................................................................................................................................101
Database Management System Assignment_2

1.TablesStudent Database contains the four table such as student, enrolment, teacher and unitstable (Bhatia and Bansal, 2015). Table EnrolmentThe enrolment table contains the enrolment ID, student ID, unit code, unit name, year,semester and grade. The Enrolment ID is the primary key and Student ID is the foreign key.Table StudentThe Student table contains the student ID, first name, last name, address, suburb area, postcode, telephone number, enrolment ID and teacher ID. The Student ID is the primary key andEnrolment ID and teacher ID is the foreign key. Table TeacherThe Teacher table contains the teacher ID, teacher name and Student ID. The teacher ID isthe primary key and Student ID is the foreign key. 2
Database Management System Assignment_3

Table UnitsThe unit table contains the unit code, unit name and Student ID. The Unit code is the primarykey and student ID is the foreign key. 2.ER DiagramThe Student Database Entity relationship diagram is shown below.3
Database Management System Assignment_4

End of preview

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

Related Documents