DBMS Database Management System - Technical Questions and Answers

DBMS - Database Management System
DBMS - Basics

81.	Briefly explain the five components of an Information Systems Architecture and their relationship to data.
	Answer: Processes that manipulate the data. Networks that transport the data. People who process and use the data. Events and point in time when processes need to be performed with the data. Reasons for events and rules to govern the processing of the data. Workspace Report errors ... Name : Email: View Answer

82.

Explain the systems development life cycle.

83.	Explain the differences of the two principal types of packaged data models.
	Answer: Universal data models are common to many organizations. These models may be useful for similar functions that are used across companies or organizations such as purchasing and accounting. Industry-specific data models are used by specific industries. Workspace Report errors ... Name : Email: View Answer

84.

Who can make up a systems or database team? Provide a brief explanation of each.

85.

Briefly describe the six database activities that occur during the systems development life cycle.

86.	Briefly explain an ERD.
	Answer: An ERD is a detailed logical representation of the data for an organization. The ERD includes entities, attributes, relationships, and cardinalities. An ERD is the mechanism where an entity-relationship model is displayed. Workspace Report errors ... Name : Email: View Answer

87.	List some of the chrematistics of good data definitions.
	Answer: Definitions are gathered from the same sources and should be accompanied diagrams. A definition will include special conditions, examples, how the data is created, whether the data can change, who owns the data, whether the data is optional, and whether the data can be broken into something more atomic. Workspace Report errors ... Name : Email: View Answer

88.	Explain minimum and maximum cardinality.
	Answer: Minimum cardinality is the minimum number of instances of an entity that can be associated with each instance of another entity. Maximum cardinality is the maximum number of instances of an entity that can be associated with each instance of another entity. Workspace Report errors ... Name : Email: View Answer

89.	Describe the naming of Relationships?
	Answer: Relationships are verb phrases and represent actions usually in the present tense. The name should exclude vague names such as "has". The name should explain what action is being taken and possibly why it is important. Workspace Report errors ... Name : Email: View Answer

90.	Why is modeling time-dependent data with a time stamp important?
	Answer: The values of data may change. A time stamp helps to ensure that the previous value of the data stays in the database after it has changed so that you can see the before and after values through time. Without a time stamp, you will most likely lose some of the history. Workspace Report errors ... Name : Email: View Answer