Key words
Databases, data-models, data-analysis, Access, SQL, information systems, (unique) key, referential integrity, redundancy, normalization, system analysis
Objectives
Understand the activities of developing information systems
Te be able to …
- Interpret a technical data-model
- Define screen layouts and reports for an existing data base
- Define a data base, construct a technical data model (implementation model)
- Interpret a conceptual data model (information model)
- Transform a conceptual into a technical data model
- Construct a conceptual data model based upon text and forms
- Normalize
Prerequisites
No special prerequisites.
Topics
- Definitions : business system, information system, system analysis
- Introduction to data bases
- Components of a data base (tables, columns, queries, forms, reports)
- Conceptual data models : entity-relationship model (ERD)
- Transform text and forms into ERD
- Transform conceptual into technical data models
- Normalization ( until 3th normal form)
- Implementation into a relational database system : Access
All topics are intensively illustrated with examples and practiced under supervision.
Teaching Methods
Lectures
Supervised practice
Materials used
Textbook Databases, David M. Kroenke, Academic Service
Access: teach it yourself
Teacher’s course
Study guidance
Individual additional explanation on demand of the student.
Assessment
Written examination; partially open book.
Study costs
Textbook “Data bases” (used in the 1th as well as in the 2th course year)
Price : € 45 (estimation)
Lecturer(s)
Language
Dutch
|
|
