1. List the details of the standard services and special services offered by the company and their prices. (1.3) a. Cus

[answerhappygod]

1 List The Details Of The Standard Services And Special Services Offered By The Company And Their Prices 1 3 A Cus 1 (9.3 KiB) Viewed 37 times

1 List The Details Of The Standard Services And Special Services Offered By The Company And Their Prices 1 3 A Cus 2 (51.23 KiB) Viewed 37 times

1 List The Details Of The Standard Services And Special Services Offered By The Company And Their Prices 1 3 A Cus 3 (51.41 KiB) Viewed 37 times

1 List The Details Of The Standard Services And Special Services Offered By The Company And Their Prices 1 3 A Cus 4 (45.76 KiB) Viewed 37 times

1. List the details of the standard services and special services offered by the company and their prices.
(1.3) a. Customer VARCHAR (7) [primary key 1. CID 2. fname VARCHAR (15) 3. I name VARCHAR (15) 4. address VARCHAR (31) S. Phone Num VARCHAR (11) b. Account 1. AID VARCHAR (7) primary key] 2. CID VARCHAR (7) [Formign key] 3. amount DECIMAL (5.a) 4. comments VARCHAR (31)
C. Services 1. SID VARCHAR (7) 2. AID VARCHAR (2) 3. Service Name VARCHAR (12) 4. recurring Charge INT (1) 5. dake To DATE J. BID VARCHAR (7) [primary hey] 2. AID VARCHAR (7) (Foreign key] 3. billing Date DATE 4. amount DECIMAL (5.2) Foreign key] 5. unusual Fee DECIMAL (5.2) 6. unusual Credit DECIMAL (5.2) 7. due Dak DATE d. Billing [primary Kery] Foreign key
e. Payment 1. PID VARCHAR (7) [Primary key]) 2. AID VARCHAR (7) (FoRigh key 3. Dale DATE 4. amount DECIMAL (5.2) Foreign key 5. payment Method VARCHAR (11) f. event VARCHAR (7) [primary key] VARCHAR (7) Foreign key 1. EID 2. AID 3. ement Name VARCHAR (7) 4. price DECIMAL (5.1) 5. date DATE