CPE
342
Database Management Systems Laboratory
This lab introduces uses a DBMS product to design and implement tables and perform queries. Focusing on normalization, data integrity, data modeling, and creation of simple tables, queries, reports, and forms. Once completed, students should be able to design and implement database structures by creating database tables, queries, reports, and forms.
Corequisites:
0612341
0612342
(0-3-1)
Credits and Contact Hours
1 credits, 30 hours
Course Instructor Name
Dr. Mohammad Allaho, and Dr. Asmaa Alsumait
Textbook
Database Lab Manual
Catalog Description
This lab introduces uses a DBMS product to design and implement tables and perform queries. Focusing on normalization, data integrity, data modeling, and creation of simple tables, queries, reports, and forms. Once completed, students should be able to design and implement database structures by creating database tables, queries, reports, and forms.
Co-requisite
CpE-341
Specific Goals for the Course
Upon successful completion of this course, students will be able to:
- Draw an ER diagram after reading and understanding system requirements.
- Transform ER Diagram into Relational model and then create that model in an Oracle database using Oracle SQL Developer. (Student outcomes: 2, 3)
- Alter and edit tables' data by using alter, insert, update, delete statements. (Student outcomes: 6)
- Query the data base using select statements.
- Create and test triggers in DBMS.
- Decide in which normal form the schema is and determine the functional dependencies in a relation.
- Model real-life application by using Oracle Application Express. (Student outcomes: 2, 6)
Topics to Be Covered
- ER Diagram
- Relational Model (Create tables) using Oracle SQL Developer software.
- Relational Model (Alter, Insert, Update and Delete Statements)
- Queries using Oracle SQL Developer software
- Advanced Queries
- Triggers
- Table Refinement
- Application Development 1 (Page Creation, Page Navigations, Authorization, schemas, Login Screen)
- Application Development 2 (Reports, Charts, LOVs, Authorization)
- Application Development 3 (Buttons, Master Details forms, Advanced forms)