HELP 2018-2019 Course Catalog [ARCHIVED CATALOG] Print this Page Facebook this Page (opens a new window) Tweet this Page (opens a new window) Add to Portfolio (opens a new window)

CIS 346 - Database Design

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

Print this Page