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

Explain the functions and components of ddbms, Question 1 Explain the conc...

Question 1 Explain the concept of database recovery management. Explain the different levels of backup used for recovering data Question 2 What are the different types of par

Convert the erd into its relevant relational schema, Question: Describe...

Question: Describe briefly the three parts of the Relational Model. (a) The term integrity refers to the accuracy or correctness of the data in the database. Define the fol

Drop table command, DROP TABLE Command: When an existing object is not ...

DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas

Why were functional methods fashionable in early days, Why were functional ...

Why were functional methods fashionable in early days? These are inspired directly by computer architecture and thus popular among computer scientist in early days. The divisio

Give an example of operations from the state actions, Give an example of op...

Give an example of operations from the State Actions and Activities. For instance, in bank the activity verify account code and verify password

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

What is gathering information and producing erd, What is Gathering informat...

What is Gathering information and Producing ERD Gathering information: This could be a written document that explains the system in question with reasonable quantity of detai

Sorting field groups we cannot use more than one key field, While sorting f...

While sorting field groups we cannot use more than one key field False.

Rules of data normalisation, Rules Of Data Normalisation Let us now su...

Rules Of Data Normalisation Let us now summarise Normalisation with the help of various clean rules. The following are the necessary rules for the Normalisation process: 1.

How many types of data independence have, Types of data independence D...

Types of data independence Data independence can be classified into the following two types: Physical Data Independence: This means that for any change made in the physi

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages