BIT358: Advanced Database Assignment

Added on - 25 May 2021

  • 10

    Pages

  • 1155

    Words

  • 41

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 3 of 10 pages
BIT358: AdvancedDatabaseStudent nameStudent ID
BIT358: AdvancedDatabaseTable of ContentsTask 1: ER diagram.................................................................................................................................3Task 2: relational data logical model.....................................................................................................3Task 3: data dictionary...........................................................................................................................4Task 4:SQL code.....................................................................................................................................7
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 andgrade details. With over increasing in student number they have to implement a reporting systemwhich will assist them to store and evaluate all the details. The polytechnic university mainly offersthree 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. Thediagram consists of entities such as student, student registration, faculty, degree course, academiccourse, department and degree grades. Every entity is filled with appropriate attributes, primarykeys 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)
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document