Create data base table apply key and functions, Database Management System

Assignment Help:

CREATE YOUR DATABASE TABLES

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

1) KEYS

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

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

You need to collect real data for your tables. Please, include complete bibliographical references for your data sources. You can 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.

3) CREATE FOUR (4) BUSINESS REPORTS

You can design any four reports you like for this requirement.

You need to use commands like BREAK, COMPUTE, ORDER BY, GROUP BY as well as SQLPLUS commands. Include page number, today's date, 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.

4) USE OF BUILT-IN FUNCTIONS

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

5) 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 textbook.

5.3) Five (5) DATE and TIME functions from Chapter 9.

5.4) Five (5) CONVERSION and TRANSFORMATION functions from

6) Produce one or more SQL scripts to demonstrate the use of

JOIN, OUTER JOIN, CARTESIAN PRODUCT, CORRELATED SUBQUERY,

EXISTS, UNION, INTERSECT and MINUS. Introduce remarks or comments in your scripts to explain 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 demonstrate 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 demonstrate the use of variables with the form  &variablename, ACCEPT, and DEFINE. Show that it works.

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

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

12) Create a table from an existing table.

13) Create an INDEX for one of your tables.


Related Discussions:- Create data base table apply key and functions

What are the causes of bucket overflow in a hash file, What are the causes ...

What are the causes of bucket overflow in a hash file organization? What can be done to reduce the occurrence of bucket overflow? When a record is inserted, the bucket to that

Sql insert statements, Submit SQL INSERT Statements that will populate the ...

Submit SQL INSERT Statements that will populate the database with sample data.  You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement

Draw enhanced er-diagram for hierarchy of a student database, Draw an EER d...

Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)

What is the use of sub queries, What is the use of sub queries? A sub q...

What is the use of sub queries? A sub query is a select-from-where expression that is nested with in another query. A common use of sub queries is to do tests for set membershi

Log based recovery, under what condition log based recovery is feasible?

under what condition log based recovery is feasible?

Define ssn of salesman by using database of business trips, Consider the su...

Consider the subsequent relations for a database which keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, start_year, Dept_no) TRIP (SSN, Fr

With the help of a diagram defines typical element modules, With the help o...

With the help of a diagram defines the typical element modules of a DBMS? The functional elements of a database system can be widely divided into: 1) Storage manager and 2) q

The users who use easy-to-use menu are called, The users who use easy-to-us...

The users who use easy-to-use menu are called ? The users who use easy to use menu are called as Naïve users.

Design a query plan for distributed query, (a) Design a query plan for the ...

(a) Design a query plan for the following distributed query: An application at site B wants to compute a join of STUDENT ? Id=StudId TRANSCRIPT where STUDENT (Id,Major) is at site

Relational database management, For this application, we will consider IBM ...

For this application, we will consider IBM DB2 catalog data (i.e., metadata) for IBM's enterprise-class servers running the z/OS (formerly OS/390 or MVS) operating system.  One of

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd