|
Apr 25, 2024
|
|
|
|
CIS 346 - Database Design Credits: 3 Lecture Hours: 3 Lab Hours: 0 Practicum Hours: 0 Work Experience: 0 Course Type: Voc/Tech Students learn a systematic approach to database development using entity-relationship models, normalization and relational database design. Students will use this approach to identify and define business information requirements, create entity relationship models and transform the requirements into an initial database design. Prerequisite: CIS 303 Competencies
- Explain systems integration
- Define the term systems integration
- Define the term systems integration
- Describe various systems development modeling tools
- Explain how these tools support the problem solving process
- Summarize the process of database development
- Define key terms
- Explain the purpose (benefits) of database design
- Discuss the evolution of database design
- Describe the phases of database design
- Analyze user information requirements
- Demonstrate importance of effective interviewing skills in the gathering of user requirements
- Demonstrate the ability to produce accurate and comprehensive documentation
- Utilize facilitation techniques to seek information from data users
- Identify business rules which underlie entity relationships
- Formulate a data dictionary with all appropriate components
- Transform business information requirements to an entity relationship model
- Describe the benefits of data modeling
- Distinguish between popular notation conventions
- Identify and model entities
- Distinguish between attributes and entities
- Identify attributes (composite, multivalued and attribute domains)
- Assign unique identifiers to entities
- Describe the various types of possible relationships between entities
- Analyze and model relationships
- Normalize Data Models
- Resolve M:M Relationships
- Model Hierarchical Data and Recursive Relationships
- Model Roles with Relationships
- Model Entity Supertypes and Subtypes
- Model Exclusive Relationships
- Model Data Over Time
- Model complex Relationships
- Convert ER diagrams to relational tables
- Apply basic conversion rules
- Map simple entities to tables
- Map Attributes to Columns
- Map unique identifiers to primary keys
- Map relationships to foreign keys
- Choose arc options
- Choose subtype options
- Normalize tables in a relational database
- Define each of the five normal forms
- Maximize application maintainability by applying the principles of normalization
- Recognize Unnormalized Data
- Convert to first, second, and third normal Form
- Understand the fourth and fifth normal form
- Discuss normalizing during Data Modeling
- Perform advanced database design functions
- Recognize when to generate artificial keys
- Understand the issues involved in specifying foreign keys and indexes
- Describe how referential integrity related to business data needs
- Specify referential integrity
- Design indexes
- Establish views
- Denormalize the database design
Add to Portfolio (opens a new window)
|
|