BIT358: Advanced Database Project - Melbourne Polytechnic
VerifiedAdded on  2021/05/25
|10
|1155
|310
Project
AI Summary
This document presents a complete solution to the BIT358 Advanced Database Project, focusing on the design and implementation of a database system for Melbourne Polytechnic. The assignment includes an Entity-Relationship (ER) diagram illustrating the entities and their relationships, such as student, faculty, degree course, and academic course. A relational data logical model is also provided, detailing the tables, attributes, primary keys, and foreign keys. A data dictionary defines each table's attributes, data types, and constraints. Furthermore, the solution includes SQL code demonstrating table creation, data insertion, and database modifications. The project covers various aspects of database design and implementation, providing a practical application of database concepts for managing student registration, academic courses, and grading processes within the university setting. The solution includes screenshots of the SQL code, demonstrating the successful implementation of the database schema and the execution of SQL queries.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
1 out of 10