BIS 245 Week 8 Assignment

BIS 245 Week 8 Assignment | Devry University

Week 8: Introduction and Lesson

Course Case Study

Use the information from the lessons and SIMnet to complete the course case study. It will require you to create ERD's in Visio and Access using the business rules provided. You will need to integrate data into the tables in Access and create queries. You will also need to create a research paper about databases and security. Your research paper should include what you have learned about the importance of databases, queries, forms, and reports using complete sentences and paragraphs.

Course Objectives

1

Create, evaluate, and alter the conceptual model/design of the database using a database modeling tool when given a situation containing entities, business rules and data requirements.

Knowledge, Skills, and Abilities

·      Case Study Project using MS Access and Visio including security

2

Produce, design, and make business decisions necessary for reports when given a business situation which requires managers to analyze and classify information from a relational database.

Knowledge, Skills, and Abilities

·      Case Study Project using MS Access and Visio including security

3

Construct forms from a physical database containing tables and relationships which demonstrate effective user-interface design and allow for efficient entry and retrieval of data.

Knowledge, Skills, and Abilities

·      Case Study Project using MS Access and Visio including security

4

 Develop queries from a physical database containing tables and relationships from a given business scenario.

Knowledge, Skills, and Abilities

·      Case Study Project using MS Access and Visio including security

5

 Implement procedures to promote the backup, recovery and repair of the data. Establish security on the database to prevent unauthorized access or tampering.

Knowledge, Skills, and Abilities

·      Case Study Project using MS Access and Visio including security