SDSU - MIS 380 - DATA MANAGEMENT SYSTEMS - TEST 1
QUESTIONS AND CORRECT DETAILED ANSWERS
(VERIFIED ANSWERS) |ALREADY GRADED A+||BRAND NEW
Database Ans✓✓✓An organized collection of related data.
Structured data Ans✓✓✓Includes things such as person name, address,
phone number. Stored in tabular form (tables, arrays, spreadsheets).
Data Ans✓✓✓Stored representations of objects that have meaning and
importance in the user's environment.
Information Ans✓✓✓Data that have been processed in such a way to
increase the knowledge of the person who uses the data.
Metadata Ans✓✓✓Data that describe the properties or characteristics of
end-user data and the context of those data.
Properties include data names, definitions, length of allowable values,
ownership, and usage. Example: Class Roster Size.
Distinction between data and metadata is metadata can be removed from
the data.
Data Model Ans✓✓✓Graphical systems used to capture the nature and
relationships among data. Made up of entities, attributes, and
relationships.
,Entities Ans✓✓✓A person, place an object, an event, or a concept
where the user environment about which organization wishes to
maintain data. Example: customer, order.
Relational database Ans✓✓✓A database that represents data as a
collection of tables in which all data relationships by common values in
related tables. (1:M One to many/M:N Many to many/M:N Orders and
Products/1:1 One to one).
Database Management System (DBMS) Ans✓✓✓A software system
that us used to create, maintain, and provide access to user databases.
Allows information to be stored in one place and not in separate files.
(Oracle, etc)
Data independence Ans✓✓✓The separation of data descriptions from
the application programs that use the data.
User view Ans✓✓✓A logical description of some portion of the
database that is required by a user to perform some task.
Constraint Ans✓✓✓A rule that cannot be violated by the database users.
Legacy System Ans✓✓✓Refers to the older applications in an
organization that are based on file processing and/or older database
technology.
, Data Modeling and Design Tools Ans✓✓✓Software tools that provide
automated support for creating data models.
Repository Ans✓✓✓A centralized knowledge base of all data
definitions, relationships, screen and report formats, and other system
components.
Systems Development life cycle Ans✓✓✓The traditional mythology
used to develop, maintain, and replace information systems.
Conceptual Schema Ans✓✓✓A detailed, technology-independent
specification of the overall structure of organizational data.
Logical Schema Ans✓✓✓The representation of a database for a
particular data management technology.
Physical Schema Ans✓✓✓Specifications for how data from a logical
schema are stored in a computer's secondary memory by a database
management system.
Prototyping Ans✓✓✓An iterative process of systems development in
which requirements are converted to a working system that is
continually revised through close work between analysts and users.
QUESTIONS AND CORRECT DETAILED ANSWERS
(VERIFIED ANSWERS) |ALREADY GRADED A+||BRAND NEW
Database Ans✓✓✓An organized collection of related data.
Structured data Ans✓✓✓Includes things such as person name, address,
phone number. Stored in tabular form (tables, arrays, spreadsheets).
Data Ans✓✓✓Stored representations of objects that have meaning and
importance in the user's environment.
Information Ans✓✓✓Data that have been processed in such a way to
increase the knowledge of the person who uses the data.
Metadata Ans✓✓✓Data that describe the properties or characteristics of
end-user data and the context of those data.
Properties include data names, definitions, length of allowable values,
ownership, and usage. Example: Class Roster Size.
Distinction between data and metadata is metadata can be removed from
the data.
Data Model Ans✓✓✓Graphical systems used to capture the nature and
relationships among data. Made up of entities, attributes, and
relationships.
,Entities Ans✓✓✓A person, place an object, an event, or a concept
where the user environment about which organization wishes to
maintain data. Example: customer, order.
Relational database Ans✓✓✓A database that represents data as a
collection of tables in which all data relationships by common values in
related tables. (1:M One to many/M:N Many to many/M:N Orders and
Products/1:1 One to one).
Database Management System (DBMS) Ans✓✓✓A software system
that us used to create, maintain, and provide access to user databases.
Allows information to be stored in one place and not in separate files.
(Oracle, etc)
Data independence Ans✓✓✓The separation of data descriptions from
the application programs that use the data.
User view Ans✓✓✓A logical description of some portion of the
database that is required by a user to perform some task.
Constraint Ans✓✓✓A rule that cannot be violated by the database users.
Legacy System Ans✓✓✓Refers to the older applications in an
organization that are based on file processing and/or older database
technology.
, Data Modeling and Design Tools Ans✓✓✓Software tools that provide
automated support for creating data models.
Repository Ans✓✓✓A centralized knowledge base of all data
definitions, relationships, screen and report formats, and other system
components.
Systems Development life cycle Ans✓✓✓The traditional mythology
used to develop, maintain, and replace information systems.
Conceptual Schema Ans✓✓✓A detailed, technology-independent
specification of the overall structure of organizational data.
Logical Schema Ans✓✓✓The representation of a database for a
particular data management technology.
Physical Schema Ans✓✓✓Specifications for how data from a logical
schema are stored in a computer's secondary memory by a database
management system.
Prototyping Ans✓✓✓An iterative process of systems development in
which requirements are converted to a working system that is
continually revised through close work between analysts and users.
