CIS 336 Entire Course: Devry University For more course tutorials visit www.tutorialrank.com CIS 336 Entire Course: Devry University

_________________________________________

CIS 336 Final Exam 1

For more course tutorials visit www.tutorialrank.com 1. (TCO 1) Most DBMS are referred to as _____________database management systems. (Points : 4) elemental linked hierarchical relational
2. (TCO 1) Data constitutes the building blocks of _____________. (Points : 4) information processing applications programming
3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4) referential restrictive secondary redundant
4. (TCO 2) In a "one-to-many" relationship, which constraint is usually added to the "many" table?
(Points : 4)
UNIQUE
PRIMARY KEY
FOREIGN KEY
NOT NULL

__________________________________________________

CIS 336 Week 1 iLab 1 Devry University For more course tutorials visit www.tutorialrank.com L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data model; the relationship diagram (RD). In this lab, you will draw a relationship diagram for two of the steps shown. Keep in mind when you are trying to decide which side of the relationship should be the "one" side and which should be the "many" that you must first decide which side has the primary key, or unique identifier. Once you have decided the primary key of the relationship, you have identified the "one" side of the relationship. Note that for an RD, the foreign key "many" side of the relationship points to the primary key "one" side. The "one" side should have the arrowhead point of the connecting line.