Create the database in oracle using ddl, Database Management System

Assignment Help:

The Assessment page has a link to download a conceptual model, and a list of data.

You are to map this conceptual model, and create the database in Oracle using your own DDL. Then load your database with the list of data on the assessment page.

Then you are required to write SQL statements to perform the objectives listed below:

What is the total value of all consignments
List out the Consignment Number, Agent Name and Destination of every consignment.
List out the total value of all Consignments handled by Agent "Jane Doe".
List out the commission for each Agent, assuming that Commission is calculated at 2% of the total value of the consignments that the Agent handles.
List out the agents not currently handling any consignments
List out any consignment numbers that will travel on more than one voyage
List out any consignment numbers that have not yet been scheduled for transport
List out the total number of consignments allocated to each vessel name

You will need to hand in ONE script which:

Creates the required physical tables, indexes etc in Oracle
Loads the data,
Performs the SQL queries above

Related Discussions:- Create the database in oracle using ddl

Oracle SQL Developer, Introductory course and so does not require any fancy...

Introductory course and so does not require any fancy coding. I will provide a guidance document to help you in producing the solutions.

Define deadlock term, a. Define the term "deadlock". There are four conditi...

a. Define the term "deadlock". There are four conditions that must hold before deadlock is possible. Name them. b. Outline an algorithm that detects whether there is a deadlock.

Datawarehouse, Explain four causes for failures in data warehouse projects

Explain four causes for failures in data warehouse projects

Define the terms ddl and dml, Define the terms i) DDL ii) DML DDL: Data...

Define the terms i) DDL ii) DML DDL: Data base schema is particular by a set of definitions expressed by a special language known as a data definition language. DML: A data

How can redundant associations be done, How can Redundant Associations be d...

How can Redundant Associations be done It can be done by asking questions: i) Is there a specific arrangement of network which would optimize critical aspects of completed

Define the terms entity, Define the terms entity, attribute, role and relat...

Define the terms entity, attribute, role and relationship between the entities, giving examples for each of them. Ans: Entity: An entity is a "thing" or "object" in th

Explain retrieval in qbe, Explain retrieval in QBE? Retrieval in QBE : ...

Explain retrieval in QBE? Retrieval in QBE : A "GUI" for expressing queries. Based on the Domain Relational Calculus (DRC) Actually invented before GUIs. Very co

Skills required, wrie a report on whether a BSc n information systems devel...

wrie a report on whether a BSc n information systems develops the skills required by employers in Database administration

Microsoft access database assigment, Hello.I have database access assignmen...

Hello.I have database access assignment which consist of creation Form, Subform, Calculation, Macros

Components of a typical database environment, Question: (a) List four d...

Question: (a) List four disadvantages of the File Processing System as compared to the Database Systems. (b) The integrity of a database is enforced by integrity rules. One

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages