Course Instructor:
Rafa Absar
Course Format:
Lectures and seminars
Pre-requisites: ARST/LIBR 500, ARST 510, ARST 515, ARST 516, ARST 520, ARST 573
Goal: To provide students with knowledge and skills necessary to produce a well-designed database that enables the timely delivery of accurate information in a useful form.
Objectives:
- Explain basic database concepts and terminology.
- Identify information needs within an organization.
- Specify user and organizational requirements.
- Construct a conceptual model that reflects these needs and requirement.
- Transform this conceptualization into a relational data model. 6)Normalize this relational model.
- Instantiate this model in a database application (Microsoft Access).
Content:
- Overview of databases and database design.
- Components of a DBMS.
- Logical modeling and E-R diagramming.
- The reational model.
- Normalization.
- Physical modeling.
- Querying a database (SQL).
- Issues and Trends in DBMS. 9)Creating a databse appication.
Relates to GPAS Component(s):
