|
Database Design and Development |
|
DB DSGN & DEV |
| CLASS CODE: |
IS 320 |
CREDITS:
3
|
| DIVISION: |
BUSINESS & COMMUNICATION |
| DEPARTMENT: |
INFORMATION SYSTEMS |
| GENERAL EDUCATION: |
This course does not fulfill a General Education requirement. |
|
| DESCRIPTION: |
Emphasis will be placed on logical and physical database design and implementation. SQL (Structured Query Language) will be introduced. Other major topics include: database design, data modeling, enterprise database processing, multi-user database processing, and object-oriented database processing. |
| TAUGHT: |
Winter, Summer, Fall |
| CONTENT AND TOPICS: |
- Data modeling
- Design and implementation with relation tables
- Normalization
- UML class diagrams
- Data definition and relational query languages (DDL and SQL)
- Administrative
- Management
- Technical issues with respect to security/integrity and distributed databases
|
| GOALS AND OBJECTIVES: |
- Obtain a database overview: history, environment, and development.
- Learn fundamental semantic modeling concepts.
- Demonstrate the ability to build a well-designed database structure (schema).
- Understand how a database management system works.
- Analyze modeling concepts, including normalization, and study the process of converting semantic models to relational models.
- Introduce the data definition and relational query languages (DDL and SQL), object oriented databases, and integrated applications, and achieve basic proficiency in them.
- Address administrative, management, and technical issues with respect to security/integrity and distributed databases.
|
| REQUIREMENTS: |
Create SQL scripts, design and create a database, written tests covering the various topics discussed in class and the textbook. |
| PREREQUISITES: |
IS 210 |
| OTHER: |
|
| EFFECTIVE DATE: |
August 2002 |
>>PRINT