Copy and Edit

Database Design

Description

Database Quiz on Database Design, created by Matthew Rook on 04/04/2019.
Matthew Rook
Quiz by Matthew Rook, updated more than 1 year ago
Matthew Rook
Created by Matthew Rook over 5 years ago
5
0
0

Resource summary

Question 1

Question
What is Program-Data Redundancy?
Answer
  • changing the structure or storage characteristics would require changing the applications that access it
  • Unnecessary storage of the same data in different places
  • different and conflicting versions of the same data occur at different places
  • Abnormalities when all changes in redundant data are not made correctly

Question 2

Question
What is Data Redundancy?
Answer
  • changing the structure or storage characteristics would require changing the applications that access it
  • different and conflicting versions of the same data occur at different places
  • Abnormalities when all changes in redundant data are not made correctly
  • Unnecessary storage of the same data in different places

Question 3

Question
What is Data Inconsistancy?
Answer
  • Abnormalities when all changes in redundant data are not made correctly
  • Unnecessary storage of the same data in different places
  • changing the structure or storage characteristics would require changing the applications that access it
  • different and conflicting versions of the same data occur at different places

Question 4

Question
What is Data Anomalies?
Answer
  • changing the structure or storage characteristics would require changing the applications that access it
  • different and conflicting versions of the same data occur at different places
  • Unnecessary storage of the same data in different places
  • Abnormalities when all changes in redundant data are not made correctly

Question 5

Question
Data Dictionary Management - Data dictionary: Stores [blank_start]definitions[blank_end] of the [blank_start]data[blank_end] [blank_start]elements[blank_end] and their [blank_start]relationships[blank_end]
Answer
  • definitions
  • data
  • elements
  • relationships

Question 6

Question
[blank_start]Data storage management[blank_end] - Performance tuning: Ensures [blank_start]efficient[blank_end] [blank_start]performance[blank_end] of the [blank_start]database[blank_end] in terms of [blank_start]storage[blank_end] and access [blank_start]speed[blank_end]
Answer
  • Data storage management
  • efficient
  • performance
  • database
  • storage
  • speed

Question 7

Question
[blank_start]Data transformation and presentation[blank_end] - Transforms entered data to conform to required data structures
Answer
  • Data transformation and presentation

Question 8

Question
[blank_start]Security management[blank_end] - Enforces user security and data privacy
Answer
  • Security management

Question 9

Question
[blank_start]Multiuser access control[blank_end] - Sophisticated algorithms ensure that multiple users can access the database concurrently without compromising its integrity
Answer
  • Multiuser access control

Question 10

Question
[blank_start]Backup and recovery management[blank_end] - Enables recovery of the database after a failure
Answer
  • Backup and recovery management

Question 11

Question
[blank_start]Data integrity management[blank_end] - Minimizes redundancy and maximizes consistency
Answer
  • Data integrity management

Question 12

Question
[blank_start]Database[blank_end] [blank_start]access[blank_end] [blank_start]languages[blank_end] [blank_start]and[blank_end] [blank_start]application[blank_end] [blank_start]programming[blank_end] interfaces - Query language: Lets the user specify what must be done without having to specify how • Structured Query Language (SQL): De facto query language and data access standard supported by the majority of DBMS vendors
Answer
  • Database
  • access
  • languages
  • and
  • application
  • programming

Question 13

Question
[blank_start]Database communication interfaces[blank_end] - Accept end-user requests via multiple, different network environments
Answer
  • Database communication interfaces

Question 14

Question
Abstraction of a real-world object or event is an example of Data Models?
Answer
  • True
  • False

Question 15

Question
Collection of related concepts used to describe the structure of a database, i.e. unique objects, data types, relationships, and constraints • Useful for supporting a specific problem domain • Simple representations of complex real-world data structures This is an example of Data Modelling
Answer
  • True
  • False

Question 16

Question
A Model refers to the process of creating a specific data model for a determined problem domain.
Answer
  • True
  • False

Question 17

Question
An [blank_start]entity[blank_end] is a person, place, thing, or event about which data will be collected and stored.
Answer
  • entity

Question 18

Question
An [blank_start]attribute[blank_end] is a characteristic of an entity
Answer
  • attribute

Question 19

Question
A [blank_start]relationship[blank_end] describes an association among entities.
Answer
  • relationship

Question 20

Question
A [blank_start]constraint[blank_end] is a restriction placed on the data
Answer
  • constraint

Question 21

Question
• Logical Data Independence:
Answer
  • Change the schema at one level of a database system without having to change the schema at the next higher level.
  • A change in storage devices or methods and even a change in operating system will not affect the internal model.
  • Change the internal model without affecting the conceptual model.
  • Change the physical model without affecting the internal model
  • Recoding, adding fields (e.g. adding an email address to a student file) in the database should not affect applications

Question 22

Question
Data Independence:
Answer
  • Change the schema at one level of a database system without having to change the schema at the next higher level.
  • A change in storage devices or methods and even a change in operating system will not affect the internal model.
  • Change the internal model without affecting the conceptual model.
  • Change the physical model without affecting the internal model
  • Recoding, adding fields (e.g. adding an email address to a student file) in the database should not affect applications

Question 23

Question
Physical Data Independence:
Answer
  • Recoding, adding fields (e.g. adding an email address to a student file) in the database should not affect applications
  • Change the physical model without affecting the internal model
  • Change the internal model without affecting the conceptual model.
  • A change in storage devices or methods and even a change in operating system will not affect the internal model.
  • Change the schema at one level of a database system without having to change the schema at the next higher level.

Question 24

Question
[blank_start]Primary Key[blank_end] - An attribute that can identify each row in a table uniquely. Cannot be null or duplicate
Answer
  • Primary Key

Question 25

Question
[blank_start]Composite Primary Key[blank_end] - Composed of more than one attribute
Answer
  • Composite Primary Key

Question 26

Question
[blank_start]Secondary Key[blank_end] - Unique key other than primary key, Strictly for data retrieval purposes, E.g. Customers do not remember their ID, but they do remember their phone number!
Answer
  • Secondary Key

Question 27

Question
[blank_start]Entity integrity[blank_end] - Each row (entity instance) in the table has its own unique identity
Answer
  • Entity integrity

Question 28

Question
[blank_start]Foreign key[blank_end] - An attribute whose values match primary key values in the related table
Answer
  • Foreign key

Question 29

Question
[blank_start]Referential integrity[blank_end] - FK contains a value that refers to an existing valid tuple (row) in another relation
Answer
  • Referential integrity

Question 30

Question
[blank_start]UNION[blank_end] will show all rows in the tables except duplicates
Answer
  • UNION

Question 31

Question
[blank_start]UNION ALL[blank_end] will show all rows from the tables including duplicates
Answer
  • UNION ALL

Question 32

Question
[blank_start]PROJECT[blank_end] - Unary operator that yields a vertical subset of a table. Yield all values for selected attributes
Answer
  • PROJECT

Question 33

Question
[blank_start]INTERSECT[blank_end] - Yields only the rows that appear in both tables
Answer
  • INTERSECT

Question 34

Question
[blank_start]DIFFERENCE[blank_end] - Yields all rows in one table that are not found in the other table
Answer
  • DIFFERENCE

Question 35

Question
[blank_start]Identifiers[blank_end]: one or more attributes that uniquely identify each entity instance.
Answer
  • Identifiers

Question 36

Question
[blank_start]Composite attribute[blank_end]: Attribute that can be subdivided to yield additional attributes
Answer
  • Composite attribute

Question 37

Question
[blank_start]Simple attribute[blank_end]: Attribute that cannot be subdivided
Answer
  • Simple attribute

Question 38

Question
[blank_start]Single valued attribute[blank_end]: Attribute that has only a single value.
Answer
  • Single valued attribute

Question 39

Question
[blank_start]Multivalued attribute[blank_end]s: Attributes that have many values.
Answer
  • Multivalued attribute

Question 40

Question
[blank_start]Derived attribute[blank_end]: Attribute whose value is calculated from other attributes
Answer
  • Derived attribute
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

FLAT FILE VS RELATIONAL DATABASE
rosiejones
OCR gcse computer science
Jodie Awthinre
GCSE AQA Computer Science - Definitions
James Jolliffe
Managing Digital Data Review
Shannon Anderson-Rush
Midterm 2 (Chapter 5 - 13)
Yorria Raine
SQL Quiz
Chris Cronin
GCSE AQA Computer Science - Definitions
moffat00
Database Final Exam
dbm
Data, Information and Databases
maryamxjay
AS Levels ICT -Form Controls
lukejones
C170 - Practice Test
Craig Willey
Browse Library