OMIS 452 Exam Questions and Answers
Save
3
Practice questions for this set
Learn 1 /7 Study with Learn
External - User views. Can be determined from business-function/data entity matrices
Conceptual schema (ER models)
Internal - logical and physical structures
Choose an answer
1 Database 2 Primary Key
3 MS Access Data Types 4 Three-Schema Architecture
, Don't know?
Terms in this set (55)
Database An organized collection of logically related data
Representations of objects and events
Data
Structured: numbers, text, dates
Unstructured: images, video, documents
Database Management System A data storage and retrieval system
(DBMS)
Hierarchy of Data Elements Bytes - Fields - Reports - Tables - Database
Short text, Long text, number, auto number, date/time, currency,
MS Access Data Types yes/no, OLe object, Hyperlink, Lookup wizard, attachment,
calculated
SQL Data types Bit, Char, date time, decimal, varchar
Describes data. Descriptions of the properties of data including
Metadata
data types, field size, allowable values, etc
Data are separated and isolated, data are often duplicated,
Limitations with file processing
application program dependent, excessive program and data
systems
maintenance
Data is integrated, duplication is reduced, consistent, program
Benefits of database systems
independent, easy to understand, shared
Save
3
Practice questions for this set
Learn 1 /7 Study with Learn
External - User views. Can be determined from business-function/data entity matrices
Conceptual schema (ER models)
Internal - logical and physical structures
Choose an answer
1 Database 2 Primary Key
3 MS Access Data Types 4 Three-Schema Architecture
, Don't know?
Terms in this set (55)
Database An organized collection of logically related data
Representations of objects and events
Data
Structured: numbers, text, dates
Unstructured: images, video, documents
Database Management System A data storage and retrieval system
(DBMS)
Hierarchy of Data Elements Bytes - Fields - Reports - Tables - Database
Short text, Long text, number, auto number, date/time, currency,
MS Access Data Types yes/no, OLe object, Hyperlink, Lookup wizard, attachment,
calculated
SQL Data types Bit, Char, date time, decimal, varchar
Describes data. Descriptions of the properties of data including
Metadata
data types, field size, allowable values, etc
Data are separated and isolated, data are often duplicated,
Limitations with file processing
application program dependent, excessive program and data
systems
maintenance
Data is integrated, duplication is reduced, consistent, program
Benefits of database systems
independent, easy to understand, shared
