Database Entity Relationship || Assignment

Added on -2020-02-24

| 11 pages| 1016 words| 204 views

Trusted by 2+ million users,
1000+ happy students everyday

Showing pages 1 to 4 of 11 pages

ACCOUNTING AND INFORMATION SYSTEMS
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

Found this document preview useful?

You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss

Premium

$45

Q&A Library Access

Chat support

12

Document Unlocks

4

Answer Unlocks

Students who viewed this