Database Management Ch 1

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

Which of the following defines a DBMS?

A program through which users interact with the data stored in a database

Which of the following allows you to get more information from the same amount of data?

Creating a healthy relational database

Which of the following describes database design?

Creating the entities, attributes, and relationships between tables of data

_____ is the duplication of data or the storing of the same data in more than one place.

Data redundancy

Which of the following is not a problem associated with redundancy?

Prevents orphan records

Which of the following describes how to create a one-to-many relationship in a database system?

Use a common field in the two tables to tie the related records from each table together.

A(n) _____ is a characteristic or property of an entity.

attribute

A(n) _____ is the person in charge of an organization's database.

database administrator (DBA)

A(n) _____ is a person, place, object, event, or idea for which you want to store and process data.

entity

In a(n) _____, rectangles represent entities and display their attributes; lines represent relationships between connected entities.

entity-relationship (E-R) diagram

A(n) _____ exists between two entities when each row in the first entity matches many rows in the second entity, and each row in the second entity matches only one row in the first entity.

one-to-many relationship

A(n) _____ is a structure that contains data about many categories of information as well as the relationships between those categories.

relational database


Ensembles d'études connexes

Lesson 4: Dietary Guidelines for Americans 2020-2025

View Set

World Civilizations Since 1500 Final Exam Review - Previous Quiz Questions

View Set

BCIS 3610 CH 5 + some from previous

View Set

death dying and afterlife exam 3

View Set

Integers with variables by Mr. Turner

View Set

Module 5 - Recruitment & Retention

View Set

Chapter 25: Assessing Neurologic System

View Set

Chapter 5 & 6: Morphology & Word Formation

View Set

Ch. 17: Nursing Care of the Child with an Alteration in Sensory Perception/Disorder of the Eyes or Ears

View Set

Missed final insurance questions

View Set