ISOM Quiz II Chpt 7
Terms
undefined, object
copy deck
- stores information in the form of logically related two-dimensional tables
- Relational Database Model
- person, place, object, event, concept
- Entity
-
property or characteristic of an entity
exmp: birthdate - Attribute
- An attribute that uniquely identifies individual instances of an entity.
- Key Attribute
- an association among the instances of entity types
- Relationship
-
the number of instances of one entity that can or must be associated with each instance of another entity
optional, mandatory, one, many - Cardinality Constraints
- a two dimensional table
- relation
-
a collection of related relations
within one database every relation has a unique name - relational database
- Within a relation
-
Columns have unique names.
Every row is unique.
Every column value for every row is single-valued
All values in a column are values from the same domain.
The order of the columns is irrelevant.
The order of the rows is irrelevant -
uniquely identifies a row in a relational table
equivalent to the Key attribute in the ER model - Primary Key
-
used to implement relationships (one-to-one, one-to-many, many-to-many) in relational model
depicted by the Referential Integrity Constraint:
a line with an arrow pointing from the foreign key to its source - Foreign Key
- No primary key attribute may be null
- Entity Integrity
- if a Table A contains a foreign key that matches the primary key of the Table B then values of this foreign key either must match the value of the primary key for some row in table B, or must be null
- Referential Integrity
- Databases reduce information ________
- Redundancy
- ________is one of the primary problems with redundant information
- Inconsistency
- Databases offer several security features including
-
Passwords
Access levels
Access controls - software through which users and application programs interact with a database
- Database Management System (DBMS)
- allows user to create tables and relationships
- Data Definition Component
- allows users to create, read, update, and delete information in a database
- Data Manipulation Component
- allows users to create various interfaces to databases
- Application generation component
- allows DBA (Data Base Administrator) to maintain technical aspects of database systems (such as performance, security, etc.)
- Data Administration Component
-
HOSP 450 DeVry Entire Course
-
Downloading
HOSP 450 DeVry Entire Course
HOSP 450 DeVry Week 1 Discussion 1
Tourism Industry History Overview (graded)
What are some of the reasons people travel? Where have you traveled lately, and why did you travel? What changes are you seeing in travel and tourism?
HOSP 450 DeVry Week 1 Discussion 2
Careers in Tourism (graded)
Tourism is one of the biggest industries in the world. After reading Chapter 3, select one specific job in tourism that you liked and discuss it in detail. Tell us why did you like it, what are some advantages to this job, and how would you go about searching and applying for a job opening of this kind?