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:

  1. What is the total value of all consignments
  2. List out the Consignment Number, Agent Name and Destination of every consignment.
  3. List out the total value of all Consignments handled by Agent "Jane Doe".
  4. 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.
  5. List out the agents not currently handling any consignments
  6. List out any consignment numbers that will travel on more than one voyage
  7. List out any consignment numbers that have not yet been scheduled for transport
  8. List out the total number of consignments allocated to each vessel name

You will need to hand in ONE script which:

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

Related Discussions:- Create the database in oracle using ddl

Describe the storage structure of indexed sequential files, Describe the st...

Describe the storage structure of indexed sequential files and their access method.  Ans:   Storage structure of Indexed Sequential files and their access: To achieve fast rand

What is persistency, What is persistency? Persistency ensures which dat...

What is persistency? Persistency ensures which data is stored and that after the object is no longer available (program stops running) the data will be available to other users

Locking, define locking in simple language and decribed it

define locking in simple language and decribed it

Explain the dependency relationship of object oriented, Explain the depende...

Explain the dependency relationship of object oriented A dependency is a relationship which states that a change in specification of one thing can affect another thing, but n

Data control, Identify the need and use of data control through problem sol...

Identify the need and use of data control through problem solving, illustration

What is a view, What is a view? How it is related to data independence? ...

What is a view? How it is related to data independence? A view might be thought of as a virtual table, that is, a table that does not really exist in its own right but is inste

In which relational modes cardinality is termed, In which relational modes,...

In which relational modes, cardinality is termed? Answer : Cardinality is termed in a number of tuples relational modes.

Er diatgrams, Ask q“A database will be made to store information about pati...

Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher

1) Information about a bank is about customer, 1) Information a...

1) Information about a bank is about customers and their account. Customer has a name, address which consists of house number, area and city, and one or more phone numbers. Ac

Differentiate between a subquery and a join, Differentiate between a subque...

Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd