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
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
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
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Design & Development - PDFlg...
|16
|1036
|22
Accounting Information System for Desklib - ER Diagram, Tables, Relationships, Query, Form, Report, Risks, Future Improvementslg...
|23
|1752
|138
Entity Relationship Diagram (ERD) represents the real-world objects as Entities and relationship between them.lg...
|15
|1780
|11
Normalized CQI Database Design and Development (T12018) Assessment Item 2 - Assignment 2 Student ID: Tutor: 2018 5/17/2018lg...
|8
|769
|200
COIT20247 Database Design and Development - PDFlg...