Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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

Suppose the heap consists of exactly the nine cars on three

Suppose the heap consists of exactly the nine cars on three trains shown in given figure (i.e., ignore the ellipses). Object o in car 11 has references from cars 12, 23, and 32. When we garbage collect car 11, where migh ...

Contact list project where the user enters first name last

Contact list project where The user enters first name, last name, street address, email address, phone number and notes. Use Case Name: Enter a new person ID number: 1 Actors: user Preconditions: The user has chosen to e ...

Create a class named order that performs order processing

Create a class named Order that performs order processing of a single item. The class has the following five fields: Customer name Customer number Quantity ordered Unit price Total price Include set and get methods for e ...

Question 1briefly explain these main programming paradigm

Question 1: Briefly explain these main programming paradigm (Logic, Functional, Object Oriented, Procedural, Imperative and Aspect-oriented), and for each of these paradigms name at least one language that can be used fo ...

Lab 1a box of cookies can hold 24 cookies and a container

Lab 1 A box of cookies can hold 24 cookies, and a container can hold 75 boxes of cookies. Write a program that prompts the user to enter the total number of cookies, the number of cookies in a box, and the number of cook ...

1 design a class called complex the class enables

1) Design a class called Complex. The class enables operations on so called complex numbers. These are numbers of the form realPart + imaginary Part *i, where the i has the value 2) Design the class to have two private m ...

The car classdefine a class called car that implements the

The Car Class Define a class called "Car" that implements the parameterized Comparable interface. Each object of this class represents a type of car. Your class must provide all the methods in the public interface. Be su ...

Programming assignmentdescription your algorithm first

Programming Assignment Description: Your algorithm first takes an input size (N) from the user and generates a random sequence of N integers ranging from -99999 to 99999. If N is less than 50, your program must print the ...

Create a base class that will include the properties of

Create a base class that will include the properties of some type of data related to the company you work for or a favorite hobby. For example, I work for a healthcare provider, so my base class might be "Medical Facilit ...

Pennies for pay you are hired for a job and your employer

Pennies for Pay You are hired for a job and your employer agrees to pay you each day. Your pay rate will be one penny the first day and two pennies the second day, four pennies the third day and continuing to double each ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro