Need help with these tables ASAP if someonce ca help me #5 from Ch. 5, Pg. 175 o

Question

Need help with these tables ASAP if someonce ca help me

#5 from Ch. 5, Pg. 175 of your text (modified) 3. TAL Distributors is considering changing its business model so that many sales reps can represent one customer and one sales rep can represent many customers. Using this information, convert the following unnormalized relation to fourth third normal form. Customer (Customertum SustocverNacos, Street Last Name, EirstName, Street, City, State, PastalCode, Commission, Rate)) #2 from Ch. 5, Pg. 175 of your text (modified) 4. Colonial Adventure Tours is considering changing the way it handles reservations. Instead of storing the number of persons associated with one reservation, the company would like to store the name and address of each per- son associated with each reservation. If Colonial Adventure Tours decides to implement this change, the trip price and other fees amount for each trip would be dependent on only the trip ID. Determine the multivalued dependencies in the following table, and then convert this table to an equivalent collection of tables that are in feurth third normal form. ustomerticstName, Address, City, State, Pestalode, Phone))

Explanation / Answer

TABLE NAME CUSTOMER

CREATE TABLE CUSTOMER(

CUSTOMERNUM NOT NULL PRIMARY KEY,

CUSTOMERNAME VARCHAR,

BALANCE NUMBER,

CREDITLIMIT NUMBER,

ADDRESSID VARCHAR FORIEGN KEY REFERENCES ADDRESS(ADDRESSID)

)

TABLE NAME SALESREP

CREATE TABLE SALESREP(

REPNUM VARCHAR NOT NULL PRIMARY KEY,

LASTNAME VARCHAR,

FIRSTNAME VARCHAR,

COMMISION NUMBER,

RATE NUMBER,

ADDRESSID VARCHAR FORIEGN KEY REFERENCES ADDRESS(ADDRESSID)

)

TABLE NAME REP_CUSTOMER

CREATE TABLE REP_CUSTOMER(

REPNUM NOT NULL REFERENCES SALESREP(REPNUM),

CUSTOMERNUM NOT NULL REFERENCES CUSTOMER(CUSTOMERNUM)

)

TABLE NAME ADDRESS

CREATE TABLE ADDRESS(

ADDRESSID VARCHAR NOT NULL PRIMARY KEY,

STREET VARCHAR,

CITY VARCHAR,

POSTALCODE NUMBER

)

============================

TABLE NAME CUSTOMER

CREATE TBALE CUSTOMER(

CUSTOMERNUM VARCHAR NOT NULL PRIMARY KEY,

CUSTOMERLASTNAME VARCHAR,

CUSTOMERFIRSTNAME VARCHAR,

ADDRESSID FORIEGN KEY REFERENCES ADDRESS(ADDRESSID)

)

TABLE NAME TRIP

CREATE TABLE TRIP(

TRIPID VARCHAR NOT NULL PRIMARY KEY,

TRIPDATE DATE,

TRIPPRICE NUMBER,

OTHERFEES NUMBER

)

TABLE NAME RESERVATION

CREATE TABLE RESERVATION(

RESERVATIONID NOT NULL PRIMARY KEY,

TRIPID VARCHAR NOT NULL REFERENCES TRIP(TRIPID),

CUSTOMERID VARCHAR REFERENCES CUSTOMER(CUSTOMERID)

)

TABLE NAME ADDRESS

CREATE TABLE ADDRESS(

ADDRESSID VARCHAR NOT NULL PRIMARY KEY,

STREET VARCHAR,

CITY VARCHAR,

POSTALCODE NUMBER,

PHONE VARCHAR

)

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.