Intro to DataBase Chapter 4

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

Single-valued

A single-valued attribute is an attribute that can have only a single value. For example, a person can have only one Social Security number, and a manufactured part can have only one serial number.

Define entity, attribute and relationship

An entity is an object of interest to the end user. Attributes are characteristics of entities. A relationship is an association between entities.

Explain attributes domain

Attributes have a domain, a domain is the set of possible values for a given attribute. For example, the domain for the grade point average (GPA) attribute is written (0,4) because the lowest possible GPA value is 0 and the highest possible value is 4.

Multivalued

Multivalued attributes are attributes that can have many values. For instance, a person may have several college degrees, and a household may have several different phones, each with its own number.

What are the three types of relationship?

Relationships may be classified as one-to-one, one-to-many, or many-to-many.


Kaugnay na mga set ng pag-aaral

Ch.2 Open Stax Westcott Courses Physiology

View Set

Live Virtual Machine Lab 10.2: Module 10 Network Security Concept Fundamentals

View Set

PrepU hapter 15: Hospital Nutrition: Defining Nutrition Risk and Feeding Clients

View Set

GDP: Is it Counted and if so How?

View Set

31 - Reciprocal Regulation of Glycolysis and Gluconeogenesis

View Set