Database Management

Unit 1 Worksheet (WS1)
Chapters 1, 2, 3
Name: _________________________

Please complete this assignment worksheet and post it in the proper Blackboard unit folder. Please label all submitted files using the format: [first initial & last name]-[ISM400WSx].  Example: nstudent-ISM400WS1

 

Question Submission Requirements:

 

1. All answers must be in your own words with citations for your sources.
2. Proper English, spelling, punctuation, sentence, paragraph structure and grammar are required.
3. Answers must allow for those who are not experts in the field to understand the concepts.

 

Points: 80

 

 

 

Text: Database Systems: Design, Implementation, & Management, 11th Edition

Chapter 1: Database Concepts

 

Review Questions P 31 (8 * 5 = 40 pts)

 

2. What is data redundancy, and which characteristics of the file system can lead to it?

 

 

 

3. What is data independence, and why is it lacking in file systems?

 

 

 

4. What is a DBMS, and what are its functions?

 

 

 

5. What is structural independence, and why is it important?

 

 

 

6. Explain the difference between data and information.

 

 

 

7. What is the role of a DBMS, and what are its advantages? What are its disadvantages?

 

 

 

11. Explain why database design is important.

 

 

 

12. What are the potential costs of implementing a database system?

 

 

 

Chapter 2: Data Models

 

Review Questions P 62 (6 * 5 = 30 pts)

 

1. Discuss the importance of data modeling.

 

 

2. What is a business rule, and what is its purpose in data modeling?

 

 

3. How do you translate business rules into data model components?

 

 

4. Describe the basic features of the relational data model and discuss their importance to the end user and the designer.

 

 

 

5. Explain how the entity relationship (ER) model helped produce a more structured relational database design environment.

 

 

 

8. What is the difference between an object and a class in the object-oriented data model (OODM)?

 

 

Chapter 3: The Relational Database Model

 

Review Questions P 103 (2 * 5 = 10 pts)

 

1. What is the difference between a database and a table?

 

 

2. What does it mean to say that a database displays both entity integrity and referential integrity?

 

OBJECTIVES
1. Recognize the difference between data and information
2. Define a database
3. Define a database management system (DBMS)
4. Identify the roles and advantages of a DBMS
5. Develop a data model from business rules
6. Summarize the key concepts of a database (keys, integrity, indexes, and relationships)

Unit 1 Course Outcomes
1. Evaluate the necessity and feasibility for a database solution to support an organizational initiative.
2. Construct an Entity Relationship Diagram (ERD) and Data Flow Diagram (DFD) for a potential database solution.
3. Identify operational and security requirements for the database.
5. Propose a database solution for an organizational initiative or function.

***WATCH VIDEO***
Intro to Database Management Systems