Ask Programming Language Expert

1) CREATE YOUR DATABASE TABLES

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.

2) KEYS

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.

4) CREATE FOUR (4) BUSINESS REPORTS

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.

5) USE OF BUILT-IN FUNCTIONS

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

Assignment - haskell program for regular expression

Assignment - Haskell Program for Regular Expression Matching Your assignment is to modify the slowgrep.hs Haskell program presented in class and the online notes, according to the instructions below. You may carry out th ...

Assignment task -q1 a the fibonacci numbers are the numbers

Assignment Task - Q1. (a) The Fibonacci numbers are the numbers in the following integer sequence, called the Fibonacci sequence, and are characterised by the fact that every number after the first two is the sum of the ...

Question - create a microsoft word macro using vba visual

Question - Create a Microsoft Word macro using VBA (Visual Basic for Applications). Name the macro "highlight." The macro should highlight every third line of text in a document. (Imagine creating highlighting that will ...

Assignmentquestion onegiving the following code snippet

Assignment Question One Giving the following code snippet. What kind of errors you will get and how can you correct it. A. public class HelloJava { public static void main(String args[]) { int x=10; int y=2; System.out.p ...

Assignment - proposal literature review research method1

Assignment - Proposal, Literature Review, Research Method 1. Abstract - Summary of the knowledge gap: problems of the existing research - Aim of the research, summary of what this project is to achieve - Summary of the a ...

1 write a function named check that has three parameters

1. Write a function named check () that has three parameters. The first parameter should accept an integer number, andthe second and third parameters should accept a double-precision number. The function body should just ...

Assignment - horse race meetingthe assignment will assess

Assignment - Horse Race Meeting The Assignment will assess competencies for ICTPRG524 Develop high level object-oriented class specifications. Summary The assignment is to design the classes that are necessary for the ad ...

Task silly name testeroverviewcontrol flow allows us to

Task: Silly Name Tester Overview Control flow allows us to alter the order in which our programs execute. Building on our knowledge of variables, we can now use control flow to create programs that perform more than just ...

Structs and enumsoverviewin this task you will create a

Structs and Enums Overview In this task you will create a knight database to help Camelot keep track of all of their knights. Instructions Lets get started. 1. What the topic 5 videos, these will guide you through buildi ...

Task working with arraysoverviewin this task you will

Task: Working with Arrays Overview In this task you will create a simple program which will create and work with an array of strings. This array will then be populated with values, printed out to the console, and then, w ...

  • 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

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As