Home › baker › Courses

Database Management Systems (design and programming)

baker's picture
Fri, 2014-08-15 10:34 — Baker Abdalhaq
Course Code: 
133256
Course Outline: 

Database Management Systems

Course description

This course will be an introductory course to data base design and programming. The course will cover basic concepts of relational database management systems. It will also cover database design topics like ER diagram, EER diagram and Normalization. Students will also be trained on SQL and advanced SQL. At the end of the course, more advanced topics will be introduced like NoSQL, Spatial database object-relational databases.

During the course, students will be divided into six teams and they will be required to complete a data base design project. Each group will work under the supervision of the course teacher and one private sector company tutor.

Intended Learning outcomes

Knowledge outcomes

1-      Describe DBMS structure.

2-      Demonstrate awareness of the importance of database management systems.

3-      Demonstrate knowledge of business and functional requirement writing and spec’s.

Design Skills

1.       Convert system requirements into normalized database schema

2.       Convert system requirements into ER and EER diagram.

Implementation and SQL Skills

Convert data and information need(s) into SQL code.

Project skills

1-      Provide creative solutions to specific functional requirements.

2-     Transform a problem into a conceptual database design.

3-     Development the ERD for a selected segment of the problem.

4-     Build normalizing tables.

5-      Optimize performance of the database system.

6-      Work effectively with other team members.

Project description

Student teams will work on completing the design of data base for point of sale information system.  Each team will work on developing ER diagram and normalized schema. Company tutor will help in giving the business case, requirements and specification to students and discus design issues with them. Each group will give final presentation starting from week 14. Teacher and company tutor will participate in project evaluation and give the final marks.

Textbooks:

1-      Carlos Coronel, Steven Morris, and Peter Rob Database Systems: Design, Implementation, and Management. 9th Edition 2010 Cengage Learning united states. 

Topics:

Week

Topic/assignments

text pages

Due dates

1-2

Database concepts

·         Database systems

·         Data models

 pp. 3-58

2

Company tutor will visit class to introduce the project (project orientation)

3

Database design: Entity relationship modeling (ER)   

 pp. 99-140

4

Company tutor will work with students on ER diagram for the project

5

Relational database model

 pp. 58-92

First exam

pp.3-140

6

During week 6 company tutor will work on DDL for project with student teams.

7

Normalization of database tables

pp. 174-208

8

Student teams work with company tutor on Normalization.

9

Advanced data modeling (EER)

pp.147-168

Assignment 1: Schema on open data

10

Database implementation

·         Introduction to structured query language (SQL)

·         Advanced SQL

pp.220-369

11-12

Problem-based sessions with company tutor: Posing problems related team SQL and working with students teams on tuned queries.                                                 

12

Assignment 2: Converting information need(s) to SQL

12-13

Advanced topics

·         Semi-structured models

           i.      XML

          ii.      Query in semi-structured models

·         NoSQL*

·         Object-relational database*

·         Data warehouse*

·         Spatial databases*

 pp515-566

pp351-361

14-15

Team project presentations and defense. Company tutor and course teacher will assess project quality and team performance according to a pre-designed rubric.

16

Final exam

Evaluation and assessment:

Since this course is project- and industry-based, a significant portion of the course grade will go for the project tasks, and the industry will be part of the evaluation process. The grade distribution is as follows

First exam 20%

  2 problem based assignments

1.       Schema on open data 10%

2.       Converting information need to SQL 10%

Rubric for problem assessment is attached.

Term project 30%

Rubric for project assessment is attached.  

Final Exam 30%

Resources:

1-      Open data http://www.data.gov/

2-      DATABASE MODELING AND DESIGN Logical Design, Fifth Edition, TOBY TEOREY SAM LIGHTSTONE TOM NADEAU H. V. JAGADISH.

3-      Database management system Ramakrishnan and Gehrke.

  • 662 reads