Advanced Database Applications Project: Sonic Live Database Design

This assignment provides a detailed database solution for the Sonic Live case study, a UK-based audio equipment rental company. The solution encompasses the creation of both conceptual and logical Entity-Relationship Diagrams (ERDs) to model the company's data structure. It explores the differences and similarities between Relational Database Management Systems (RDBMS) and Object-Relational Database Management Systems (ORDBMS). The assignment includes complete SQL Data Definition Language (DDL) statements for creating tables and establishing relationships within the database. Furthermore, the project addresses the implementation of a distributed relational database environment, utilizing fragmentation techniques to ensure data integrity and location transparency. The solution includes examples of horizontal, vertical, and mixed fragmentation strategies. The assignment concludes with a discussion of database links and views to provide location transparency.