[go: up one dir, main page]
Scribd
Upload
1K views9 pages

Database Design Ii

This document outlines 9 practical assignments for a database design course. The practicals cover topics such as different types of databases, designing forms and triggers in Oracle 10g, generating reports using triggers, designing record structures and data dictionaries, indexing tables with multiple keys, retrieving and ordering information in databases, transaction processing using SQL, updating tables using SQL, and advanced SQL operations involving multiple tables. The goal is for students to gain hands-on experience with relational and object-oriented databases.

Uploaded by

Abdullahi Aliyu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
1K views9 pages

Database Design Ii

This document outlines 9 practical assignments for a database design course. The practicals cover topics such as different types of databases, designing forms and triggers in Oracle 10g, generating reports using triggers, designing record structures and data dictionaries, indexing tables with multiple keys, retrieving and ordering information in databases, transaction processing using SQL, updating tables using SQL, and advanced SQL operations involving multiple tables. The goal is for students to gain hands-on experience with relational and object-oriented databases.

Uploaded by

Abdullahi Aliyu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 9

DATABASE DESIGN II (COM 322)

PRACTICAL I

TOPIC: UNDERSTAND DIFFENT TYPES OF DATABASES

AIM: To identify various types of relational and object oriented database


management (DBMS) software.

OBJECTIVE: To let the students know the various types of relational and object
oriented database management system (DBMS) software.

APPARATUS/EQUIPMENT: Internet facilities, pen and paper

PROCEDURE:

- Visit the library or consult the internet and list out various types of
database management systems
- Group the various types into
- Relational DBMS
- Extended – Relational DBMS
- Object – Relational DBMS
- Object – Oriented DBMS
- Relational and Network DBMS
- Relational, Network and Hierarchical DBMS
- Hierarchical DBMS

OBSERVATION: State your observations

CONCLUSION: Draw conclusion based on above practical.

RESULT: Present the result of your work

1|Page
PRACTICAL 2

TOPIC: DESIGN A FORM WITH TRIGGER

AIM: To equip the student with the knowledge of designing forms and triggers
using Oracle 10G.

OBJECTIVE: To demonstrate how procedural code is automatically executed in


response to certain event on a table/view.

APPARATUS/EQUIPMENT: Oracle/MySQL database, a computer system,


printer

PROCEDURE:

- Install Oracle 10G (Enterprise Edition)


- Launch Oracle 10G
- Name the triggers
- Create the table to be associated to the trigger
- State when the trigger will be fired
- State command to invoke the trigger (insert trigger) e.g. Before trigger
- State the condition to filter the records.
- Execute the trigger

OBSERVATION: State your observations

CONCLUSION: Draw your conclusion

RESULT: Present the result of your work

2|Page
PRACTICAL 3

TOPIC: DESIGN REPORT INTERFACE TO GENERATE REPORT WITH


TRIGGER

AIM: To let students have the knowledge on how to generate reports using SQL
commands (codes)

OBJECTIVE: To know how to generate reports using SQL command from an


already existing tables.

APPARATUS/EQUIPMENT: Oracle/MySQL database, a computer system,


printer

PROCEDURE:

- Launch Oracle 10G software


- Login to user created database
- Create student information table to contain student records of Computer
and Mass Communication.
- Populate table with student records.
- Project department from the student information table and select student
separately from each departments.
- Insert necessary codes
- Run the trigger to generate reports.

OBSERVATION: Briefly state your observations

CONCLUSION: Draw your conclusion

RESULT: Present the result of your work

3|Page
PRACTICAL 4

TOPIC: DESIGN OF RECORD STURCTURE AND DATA DICTIONARY

AIM: To let the student have the knowledge on how to design a record structure
and data dictionary.

OBJECTIVE: To know how to create the record structure using the design
method and also using SQL code.

APPARATUS/EQUIPMENT: Oracle/MySQL database, a computer system,


printer

PROCEDURE:

- Launch Oracle 10G software.


- Login to the database in practical III.
- Create record structure i.e. define the variable names, data type and field
length.

OR

- Launch oracle 10G software


- Login to the database in practical III
- Select the SQL button
- Select SQL command button
- Write SQL codes
- Run the codes

OBSERVATION: Briefly State your observations

CONCLUSION: Draw your conclusion

RESULT: Present the result of your work

4|Page
PRACTICAL 5

TOPIC: DESIGN OF RECORD INDEXING WITH MULTIPLE KEYS

AIM: To let the student have the knowledge of primary key, creation of foreign
key and how to analyze the table using indexing with multiple keys.

OBJECTIVE: To know how to analyze record using indexing with multiple keys

APPARATUS/EQUIPMENT: Oracle/MySQL database, a computer system,


printer

PROCEDURE:

- Launch Oracle 10G software.


- Login to previous database.
- Select object browser
- Create staff table name to contain names of staff and their pay
- Show table structures describing the different data types and primary key
column.
- Create index on the LAST NAME and S/N column respectively – follow
these steps:
o Click create on the object browser
o Select index from dropdown menu
o Select the table and column to be indexed
o Specify the type of index
- Implement the index by clicking confirm button.

OBSERVATION: Briefly State your observations

CONCLUSION: Draw your conclusion

RESULT: Present the results of your work

5|Page
PRACTICAL 6

TOPIC: INFORMATION RETRIEVAL AND ORDERING IN DATABASE

AIM: To equip students with the knowledge of information retrieval and ordering
in database management system.

OBJECTIVE: To know how to use information retrieval in database management


system and SQL query using descending / ascending order.

APPARATUS/EQUIPMENT: Oracle/MySQL database, a computer system,


printer

PROCEDURE:

- Launch the Oracle 10G software.


- Login to database.
- Open the previous database created.
- Compose different query commands to retrieve different information
from your database
- Order the results in ascending order
- Order the results in descending order

OBSERVATION: Briefly State observations.

CONCLUSION: Draw your conclusion.

RESULT: Present the results of your work

6|Page
PRACTICAL 7

TOPIC: TRANSACTION PROCESSING USING SQL

AIM: To acquaint student to the use of SQL query to execute simple transaction.

OBJECTIVE: To demonstrate how the content of database can be access using


SQL statement.

APPARATUS/EQUIPMENT: Oracle/MySQL database, a computer system,


printer

PROCEDURE:

- Launch the Oracle 10G software.


- Login to user database.
- Open the created table.
- Use SELECT statement to select the whole content of the staff paytable.
- Compose a transaction of your choice on any field(s) to automatically
affect the whole/some rows in the staff pay table
- Show updated table.

OBSERVATION: Briefly State observations.

CONCLUSION: Draw your conclusion.

RESULT: Present the result of your work

7|Page
PRACTICAL 8

TOPIC: TRANSACTION PROCESSING USING SQL 2

AIM: To equip students with the knowledge of database query skill.

OBJECTIVE: To know how the content of a table can be replaced using


UPDATE command.

APPARATUS/EQUIPMENT: Oracle/MySQL database, a computer system,


printer

PROCEDURE:

- Launch the Oracle 10G software.


- Login to user database.
- Open any of the tables you previously created.
- Use SELECT statement to create an instance of the selected table.
- Use UPDATE command to alter the content of any field of interest.
- Repeat the step above for different operations
- Show table(s).

OBSERVATION: Briefly State observations.

CONCLUSION: Draw your conclusion.

RESULT: Present the result of your work

8|Page
PRACTICAL 9

TOPIC: ADVANCE OPERATION USING SQL

AIM: To demonstrate how complex queries can be carried out on a database.

OBJECTIVE: To show our queries involving more than one table in database
operation.

APPARATUS/EQUIPMENT: Oracle/MySQL database, a computer system,


printer

PROCEDURE:

- Launch the Oracle 10G software.


- Login to your previous database.
- Open the created table.
- Select the whole content of staff pay table
- Select whole content of student information table.
- Show the table structure describing the different data types and the
primary column.
- Create a union of tables on a common field.
- Execute the union operation.

OBSERVATION: Briefly State observations.

CONCLUSION: Draw your conclusion.

RESULT: Present the result of your work

9|Page

You might also like