Ask a question from expert

Ask now

Database Entity Relationship || Assignment

11 Pages1016 Words204 Views
   

Australian Institute of Higher Education

   

Added on  2020-02-24

Database Entity Relationship || Assignment

   

Australian Institute of Higher Education

   Added on 2020-02-24

BookmarkShareRelated Documents
ACCOUNTING AND INFORMATION SYSTEMS
Database Entity Relationship || 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 Entity Relationship || 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 Entity Relationship || 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 Entity Relationship || Assignment_4

End of preview

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

Related Documents
Database Design & Development - PDF
|16
|1036
|22

Accounting Information System for Desklib - ER Diagram, Tables, Relationships, Query, Form, Report, Risks, Future Improvements
|23
|1752
|138

Entity Relationship Diagram (ERD) represents the real-world objects as Entities and relationship between them.
|15
|1780
|11

Normalized CQI Database Design and Development (T12018) Assessment Item 2 - Assignment 2 Student ID: Tutor: 2018 5/17/2018
|8
|769
|200

COIT20247 Database Design and Development - PDF
|8
|767
|87

COIT20247 - Database Design and Development
|8
|824
|70