COIS 342
|
| 1 ) |
Course Number |
: |
COIS 342 |
Name |
: |
Databases |
| |
|
|
|
|
|
|
| 2) |
Credits |
: |
4 |
Contact Hours |
: |
42 Hrs. Lecture
28 Hrs. Lab
|
|
| |
| 3) |
Course Coordinator’s Name |
: |
Dr. Ahmed Hamza Osman |
| |
|
|
|
|
| 4) |
Text Book |
: |
Fundamentals of Database Systems 6th Addison-Wesley Publishing Company, USA ©2010 ISBN:0136086209-9780136086208. |
| |
|
|
|
|
| 5) |
Other References |
: |
Concepts of Database Management by Pratt, Philip J. & Adamski, Joseph J., 7th Edition ,Thomson Learning, 2011, ISBN 10:1423901479, ISBN-13:9781423901471 |
| |
|
|
|
|
| 6) |
Specific Course Information |
| |
|
|
|
|
| |
a. |
Synopsis |
: |
This course provides the students with an introduction to the core concepts in data and information management. It includes comprehensive coverage of the relational model, relational algebra, and SQL. The course will also include coverage of basic database administration tasks and key concepts of data quality and data security. In addition to developing database applications, the course helps the students understand how large-scale packaged systems are highly dependent on the use of DBMSs. Building on the transactional database understanding.
|
| |
|
|
|
|
| |
b. |
Prerequisites |
: |
COIT 260-Fundamentals of Computing
|
| |
|
|
|
|
| |
c. |
Type of Course |
: |
IS Department Core |
| |
|
|
|
|
|
| 7) |
Course Learning Outcomes (CLO) |
| |
|
| |
Upon finishing this course, the students should be able to: |
| |
1. |
Know historical development of DBMS, logical data models, role of databases, and the fundamentals of the basic file organization techniques. (1) |
| |
2. |
Use ER Model, Design high-quality relational databases, normalizing, and apply 3 NF normalization. (1, 2) |
| |
3. |
Use the DML, DCL, DDL, Implement a RDMS using an industrial-strength DBMS, indexing.(2) |
| |
4. |
Concept of database the Relational Data Model and Relational Database Constraints, Data modeling using the Entity-Relationship Model (Real world examples), Enhanced Entity-Relationship (EER) Modeling. (1, 2) |
| |
|
|
|
| 8) |
Course Relationship to Key Student Outcomes |
| |
|
|
| |
|
|
| |
|
|
|
|
| 9) |
Course Topics and Their Duration |
| |
|
| |
|
Number
|
Description
|
Duration in weeks
|
|
1
|
Introduction to Database Systems
|
1
|
|
2
|
Types of database management systems
|
1
|
|
3
|
Basic file processing and Physical data storage concepts
|
1
|
|
4
|
Database System Concepts and Architecture
|
1
|
|
5
|
Database System Concepts and Architecture..Cont.
|
1
|
|
6
|
The Relational Data Model and Relational Database Constraints
|
1
|
|
7
|
Relational Algebra and Relational Calculus
|
1
|
|
8
|
Relational Algebra and Relational Calculus..Cont.
|
1
|
|
9
|
Data modeling using the Entity-Relationship Model(Real world examples)
|
1
|
|
10
|
Enhanced Entity-Relationship (EER) Modeling
|
1
|
|
11
|
Enhanced Entity-Relationship (EER) Modeling..Cont.
|
1
|
|
12
|
ER-and-EER-to-Relational Mapping
|
1
|
|
13
|
Functional Dependences and Normalization
|
1
|
|
14
|
Functional Dependences and Normalization..Cont.
|
1
|
|
|
|
| 10) |
Class Schedule |
| |
Meet 90 minutes 2 times/week
Meet 120 minutes 1 times/week Lab
|
| |
|
|
| 11) |
Assessment Tools and Marks Distribution |
| |
|
|
| |
|
ASSESSMENT
|
Percentage of Marks
|
|
Assignments
|
20 %
|
|
Practical Lab / Project
|
20 %
|
|
Mid Term Exam
|
20 %
|
|
Final Exam
|
40 %
|
|
TOTAL
|
100.00
|
|
|
| |
|
|
|
Last Update
12/1/2022 12:17:36 AM
|
|
|
|