In Progress

Advanced Database Systems

Below are the Coursework Requirements ! the flie is attached below

Conceptual Design Stage

Design a class diagram that will capture the data, links and constraints capable of supporting the requirements outlined above. The figures provide some sample data to give you additional information on the kind of data you will need to store. You are not required to reproduce any particular formatting. The model needs to capture the data requirements in order for the system to work.

You need to prepare class diagram with constraints and assumptions.

Relational Design Stage

You will now undertake the design of a relational database for TFR. This will involve the following activities:

• Revise your class diagram in the light of the feedback you have received from the peer marking session

• Convert the class diagram into a relational model using the notes from the workshop (posted on Blackboard as ‘From Class Diagram to Relational Model’ in the Assignments folder). A relational model consists of relations with attributes and their data types, primary and foreign keys.

Implementation Stage

The final stage will be to implement your design using Oracle, demonstrate it and write a final report. You will need to perform the following activities:

• Convert your relational model into an SQL database using the notes from the workshop (posted on Blackboard in the ‘SQL Plus Tutorials’ folder in the Assignments folder).

• Populate your database with some sample data

• Test your database. You will need to consider testing the database to ensure that the database meets the information requirements of the system. You need to create and run SQL queries that produce the information required. You do not need to consider the formatting of the data.

Skills: Database Administration, MySQL, Oracle, Research Writing, SQL

See more: tutorials on testing, advanced tutorials, sql database report, oracle queries, database design sample, sql final, coursework report, create sql report, oracle relational, write relational database, sql report write, diagram relational model, convert sql database, write sql queries, report coursework, populate database, model light, using oracle, prepare tutorials, relational database design, database design conceptual, sql create report, Create sql database, write report database, need class diagram

About the Employer:
( 4 reviews ) london, United Kingdom

Project ID: #4242580

Awarded to:


I already did similar tasks before. Please check PMB for more details.

£100 GBP in 3 days
(21 Reviews)

2 freelancers are bidding on average £110 for this job


Please see PM

£120 GBP in 5 days
(4 Reviews)