Week 1 Dropbox
1.2 What is the most commonly used type of database?
The most commonly used type of database is the relational database. The relational database
stores data in the form of tables or relation.
1.7 Define the terms data and informati
Week 4 Dropbox
4.41 Determine whether each table is either in BCNF and 4NF. State your assumptions.
The PT_SESSION table is neither in BCNF nor in 4NF. In this table, multivalued dependencies
exist and even it contains informati
Week 5 Dropbox
5.20 Explain, in general terms, how the traditional E-R model, the IE Crows Foot version, the
IDEFIX version, and the UML version differ. Which version is used primarily in this text?
The traditional E-R model uses diamond shape to
Week 8 Dropbox
8.2 Describe why database redesign is necessary.
Database redesign is necessary under these conditions:
Incorrect initial design- If there we mistakes during the initial design which would not allow for
the database originally envi
Week 2 Dropbox
2.20 Write an SQL statement to display unique WarehouseIDs.
SELECT DISTINCT WarehouseID
2.29 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, and
QuantityOnHand for all products having a Quan
Week 3 Dropbox
3.54 Consider the relation:
PERSON_2 (Name, Sibling, ShoeSize,Hobby)
Assume that the following functional dependencies exist:
Describe deletion, modification, and insertion anomalies for
Week 6 Dropbox
A. Convert this data model to a database design. Specify tables, primary keys, and foreign
keys. Using Figure 6-41 as a guide, specify column properties.
B. Describe how you have represented weak entities, if any exist.
7.4 Write a CREATE TABLE statement for the DEPARTMENT table.
CREATE TABLE DEPARTMENT (
Department_name char(60) NOT NULL,
Budget_code char(60) NOT NULL,
Office_number char(20) NOT NULL,
Phone char(15) NOT NULL
7.5 Write a CREATE
March 19, 2017
The Elliot Bay Sports Club owns and operates three sports club facilities in
Houston, Texas. Each facility has a large selection of modern exercise
equipment, weight rooms, and rooms for yoga and other