logo

BIT358: Advanced Database Assignment

10 Pages1155 Words310 Views
   

Added on  2021-05-25

BIT358: Advanced Database Assignment

   Added on 2021-05-25

ShareRelated Documents
BIT358: AdvancedDatabaseStudent nameStudent ID
BIT358: Advanced Database Assignment_1
BIT358: AdvancedDatabaseTable of ContentsTask 1: ER diagram.................................................................................................................................3Task 2: relational data logical model.....................................................................................................3Task 3: data dictionary...........................................................................................................................4Task 4:SQL code.....................................................................................................................................7
BIT358: Advanced Database Assignment_2
BIT358: AdvancedDatabaseTask 1: ER diagramBusiness studyMelbourne polytechnic is an overgrowing university situated in Australia. Their existing database hasoverwhelmed with tremendous tedious data which are student registration,personal details and grade details. With over increasing in student number they have to implement a reporting system which will assist them to store and evaluate all the details. The polytechnic university mainly offers three major streams as software development, business information system and network security. The new system must be able to sort and filter every details for reporting and grading process. The ER diagram has been developed for Melbourne polytechnic as shown in figure 1. The diagram consists of entities such as student, student registration, faculty, degree course, academic course, department and degree grades. Every entity is filled with appropriate attributes, primary keys and foreign keys are also been set.Figure1: the ER diagram suited for Melbourne polytechnicTask 2: relational data logical modelStudent1332(student1332_id, first name, second name, email, department_id1332)Department1332(Department1332_id, Department1332_name, Department1332_code, department description)Degree course1332(Degree course1332_id, Degree course1332_name, course difficulty, course type)
BIT358: Advanced Database Assignment_3

End of preview

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

Related Documents
ER Diagram, Relational Data Logical Model, Data Dictionary
|6
|563
|75

ER Diagram, Relational Data logical model, Data dictionary, Oracle SQL Code
|12
|1599
|46

MyPoly Airlines - Database
|14
|1586
|168

Database Concepts for Video Game Centre Database
|19
|3019
|66

Case Study Project on Normalisation
|5
|749
|393