Database Management Systems

Program Type:

Thesis

Non Thesis

Course Code:

ACM 502

Course Type:

Elective

P:

3

Lab:

0

Credits:

3

ECTS:

8

Course Language:

English

Course Objectives:

This course mainly includes the database architecture comparison to file-based systems, historical data models, conceptual models, integrity constraints and triggers. Functional dependencies and normal forms, relational models, database processing , “Structured Query Language” (SQL), database access from “Applications-Embedded SQL”, “JDBC”, “Cursors”, “Dynamic SQL” and “Stored Procedures” are the main subconsepts. Emerging trends are also in the stream of the course over which “NoSQL databases”, “Internet Databases” and On-Line Analytical Processing (OLAP) are issued. A team project that builds a database application for a real-world scenario is an important scope part of the course.

Course Content:

SQL language, SQL development tools, PowerPivot

Teaching Methods:

1: Lecture, 2: Question-Answer, 3: Discussion, 4: Simulation, 5: Case Study

Assessment Methods:

A: Testing, C: Homework

Vertical Tabs

Course Learning Outcomes

Learning Outcomes	Program Learning Outputs	Teaching Methods	Assessment Methods
Students will be able to analyze a scenario and produce DFD and ERD diagrams for that scenario.	1,3,6,7	1,2,5	A,C
They will be able to generate intermediate level SQL commands.	1,3,6,7	1,2,5	A,C
The will have a decent understandig of the capabilities of PowePivot and be able to generate Pivot tables.	1,3,6,7	1,2,5	A,C

Course Flow

COURSE CONTENT
Week	Topics	Study Materials
1	Introduction
2	Database Concepts, Project: subject definition
3	Data Flow Diagram (DFD), SQL-1 , Project: Preliminary Proposal
4	DFD examples, Project: user screen designs Due
5	Entity Relation (ER), SQL-2 & Lab sql-2, Quiz-1,
6	Extended-ER (ch4), SQL-3 (ch8) & Lab sql-3
7	ERD examples, Project: DFD & ERD designs Due
8	Relational Integrity (ch5), SQL-4 (ch8), Project: required queries listing & results Due & Lab IRD, Lab sql-4
9	Midterm
10	ER Moddeling (homework) (ch7), SQL-5 (ch8)
11	PowerPivot
12	Finalized project report, & presentation
13	Normalization
14	Disk and File Structure Hashing

Recommended Sources

RECOMMENDED SOURCES

Textbook

Fundamentals of Database Systems 5th edition

Ramez&Elmasri

Additional Resources

Material Sharing

MATERIAL SHARING
Documents	Online course material and lab material
Assignments	Online Lab assignments after each subject and also a term project
Exams	1-Quiz, 1-Midterm and 1-Final

Assessment

ASSESSMENT
IN-TERM STUDIES	NUMBER	PERCENTAGE
Mid-terms	1	20
Quizzes	1	20
Assignment	1	20
Total		60
CONTRIBUTION OF FINAL EXAMINATION TO OVERALL GRADE		40
CONTRIBUTION OF IN-TERM STUDIES TO OVERALL GRADE		60
Total		100

Course’s Contribution to Program

COURSE'S CONTRIBUTION TO PROGRAM
No	Program Learning Outcomes	Contribution
No	Program Learning Outcomes	1	2	3	4	5
1	Program graduate has the skills and the knowledge to design models for scientific analyses, as required by companies.
2	Program graduate has the skills and the knowledge to identify strategies for companies for their information requirements and IT investments.
3	Program graduate has the skills and the knowledge to design and implements IT strategies and systems that would align with the companies’ business strategies.
4	Program graduate has the skills and the knowledge to develop and implement strategies that would be applied to the company’s new distribution channels, and if necessary be able to manage thre related IT projects.				X
5	Program graduate has the skills and the knowledge to manage projects involving IT systems within any industry.
6	Program graduate has the skills and the knowledge to design, tu use and to implement IT systems that would analyze customer data and discover valuable knowledge, which would be acted upon as a competitive advantage.
7	Program graduate has the skills and the knowledge to develop and implement IT systems that would analyze both internal and external data to resolve issues, based on scientific and applied methods.				X
8	Program graduate has the skills and the knowledge for implementation of ERP software, which requires requirements analysis, business process reengineering, and project team management.				X

ECTS

ECTS / WORK LOAD TABLE
Activities	Quantity	Duration (Hour)	Total Workload (Hour)
Course Duration (Including the exam weeks: 15 x Total Course Hours)	15	3	45
Out-of-Class Study Time (Pre-Study, Practice)	15	6	90
Midterm Exam	1	15	15
Homework	1	30	30
Final Exam	1	20	20
Total Work Load			200
Total Work Load / 25 (h)			8
ECTS of the Course			8

Search form