Scribd
Upload
99 views1 page

CPCS-241 Database Lab Overview

The database lab teaches students relational database design concepts through practical implementation. Students will learn to design tables, retrieve and manipulate data, and use Oracle tools. By completing the lab, students will be able to install Oracle, use data definition and manipulation commands, define keys, insert records, rollback changes, retrieve data from single and multiple tables, use functions, create user accounts, and build indexes and reports. The lab meets weekly for 90 minutes over 11 topics across a semester.

Uploaded by

montader algaphari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
99 views1 page

CPCS-241 Database Lab Overview

The database lab teaches students relational database design concepts through practical implementation. Students will learn to design tables, retrieve and manipulate data, and use Oracle tools. By completing the lab, students will be able to install Oracle, use data definition and manipulation commands, define keys, insert records, rollback changes, retrieve data from single and multiple tables, use functions, create user accounts, and build indexes and reports. The lab meets weekly for 90 minutes over 11 topics across a semester.

Uploaded by

montader algaphari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

CPCS-241 Database I

12 Oracle Query and Report Builder


13 Indexing
Lab Description
The Database lab is a practical implementation of
the relational database design concepts which are Lab Learning Outcomes
taught in the theory class. The students will learn (LLO)
how to design and implement relational tables
By completion of the lab the students should be
and learn how to retrieve information from those able to
tables. Different data manipulation operations are
practiced. 1. Install Oracle Database 11g Release 2
2. Apply data definition language commands
3. Define key constraints.
Lab Schedule 4. Create sequence and insert records into
table.
90 minutes per week
5. Perform Rollback and alter table
6. Retrieve required data from a single table
Lab Requirements 7. Use character and date functions
8. Retrieve data from multiple tables
o Oracle Database 11g Release 2 Installer 9. Use aggregate functions
o Student’s personal computer / laptop 10. Create user accounts and privileges
o Oracle WebLogic Suite 11. Use Form Builder
12. Use Oracle Query and Report Builders
13. Create an Index on a field
Lab Resources
Oracle Installation Guide 11g Release 2
Oracle SQL Language Reference (11.2)
Lab Assessment
Week Assessment Grade %
Lab Supplementary files 6 Lab Activity 1 2.5
11 Lab Activity 2 2.5
Topics Coverage
Weeks Topic
1 Install Oracle Database 11g Coordinator(s)
3
2 DDL Commands Dr. Manar Salamah
3 Key Constraints
4 Sequence and Insertion Lab Instructor(s)
5 Rollback and alter table
6 Retrieve data from a single table Mr. Mohammad Emran
7 Character and date functions
8 Retrieve data from multiple tables Miss. Najat Sai’ary
9 Aggregate Functions
10 User Accounts and privileges Miss. Noha Alnahdi
11 Oracle Form Builder

You might also like