Solution-Build relatively well normalized relational

Build relatively well normalized relational database

Assignment Help Database Management System

Reference no: EM13333981

1) Build relatively well normalized relational database tables to support the "Cheap T-Shirt" web store. Details:

3 styles of shirts
3 colors
3 sizes
MC, Visa & AMEX credit cards accepted
Ship via UPS, FED EX or USPS @ 3.50/shirt No tax
No quantity discounts
3 prices (based on size)
Product ID# for 3x3x3 = 27 variations?
All required customer info to sell and ship Purchase date
Assume web page interface issues are "by others" Show 6 customers and 7 transactions.

2. One example of the following database parameters and defined terms in your database:

Data
Information
Null value
Table
Field
Multipart field
Calculated field
Record
View
Primary key
Foreign key
Linking table
One to one relationship One to many relationship

3. If we added hats in 3 sizes and 3 colors and 3 styles, discuss briefly how many additional tables you 'uld add to the design.

Reference no: EM13333981

Questions Cloud

What is the present value at 10percent discount rate of tax : What is the present value at a 10% discount rate of the depreciation tax shield for a firm in the 35% tax bracket that purchases a $50,000 asset being depreciated straight-line over a 5-year life to a zero salvage value

What is the length of the longest pole : A uniform pole is propped between the floor and the ceiling of a room. The height of the room is 8.00 ft, and the coefficient of static friction between the pole and the ceiling is 0.569. What is the length of the longest pole

Determine the angular frequency of oscillation : A uniform disk of mass m=0.400 kg and radius R=20.0 cm is pinned to the wall near its rim. Find the angular frequency of oscillation if the disk is set swing back and forth

What is the value of par value bond with annual payments : What is the value of a $1,000 par value bond with annual payments of a(n) a. 10% coupon with a maturity of 10 years and a 15% required return b. 8% coupon with a maturity of 10 years and a 8% required return

Build relatively well normalized relational database : If we added hats in 3 sizes and 3 colors and 3 styles, discuss briefly how many additional tables you 'uld add to the design.

What is the required return : 1. If the dividend in year 0 is $1.20 and the growth rate is 3%, then the dividend in Year 7 is equal to:

What is the maximum possible upward force on the foot : Assume a water strider has a roughly circular foot of radius 0.01 mm. What is the maximum possible upward force on the foot due to surface tension of the water

What fraction of the total kinetic energy is rotational : A round object has a rotational inertia of I = ?MR2, where ? is a constant, M is its mass and R is its radius. What fraction of the total kinetic energy is rotational

Explain in plating the zn onto the nail, it required 3.0v : In plating the Zn onto the nail, it required 3.0v. If you were plating Ag onto the nail, do you think that 3.0v will work? If not, should the Ecell be higher or lower. Explain.

User Account

All Pages

Build relatively well normalized relational database

Reference no: EM13333981

Reference no: EM13333981

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT