Unit 1 Worksheet (WS1)
Chapters 1, 2, 3
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:
- All answers must be in your own words with citations for your sources.
- Proper English, spelling, punctuation, sentence, paragraph structure and grammar are required.
- Answers must allow for those who are not experts in the field to understand the concepts.
Text: Database Systems: Design, Implementation, & Management, 11th Edition
Chapter 1: Database Concepts
Review Questions P 31 (8 * 5 = 40 pts)
- What is data redundancy, and which characteristics of the file system can lead to it?
- What is data independence, and why is it lacking in file systems?
- What is a DBMS, and what are its functions?
- What is structural independence, and why is it important?
- Explain the difference between data and information.
- What is the role of a DBMS, and what are its advantages? What are its disadvantages?
- Explain why database design is important.
- What are the potential costs of implementing a database system?
Chapter 2: Data Models
Review Questions P 62 (6 * 5 = 30 pts)
- Discuss the importance of data modeling.
- What is a business rule, and what is its purpose in data modeling?
- How do you translate business rules into data model components?
- Describe the basic features of the relational data model and discuss their importance to the end user and the designer.
- Explain how the entity relationship (ER) model helped produce a more structured relational database design environment.
- 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)
- What is the difference between a database and a table?
- What does it mean to say that a database displays both entity integrity and referential integrity?
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.
Intro to Database Management Systems
Top-quality papers guaranteed
100% original papers
We sell only unique pieces of writing completed according to your demands.
We use security encryption to keep your personal data protected.
We can give your money back if something goes wrong with your order.
Get free features with our reliable essay writing service
We offer you a free title page tailored according to the specifics of your particular style.
Include your preferred formatting style when you order from us to accompany your paper.
Get a list of references to go with your ordered paper.
24/7 support assistance
Reach out to our support agents anytime for free assistance.
Calculate how much your essay costs
What we are popular for
- English 101
- Business Studies