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
1. List the details of the standard services and special services offered by the company and their prices. (1.3) a. Cus
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
1. List the details of the standard services and special services offered by the company and their prices. (1.3) a. Cus
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!