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
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
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
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 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
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 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 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 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 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 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 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
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