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


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.


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.


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.


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


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.

Posted Date: 3/22/2013 3:29:45 AM | Location : United States

Related Discussions:- Create data base table apply key and functions, Assignment Help, Ask Question on Create data base table apply key and functions, Get Answer, Expert's Help, Create data base table apply key and functions Discussions

Write discussion on Create data base table apply key and functions
Your posts are moderated
Related Questions
Guidelines for creation of table: Table name should begin with an alphabet. In table name, single quotes and blank spaces are not allowed. Reserve words of that DBM

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

QUESTION (a)(i) Define the term database. (ii) How is it different from a database management system? (b) What is the difference between an entity and an attribute? (c

Question 1 Create a table student with attributes student name, roll number, total marks and percentage. Do the following operations Insert details in to the table Update

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR managem

Define union compatibility? Explain why INTERSECTION of two relations cannot be performed if they are not union compatible? Two relations R(A1, A2,-------, An) and S(B1, B2,--

I have a small project that contains 3 deliverable s. I have done the first one and I would like you to help me with second one

Describe the two alternatives for specifying structural constraints on relationship kinds? Relationship kinds have certain constraints in which limit the possible combination o

What are the situations while DBMS should not be used? DBMS should not be used in situations like: (i) No need of security. (ii) Not difficulty to access the data (iii) N

Describe the algorithm for updating indices for a single level index when a record is    (i) Inserted  (ii)  deleted What will be the modification if there are multilevel in