TAL DISTRUBUTOR EXCERSISES.
1. Using your knowledge of TAL Distributors, determine the functional dependencies that exist in the
following table. After determining the functional dependencies, convert this table to an equivalent
collection of tables that
Chapter 6 TAL DISTRIBUTOR EXCERSIES.
The following exercises are based on the TAL Distributors database as designed in Example 1 in this chapter.
In each exercise, represent your answer in DBDL and with a diagram. You may use any of the styles
Microsoft Access was used for this Assignment.
1. List the number and name of all customers.
SELECT CustomerNum, CustomerName
2. List the complete Item table.
3. List the number and name of every customer represented by
1. What two conditions must be met to make an entity a weak entity? Existence-dependent
and has a primary key that is partially or totally derived from parent entity in the
2. What is a strong relationship, and how is it depicted in a crows f
1. What is the difference between a database and a table? Tables or relations hold entities
that are related. A database can hold many tables with relationships between them.
2. What does it mean to say that a database has both entity integrity and refere
1. Define each of the following terms:
a. DataRaw facts that have not yet been processed to reveal their meaning to
the end user.
b. FieldAn alphabetic or numeric character or group of characters that define
the characteristics of a person, place, or thin
CIS 240 Review Sheet CHs 1-4
This study guide is not inclusive of all material that will be covered on the exam! This is
a supplemental tool for your use in preparing for the exam. For all terms listed in this
study guide (i.e. entity), study more than ju
CIS 240 Study Guide CH 5-8
specialization hierarchy, IS-A relationships
disjoint / non-overlapping subtypes
completeness constraints partial and total
Is the highest level always the most desirable?
CIS 240 Study Guide CH 9, 10, 12, 16
This study guide is not inclusive of all material that will be covered on the exam! This is a
supplemental tool for your use in preparing for the exam. For all terms listed in this study guide
(i.e. DBMS), study more t
1. Discuss the importance of data models. Data models can be used as a communication
tool, give an overall view of the database, organize data for various users, and are an
abstraction for the creation of good database. They are an effective blueprint of
Chapter 4 Review Question
1. What two conditions must be met before an entity can be classified as a weak entity?
The entity must be existence-dependent on its parent entity and it must inherit at least part of
its primary key from its parent entity.
Chapter 7 Review Question
1. In a SELECT query, what is the difference between a WHERE clause and a HAVING clause?
In short if both WHERE and HAVING clause is used in a SELECT query with aggregate
function or GROUP BY clause, it will execute before HAVING
Chapter 6 Review Question
1. What is normalization?
Database Normalization is a technique of organizing the data in the database. Normalization is a
systematic approach of decomposing tables to eliminate data redundancy and undesirable
Chapter 2 Review Question
Discuss the importance of data models.
It is a way to represent reality.
Is the blueprint for the database.
The database designer uses data models to facilitate the interaction among designers.
2. What is a business rule, and
Chapter 8 Review Question
1. What is a CROSS JOIN? Give an example of its syntax.
A CROSS JOIN is identical to the PRODUCT relational operator. The CROSS JOIN is also known as
the Cartesian product of two tables. For example, if you have two tables, AGENT
Chapter 1 Review Question
2. What is data redundancy, and which characteristics of the file system can lead to it?
Data redundancy is when it is Unnecessarily storing same data at different places.
3. What is Data independence, and why is it lacking in fi
Chapter 10 Review Question
1. Explain the following statement: A transaction is a logical unit of work.
A transaction is a logical unit of work that must be entirely completed or aborted; no
intermediate states are accepted. In other words, a transaction,
Chapter 3 Review Question
1. What is the difference between a database and a table?
A table is a logical structure that represents an entity set and it is only one of the
components of a database.
The database is a structure that houses one or more tabl
Chapter 9 Review Question
1. What is information system? What is its purpose?
An information system is a system that provides the conditions for data collection, storage, and
retrieval facilitates the transformation of data into information provides manag
Chapter 5 Review Question
1. What is an entity supertype, and why is it used?
An entity supertype is a generic entity type that is related to one or more entity subtypes, where
the entity supertype contains the common characteristics and the entity subtyp
I used MS Access for this assignment. These instructions mentioned are for MS Access only.
TAL Distributors Database was used. I didnt know exactly how you wanted us to describe it but I did it to the
best of my abilities and I have also provided pictures