- You are registering for a technology conference which includes the following:
- Registering for the conference
- Registering for specific sessions
- Booking airline travel
- Booking a car rental
- Making reservations at a restaurant
Think about some of the pieces, are they just data? Or are they put into a meaningful context? Are they something that are known?
Listed, are some of the things that you may do when you register/travel for a conference. Think about what the different things are. Select either data, information or knowledge.
1. Data of the conference Data
2. Confirmation of conference registration Information
3. List of specific sessions Data
4. Upcoming technology conferences Knowledge
5. Confirmation of registered sessions Information
6. Limit of airline schedules Data
7. Upcoming airline specials Knowledge
8. Completed airline reservations information
9. Completed car rental reservation information
10. List of deals at specific restaurants Knowledge
11. List of restaurants in the area Data
12. List of different rental cars Data
13. Confirmation of rental car Information
2. Your company is confused and needs your technical assistance. They have given you different scenarios and want to know if they should use a spreadsheet or a DBMS (Database Management System).
Think about the reasons for using a spreadsheet versus using a DBMS
When would a DBMS be a better solution?
- Statistical comparisons spreadsheet
- Complex search queries DBMS
- Summary reports DBMS
- Calculations spreadsheet
- Mortgage calculations spreadsheet
- Managing data DBMS
- Inventory control DBMS
- Security control of data DBMS
- Storing a small amount of data Spreadsheet
- Calculating grades in a class resins Spreadsheet
3. Your company is concerned there is a problem with the data in one of the database tables. They want you to look at the data and determine if there is a problem. They have stressed it is important to have correct data as it is used for making decisions, and as a basis for reports for various departments.
Examine the data in the table and identify column(s) that contain data consistencies or inconsistences. Select the dropdown that is appropriate for each column.
- STUDENT_ID | Inconsistent
- STUDENT_NAME Consistent
- ADDRESS consistent
- CITY Inconsistent
- STATE Inconsistent
- PHONE Inconsistent
4. Your company is concerned there is a problem with the design of some of the database tables. They want you to look at the tables and determine if there is a problem. Management is concerned about data anomalies and data redundancies. They have stressed it is important to have correct design as it is used for making decisions and used as a basis for reports in the various departments.
Examine the fields in each table and determine if the table is designed correctly or incorrectly. Select the dropdown that is appropriate for each table.
Student
- Student Incorrect
- Advisor Correct
- Dorm Incorrect
5. Management is concerned about data redundancies in a table. There is some data in the table that is redundant and you are questioning what happens if the data is changed. Assume that this is the only table, and all the data is required when a new record is entered. There is only one advisor per major.
What happens if the data is redundant and the data is updated, deleted or a new record is added?
Think about the following:
- What data needs to be changed if you change majors? Think about what attributes are associated with a major.
- What data needs to be added if an advisor is deleted?
- What happens if you delete a student record and it is only one with a specific advisor? What do you need to do to preserve all the advisor data?
Review the specific actions that can occur. What if any changes need to be made to the data in other field(s). Think about redundancy and what happens if all the data is not updated.
- Change MAJOR for STUDENT_ID 02134 Update MAJOR, ADVISOR, ADVISOR_PHONE, ADVISOR_OFFICE
2. Change STUDENT_NAME for STUDENT_ID 03567
Update STUDENT_NAME
3. Delete ADVISOR for Entomology MAJOR
Update ADVISOR, ADVISOR_PHONE, ADVISOR_OFFICE for all Entomology MAJOR’s
4. Add new MAJOR
Insert Dummy STUDENT_ID, dummy STUDENT_NAME, MAJOR, ADVISOR, ADVISOR_PHONE, ADVISOR_OFFICE
5. Delete record with STUDENT_ID 45678
Prior to deleting the record insert Dummy STUDENT_ID, dummy STUDENT_NAME, MAJOR, ADVISOR, ADVISOR_PHONE, ADVISOR_OFFICE.
QUIZ CHAPTER 1 DATABASE SYSTEMS
1. Which of the following statements is true?
A DBMS is a set of processes that manage and control access to data stored in the database.
2. Which of the following is not an advantage of a DBMS?
Complexity
3. What is the result of redundant data in the database?
Data anomalies that lead to data inconsistencies
4. What are the components of database systems?
Hardware, software, people, procedures, data
5. Which of the following statements best defines a record?
A record is a set of logically connected fields
6. Which of the following is not a disadvantage of DBMS?
Data integration
7. Which of the following is not a function of a DBMS?
User management
8. Which of the following is not a valid statement?
Raw data is the collection of processed knowledge.
9. Which of the following is not a valid statement?
Production databases focus primarily on storing historical data and business metrics used exclusively for tactical or strategic decision making
10. Which of the following lists problems with file system data processing?
Development complexity, administration complexity, and lack of security
WEEK-1 Chapter 02 Use It
1. Use the following business rules to assign name to the tables on the ERD:
Note: These rules are in the context of a small retail store and their charge account process. The case contains simplifying assumptions that may not accurately represent a real-world example.
1) A customer may be responsible for one account.
2) An account can have several charges posted to it but a charge may only be posted to a single account.
3) A charge may include an item and an item may be included on many charges.
4) An account may have several payments made against it but a payment may only be credited to a single account.
Write the business rules for the following ERD shown in the figure below. The diagram represents the “Charge Account” at a small retail store. The ERD may contain simplifying assumptions that may not accurately represent a real-world example.
2. Add the ends to the relations on the Crows Foot ERD for the business rules of the XYZ Company’s motor pool (a motor pool typically is a group of vehicles that are temporary assigned to employees to drive for business purposes):
- Each time an employee wants a vehicle a new assignment is made.
- An employee can have multiple assignments, but each assignment is for only one employee and only one vehicle.
- A vehicle may have multiple assignments.
- The XYZ location at the end if the assignment is stored in the assignment. It is assumed tht the assignment begins at the destination of that vehicles prior assignment.
- An assignment may have the status of Assigned, Out, or Returned.
- A vehicle may only be “Out” on one assignment and an employee may only have one assignment “Out”.
1. What image should go into the square marked 1?
2. What image should go into the square marked 2?
3. What image should go into the square marked 3?
4. What image should go into the square marked 4?
5. What image should go into the square marked 5?
6. What image should go into the square marked 6?
7. What image should go into the square marked 7?
8. What image should go into the square marked 8?
Quiz: Chapter 02 Data Models
1.Which of the following is a fundamental data modeling component, helping ensure data integrity?
Constraint
2. Which of the following is not a valid business rule?
An invoice must be paid in a reasonable amount of time.
3.Why is identifying and documenting business rules essential to database design?
It helps to standardize the company’s view of data.
4. Which of the following two-dimensional structures is known as a relation?
Table
5. In an entity relational model (ERD), what is each row in a table known as?
An entity occurrence
6. Which of the following is a disadvantage of various database models?
System complexity
7. Which of the following entity relationship (ER) connectivity statements is invalid?
A CUSTOMER gender is MALE or FEMALE
8. Which of the following is not a valid component of object-oriented data models?
Volume
9. A CEO of a company wants to find a new and improved way to manage and extract business insights from large amounts of web- and sensor-generated data. Which of the following could they use to achieve this goal?
Big data
10. Which of the following technologies is not used in Big Data?
SQL
Other Links:
See other websites for quiz:
Check on QUIZLET