Modern Database Management 13th
Edition (All Chapters, 100% Original
Verified, Graded A+)
SHORT ANSWER
Discuss some of the disadvantages of file processing systems.
- Data Redundancy (Duplicated Data)
- Inconsistent Data (Because of Data Redundancy)
- Difficult Access to Data
- Limited Data Sharing
- Lack of Data Integrity (Not Correct or Consistent Data)
- Security Problems
Discuss some of the advantages to the database approach.
- Reduce Data Redundancy
- Consistent Data Flow
- Data Integrity
- Security (User Privileges & Limited Access)
- Improved Data Sharing
- Better Access to Data
- Increased User Productivity
Discuss some of the costs associated with the database approach.
- Specialized Database Personnel
,- Hardware
- Installation of Hardware
- Conversion Costs
- Backup & Recovery Protocols
Provide a brief overview of the various components of the database environment.
- Staff
- Database Administrators
- System Developers
- End Users
- Machine
- User Interface
-Application Programs
- Database
- Repository
- Database Management System
- Database
Discuss why the alternative IS development approaches have evolved, and provide an overview of a
couple of these methodologies.
Alternative ID Approaches evolve to make the processes more efficient, cost-friendly, and higher quality.
Some approaches are SDLC, Prototyping, and Outsourcing.
ASSIGNMENT 2
MULTIPLE CHOICE
The logical representation of an organization's data is called a(n):
A) database model.
B) entity-relationship model.
C) relationship systems design.
D) database entity diagram.
B) entity-relationship model.
A good data definition will describe all of the characteristics of a data object EXCEPT:
A) subtleties.
B) examples.
C) who determines the value of the data.
D) who can delete the data.
D) who can delete the data.
, Data modeling may be the most important part of the systems development process because:
A) data characteristics are important in the design of programs and other systems components.
B) the data in a system are generally less complex than processes and play a central role in
development.
C) data are less stable than processes.
D) it is the easiest.
A) data characteristics are important in the design of programs and other systems components.
The most common types of entities are:
A) strong entities.
B) weak entities.
C) associative entities.
D) smush entities
A) strong entities.
In an E-R diagram, there are/is ________ business rule(s) for every relationship.
A) two
B) three
C) one
D) zero
A) two
Business policies and rules govern all of the following EXCEPT:
A) managing employees.
B) creating data.
C) updating data.
D) removing data.
A) managing employees.
A ________ defines or constrains some aspect of the business.
A) business constraint
B) business structure
C) business control
D) business rule
D) business rule
Which of the following is NOT a characteristic of a good business rule?
A) Declarative
Edition (All Chapters, 100% Original
Verified, Graded A+)
SHORT ANSWER
Discuss some of the disadvantages of file processing systems.
- Data Redundancy (Duplicated Data)
- Inconsistent Data (Because of Data Redundancy)
- Difficult Access to Data
- Limited Data Sharing
- Lack of Data Integrity (Not Correct or Consistent Data)
- Security Problems
Discuss some of the advantages to the database approach.
- Reduce Data Redundancy
- Consistent Data Flow
- Data Integrity
- Security (User Privileges & Limited Access)
- Improved Data Sharing
- Better Access to Data
- Increased User Productivity
Discuss some of the costs associated with the database approach.
- Specialized Database Personnel
,- Hardware
- Installation of Hardware
- Conversion Costs
- Backup & Recovery Protocols
Provide a brief overview of the various components of the database environment.
- Staff
- Database Administrators
- System Developers
- End Users
- Machine
- User Interface
-Application Programs
- Database
- Repository
- Database Management System
- Database
Discuss why the alternative IS development approaches have evolved, and provide an overview of a
couple of these methodologies.
Alternative ID Approaches evolve to make the processes more efficient, cost-friendly, and higher quality.
Some approaches are SDLC, Prototyping, and Outsourcing.
ASSIGNMENT 2
MULTIPLE CHOICE
The logical representation of an organization's data is called a(n):
A) database model.
B) entity-relationship model.
C) relationship systems design.
D) database entity diagram.
B) entity-relationship model.
A good data definition will describe all of the characteristics of a data object EXCEPT:
A) subtleties.
B) examples.
C) who determines the value of the data.
D) who can delete the data.
D) who can delete the data.
, Data modeling may be the most important part of the systems development process because:
A) data characteristics are important in the design of programs and other systems components.
B) the data in a system are generally less complex than processes and play a central role in
development.
C) data are less stable than processes.
D) it is the easiest.
A) data characteristics are important in the design of programs and other systems components.
The most common types of entities are:
A) strong entities.
B) weak entities.
C) associative entities.
D) smush entities
A) strong entities.
In an E-R diagram, there are/is ________ business rule(s) for every relationship.
A) two
B) three
C) one
D) zero
A) two
Business policies and rules govern all of the following EXCEPT:
A) managing employees.
B) creating data.
C) updating data.
D) removing data.
A) managing employees.
A ________ defines or constrains some aspect of the business.
A) business constraint
B) business structure
C) business control
D) business rule
D) business rule
Which of the following is NOT a characteristic of a good business rule?
A) Declarative
