Ask Question, Ask an Expert


Ask Programming Language Expert


Your database project should have a minimum of four tables. Include the SQL scripts used to create the tables in your documentation. Describe the tables created, their purpose, and organization. describe all the tables created.


All tables should have a primary key. Some of the tables should have one or more foreign keys. The tables should be linked to some other tables. The tables should not be independent and  unrelated.

3) POPULATE YOUR TABLES (does not need to be real data)

You require to collect real data for your tables. Include complete bibliographical references for your data sources. You could also use internet or web sources. Your tables must have enough rows so that you can produce the reports required in future steps. Populate one table with the INSERT command and populate the other remaining tables with the SQL*LOADER utility. Include the scripts used to populate your database tables in your project documentation. Print all the records in each table created and include it in your documentation.


You could design any four reports you like for this requirement. You require to use commands like BREAK, COMPUTE, ORDER BY, GROUP BY as well as SQLPLUS commands. Include page number, today's date, and column names, report title at the top and also at the bottom. Produce totals and subtotals in your reports.

Include in the project documentation the scripts used to produce your business reports.


Your require to create one or more SQL scripts to demonstrate the use of ORACLE built in functions. You require to include the following types of built in functions in your scripts and reports:

5.1) Five (5) STRING functions from chapter 7, table 7.1 described in our ORACLE9i: The complete Reference textbook. You choose the five functions you want.

5.2) Five (5) NUMBER or MATH functions from Chapter 8, table 8.1 in our ORACLE9i: The complete Reference textbook.

5.3) Five (5) DATE and TIME functions from Chapter 9 in our ORACLE9i: The complete Reference textbook.

5.4) Five (5) CONVERSION and TRANSFORMATION functions from Chapter 10, table 10.2, in our ORACLE9i: The complete Reference textbook.

6) Produce one or more SQL scripts to show the use of JOIN, OUTER JOIN, CARTESIAN PRODUCT, CORRELATED SUBQUERY, EXISTS, UNION, INTERSECT and MINUS. Introduce remarks or comments in your scripts to describe what you are doing. Include your SQL scripts in your project documentation.

7) Create two VIEWs for your database project. describe the views and print all records from your view. Include your scripts and reports in your documentation.

8) Produce a script to show the use of INSERT, DELETE and UPDATE. Show that your script works. Include your scripts and reports in your documentation.

9) Produce a script to show the use of variables with the form  &variablename, ACCEPT, and DEFINE. Show that it works.

10) Produce a script to show the use of TRANSLATE and DECODE functions. Show that it works.

11) Produce the script to show three (3) different changes in a table using ALTER TABLE.

12) Create the table from an existing table.

13) Create the INDEX for one of your tables.

Programming Language, Programming

  • Category:- Programming Language
  • Reference No.:- M91746

Have any Question? 

Related Questions in Programming Language

Concurrent programming task ydetailsmany banking systems

CONCURRENT PROGRAMMING TASK YDETAILS Many banking systems allow multiple cardholders access a single account (e.g. a business account). The consequence of this is that is possible for more than one person to attempt to w ...

Complete the attached code and do junit testing can you

Complete the attached code and do junit testing. Can you help with this? Testing class tests Check Date methods serves as a "test plan" for developer's testing. Complete/correct and test/demonstrate using Junit with test ...

Consider the following three programswhere i k l are low

Consider the following three programs: where i, k, l are low variables and a, b, c, d, h, n are high variables. Assume db is a database with two columns (shown as array, where the index represents the row), lookup and is ...

Programming assignment- implement a udp client and udp

PROGRAMMING ASSIGNMENT- Implement a UDP client and UDP server that support simple timeout-based retransmission with AIMD congestion control: -The client should send as many packets as are in its CURWIN (current window) a ...

Operating systems assignment-1 binary record sorting in

Operating Systems Assignment- 1. Binary Record Sorting in Ascending Order| You will write a simple sorting program. This program should be invoked as follows: shell% ./fastsort -i inputfile -o outputfile The above line m ...

Shell programmingyou have created the directory structure

Shell Programming You have created the directory structure and some base files to be used by the Web server and Web site. For the Web site to be created in a production environment, you need to package your commands in a ...

1 implement dfs by using prolog2 implement bfs by using

1. Implement DFS by using PROLOG. 2. Implement BFS by using PROLOG. 3.  Solve the problem of Question 3 in Assignment 1 by using your PROLOG programs of DFS and BFS, respectively. Question 3 from Assignment 1 to Solve wi ...

The briefyour small development team of ideally three

The Brief Your small development team of (ideally) three people has been asked to implement and test the Human Resource Information System desktop application. Your software product will be a database- backed desktop app ...

Part a-1 what arguments can you make for the idea of a

Part A- 1. What arguments can you make for the idea of a single programming language for all programming domains? It would be ideal to have a single programming language for all 2. What arguments can you make against the ...

Questioncomplete tutorial 10 case problem 2 - ridgewood

Question: Complete Tutorial 10 Case Problem 2 - Ridgewood Herald Tribune found on pages 734-736 of your textbook. Complete the entire website assignment and upload your files to your 000WebHost account. After uploading t ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate