Computer Science exam 3 ACTUAL UPDATED QUESTIONS AND CORRECT ANSWERS
Database is a logically organized collection of related data designed and built for a specific
purpose
Hierarchy -File
-Records
-Field
-Character(byte)
-Bit
Key unique data that identifies that record from all other records in the database or file
, Database Management System(DBMS) Benefits:
-reduced data redundancy
-speed is very good(better than manual data-organization systems and older
computers
-Improved data integrity
-Timeliness
-Ease of sharing
-Ease of data maintenance
-forecasting capabilities
-Increased security
Components:
-data dictionary
-Utilities such as maintaining the data base by creating, editing, deleting data,
records, and files. includes automated backup recovery
-report generator
Database Administartor(DBA) -Coordinates all related activities and needs for an organizations database.
-Ensures the data base has:
~recoverability
~integrity
~security
~Availability
~Reliability
~Performance
Relational Database -Grew out of the hierarchical and network database models
-data stored in tables(files) of rows(tuples/records) and columns(attributes or
fields)
-more flexible than previous models; built with SQL
-Users friendly
-Users employ SQL(Structured query language) to create, modify, maintain, and
query the database.
-some allow the use of natural spoken language to make queries
Data Mining computer assisted process of sifting through and analyzing vast amounts of data
to extract hidden patterns and meaning and to discover new knowledge
Big data Implications:
-Big data derives from a bundle of old and new data sources
-big data could lead to a revolution in measurement
-big data could lead to better decision making
Uses:
-medical research, marketing, politics, and entertainment
Information System(IS) A combination of people, hardware, software, communication devices, and
databases that processes data and information for a specific purpose
Database is a logically organized collection of related data designed and built for a specific
purpose
Hierarchy -File
-Records
-Field
-Character(byte)
-Bit
Key unique data that identifies that record from all other records in the database or file
, Database Management System(DBMS) Benefits:
-reduced data redundancy
-speed is very good(better than manual data-organization systems and older
computers
-Improved data integrity
-Timeliness
-Ease of sharing
-Ease of data maintenance
-forecasting capabilities
-Increased security
Components:
-data dictionary
-Utilities such as maintaining the data base by creating, editing, deleting data,
records, and files. includes automated backup recovery
-report generator
Database Administartor(DBA) -Coordinates all related activities and needs for an organizations database.
-Ensures the data base has:
~recoverability
~integrity
~security
~Availability
~Reliability
~Performance
Relational Database -Grew out of the hierarchical and network database models
-data stored in tables(files) of rows(tuples/records) and columns(attributes or
fields)
-more flexible than previous models; built with SQL
-Users friendly
-Users employ SQL(Structured query language) to create, modify, maintain, and
query the database.
-some allow the use of natural spoken language to make queries
Data Mining computer assisted process of sifting through and analyzing vast amounts of data
to extract hidden patterns and meaning and to discover new knowledge
Big data Implications:
-Big data derives from a bundle of old and new data sources
-big data could lead to a revolution in measurement
-big data could lead to better decision making
Uses:
-medical research, marketing, politics, and entertainment
Information System(IS) A combination of people, hardware, software, communication devices, and
databases that processes data and information for a specific purpose
