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

Posted Date: 3/2/2013 2:21:32 AM | Location : United States

Ask an Expert

Related Discussions:- Create the database in oracle using ddl, Assignment Help, Ask Question on Create the database in oracle using ddl, Get Answer, Expert's Help, Create the database in oracle using ddl Discussions

Write discussion on Create the database in oracle using ddl
Your posts are moderated

Write your message here..

Related Questions

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

What is an object id, What is an object ID? Each class-derived table ha... What is an object ID? Each class-derived table has an ID for primary key, one or more object IDs form primary key for association derived tables. An object ID is equivalent dat

What are the acid properties?, Question 1 What are the advantages of DBMS ... Question 1 What are the advantages of DBMS approach in managing data? Question 2 What are the services provided by a database system Question 3 List and briefly describe

Pl/SQL, I need solution of the question posted at http://www.expertsmind.c... I need solution of the question posted at http://www.expertsmind.com/questions/sql-query-for-testing-triggers-and-stored-procedures-30140149.aspx

Insert statement reverses storage space and transfers value, A field-groups... A field-groups statement or an insert statement reverses storage space and transfers values. False.

Help, #questiononsider the following relation: CAR_SALE =(CAR_ID,oPTION_TYP... #questiononsider the following relation: CAR_SALE =(CAR_ID,oPTION_TYPE, Option_listpreice, Sale_date, Option_discountedprice)..

Describe dynamic model, Describe Dynamic Model. The dynamic model speci... Describe Dynamic Model. The dynamic model specifies allowable sequences of changes to the objects from an object model. It contains event trace diagrams describing scenarios. A

Give the relational calculus queries of players in sql, An orchestra databa... An orchestra database consists of the following relations: CONDUCTS (conductor, composition) REQUIRES (composition, Instrument) PLAYS (Player, Instrument) Give the relational

Database project- inventory database for a hardware store, Normal 0 ... Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Explain the dynamic hashing techniques, Explain the Dynamic Hashing Techniq... Explain the Dynamic Hashing Techniques There are two methods in it: extendible hashing - stores an access structure in addition to the file, and therefore is somewhat identica