IMAT5103 Database Systems and Design - EER Modelling & SQL
VerifiedAdded on 2023/04/21
|12
|558
|120
Homework Assignment
AI Summary
This document presents a comprehensive solution for a database systems and design assignment, focusing on EER modeling and SQL implementation. The assignment begins with selecting a scenario, in this case, a football event system, and then proceeds to develop a conceptual database design, including business rules. Following this, a logical database design is created, detailing tables for matches, teams, stadiums, and referees. The solution then demonstrates the creation of these tables using Oracle DBMS and includes the implementation of four useful indexes for each table. Data population is performed, followed by the writing of six SQL queries to retrieve specific information from the database. The assignment concludes with a bibliography. This assignment is designed to assess the student's ability to analyze a problem domain, design a database system, and implement it using appropriate modeling techniques and data manipulation languages, as required for the IMAT5103 Database Systems and Design module.
1 out of 12