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

Describe dynamic model, Describe Dynamic Model. The dynamic model speci...

Describe Dynamic Model. The dynamic model specifies allowable sequences of changes to the objects from an object model. It contains event trace diagrams describing scenarios. A

Project, I need help in doing my dbms project

I need help in doing my dbms project

Can you scan double-sided documents and remove blank pages, Can you scan do...

Can you scan double-sided documents - and remove blank pages? Our software and imaging systems supports duplex scanning, at the same time scanning both sides of a page. Program

Create an er diagram completely with attributes, A database is to be constr...

A database is to be constructed to remain track of the teams and games of a sport league. A team has a number of players, not all of whom participate in every game. It is desired

What is object identity, What is object identity? An object retains its...

What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

List two restrictions that are applied on the modification, List two restri...

List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

To delete a particular column in a relation which command, To delete a part...

To delete a particular column in a relation which command is used ? To delete a particular column in a relation ALTER command is used.

Transaction, Draw the precedence graph of the following schedule and determ...

Draw the precedence graph of the following schedule and determine whether the schedule is serializable. (Note that all instructions, except lock and unlock, are omitted. We assume

Compare wait-die deadlock prevention with wait-wound scheme, Compare wait-d...

Compare wait-die deadlock prevention scheme with wait-wound scheme   Ans:  Wait-Die Scheme  a) Based upon a nonpreemptive technique.  b) If Pi requests a resource present

What are the storage types, What are the storage types? The storage typ...

What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage

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