Aug 24, 2019  
2018-2019 Course Catalog 
    
2018-2019 Course Catalog [ARCHIVED CATALOG]

[Add to Portfolio]

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
  1. Explain systems integration
    1. Define the term systems integration
    2. Define the term systems integration
    3. Describe various systems development modeling tools
    4. Explain how these tools support the problem solving process
  2. Summarize the process of database development
    1. Define key terms
    2. Explain the purpose (benefits) of database design
    3. Discuss the evolution of database design
    4. Describe the phases of database design
  3. Analyze user information requirements
    1. Demonstrate importance of effective interviewing skills in the gathering of user requirements
    2. Demonstrate the ability to produce accurate and comprehensive documentation
    3. Utilize facilitation techniques to seek information from data users
    4. Identify business rules which underlie entity relationships
    5. Formulate a data dictionary with all appropriate components
  4. Transform business information requirements to an entity relationship model
    1. Describe the benefits of data modeling
    2. Distinguish between popular notation conventions
    3. Identify and model entities
    4. Distinguish between attributes and entities
    5. Identify attributes (composite, multivalued and attribute domains)
    6. Assign unique identifiers to entities
    7. Describe the various types of possible relationships between entities
    8. Analyze and model relationships
    9. Normalize Data Models
    10. Resolve M:M Relationships
    11. Model Hierarchical Data and Recursive Relationships
    12. Model Roles with Relationships
    13. Model Entity Supertypes and Subtypes
    14. Model Exclusive Relationships
    15. Model Data Over Time
    16. Model complex Relationships
  5. Convert ER diagrams to relational tables
    1. Apply basic conversion rules
    2. Map simple entities to tables
    3. Map Attributes to Columns
    4. Map unique identifiers to primary keys
    5. Map relationships to foreign keys
    6. Choose arc options
    7. Choose subtype options
  6. Normalize tables in a relational database
    1. Define each of the five normal forms
    2. Maximize application maintainability by applying the principles of normalization
    3. Recognize Unnormalized Data
    4. Convert to first, second, and third normal Form
    5. Understand the fourth and fifth normal form
    6. Discuss normalizing during Data Modeling
  7. Perform advanced database design functions
    1. Recognize when to generate artificial keys
    2. Understand the issues involved in specifying foreign keys and indexes
    3. Describe how referential integrity related to business data needs
    4. Specify referential integrity
    5. Design indexes
    6. Establish views
    7. Denormalize the database design



[Add to Portfolio]