Advanced Database Applications

University
Semester
ADVANCED DATABASE APPLICATIONS
Student ID
Student Name
Submission Date
1

Table of Contents
Task One - Conceptual Entity-Relationship Diagram for Sonic Live..........................................................3
Task Two - Logical Entity-Relationship Diagram for Sonic Live...............................................................4
Task Three - Use of RDBMS and ORDBMS..............................................................................................5
Similarities..............................................................................................................................................5
Differences..............................................................................................................................................5
Task Four - SQL DDL statements...............................................................................................................6
Task Five - Implement a Distributed Relational Database Environment...................................................20
References.................................................................................................................................................25
Appendix...................................................................................................................................................26
2

Task One - Conceptual Entity-Relationship Diagram for Sonic Live
In this task, we are create the Conceptual Entity-Relationship Diagram for Sonic Live. It
is illustrated as below.
3

Task Two - Logical Entity-Relationship Diagram for Sonic Live
In this task, we are create the logical Entity-Relationship Diagram for Sonic Live. It is
illustrated as below.
4

Task Three - Use of RDBMS and ORDBMS
Below are the similarities and differences of relational database management system and object
relational database management system (Dick, 2018).
Similarities
i. They both support database creation.
ii. They both support creation of tables.
iii. They both support creation of relationships between database tables.
Differences
S.No RDBMS ORDBMS
1 It means
Relational Database Management
Systems
It means Object – Relational Database
Systems
2 It is mainly based on Relational Data
Models
It is mainly based on Object Data Models
(ODM)
3 It is the most dominated data model It is currently becoming popular.
5 It mainly supports data types which are
small and fixed in nature like integers,
date and strings.
It supports use of complex objects in the
object oriented database systems and
relational database systems.
6 It only support the use of Structured
Query Languages( SQL )
It only support Object Query Languages
(OQL).
8 It is able to support the use of Standard
data types and other additional data
types e.g. integer, date, and varchar
It is able to Support standard data types
and newer richer data typese.g. users-
defined data types, inheritance data types,
and object-identity data types (Michael,
2017).
5

Task Four - SQL DDL statements
Part One – Table Creation
Creation of table was successfully completed which is illustrated as below.
For Customer Table,
6

create table customer
( "customer_id" varchar2(20 byte),
"first_name" varchar2(20 byte),
"last_name" varchar2(20 byte),
"address" varchar2(20 byte),
"firstpointofcall" varchar2(20 byte)
)
For Driver Table,
create table driver
( "staff_id" varchar2(20 byte),
"van_no" varchar2(20 byte),
"van_type" varchar2(20 byte),
"license_no" varchar2(20 byte),
"make_model" varchar2(20 byte),
"bonus" varchar2(20 byte)
)
7

For equipment Table,
create table equipment
( "equipment_no" varchar2(20 byte),
"equipment_name" varchar2(20 byte),
"quantity" varchar2(20 byte),
"unitcost" varchar2(20 byte),
"morecareitem" varchar2(20 byte),
"lesscareitem" varchar2(20 byte)
)
For Equipment service Table,
8