Database Design I
Goal: This course is designed to introduce student to computer database
General Objectives: On completion of this course, the diplomates should be able to:
1. Understand the organization’s information need and database concepts.
2. Understand and differentiate the various types of data models
3. Understand how to model data
4. Understand the design of relational databases design
5. Know the structured query language (SQL)
6. Understand database systems architecture
1
1.1 Understand the types of information need.
1.2 Understand the purpose of data base systems
State types of information which organizations use.
Define database and database system.
State different purposes for database systems.
2
1.3 Understand data view and data model
1.4 Understand database administrators, users and languages.
Explain data view and models.
State different types of model.
Discuss different types of database languages.
3
2.1 Different types of data model: hierarchical, network and relational models
Explain the basic concepts of: hierarchical, network and relational models
4
2.1 (continued) Different types of data model: hierarchical, network and relational models
Explain structure data diagrams .
5
3.1 Understand the concept of E-R, entity sets ,entity relationship, weak entity sets.
Describe the basic concepts of E-R
Explain entity set and entity relationship diagram
6
3.2 Be able to design E-R database schema
3.3 Understand reduction of E-R schema into tables.
Explain weak entity sets
Discuss the design of E-R data base schema
Demonstrate the reduction at E-R schema into tables.
7
4.1 Understand pitfalls in relational-database design
4.2 Understand decomposition and normalization
State the pitfalls in relational database design
Explain decomposition and normalization
8
4.3 Understand domain-key normal form
4.4 Review alternative approaches to database design.
Explain domain-key normal form.
Discuss the alternative approaches to database design
9 5.1 Understand the background of SQL Discuss the background of SQL
5.2 Understand the basic structure of SQL
Discuss the basic structures
10
5.3 Understand nested sub-queries
5.4 Understand derived relations and views
Explain rested sub queries
Describe derived relations
11
5.5 Understand views Explain views
Discuss how databases can be modified.
12
5.6 Understand joined relations
5.7 Understand data definition language and embedded SQL.
Discuss joined relations
Demonstrate the implementation of data definition language and embedded SQL
13 6.1 Understand centralized systems
6.2 Understand client- server systems
Explain centralized systems
Explain client server systems
14 6.3 Understand parallel systems
Explain parallel systems
15 6.4 Understand distributed systems and network types
Differentiate between distributed systems and networked systems.