I NEED help trying to get my foreign key to compile. Check my code on the tables, please let me know what is wrong here: CREATE TABLE REP( REP_ID char(3), REP_LNAME varchar(20) NOT NULL,REP_FNAME varchar(20) NOT NULL, REP_STREET char(15), REP_CITY varchar(20) NOT NULL,REP_STATE char(2), REP_ZIP char(5), REP_COMM decimal(7,2),REP_RATE decimal(2,2),PRIMARY KEY(REP_ID)); CREATE TABLE CUSTOMER( CUST_ID char(4), CUST_NAME varchar(50) NOT NULL,CUST_STREET char(20), CUST_CITY varchar(20) NOT NULL, CUST_STATE char(2),CUST_ZIP char(5), CUST_BALANCE decimal(7,2), CUST_LIMIT decimal(7,2),PRIMARY KEY(CUST_ID),FOREIGN KEY(REP_ID) REFERENCES REP); CREATE TABLE PRODUCT( PROD_ID char(5), PROD_DESC varchar(30) NOT NULL,PROD_QUANTITY char(3), PROD_TYPE char(2), PROD_WAREHOUSE char(1), PROD_PRICE decimal(5,2),PRIMARY KEY(PROD_ID); CREATE TABLE INVOICE( INVOICE_NUM char(5), INVOICE_DATE DATE,FOREIGN KEY(CUST_ID) references CUSTOMER(CUST_ID)); CREATE TABLE LINE (LINE_NUM_ORDERED char(2), LINE_PRICE decimal(5,2),FOREIGN KEY(INVOICE_NUM) references INVOICE(INVOICE_NUM));FOREIGN KEY(PROD_ID) references PRODUCT(PROD_ID));
by admin | Sep 23, 2022 | Computer Science | 0 comments
I NEED help trying to get my foreign key to compile. Check my code on the…
A professional Academic Service Provider
Distinguished Writers Ensure Accountability, Confidentiality, High-Quality, and Timely Execution
Distinguished Writers comprises of well-trained professionals striving to give our clients an awesome experience. We engage with our customers throughout the learning process to ensure they are comfortable with both their classwork and homework in order to achieve excellent grades. The team is well-balanced across different fields to suit our clients. Our diversified fields include article writing, thesis proposals, project management, coursework, essay writing, and dissertations among others.Fundamental Values
1. Accountability: The company values professionalism in all our undertakings. As such, we interact transparently with our customers.
2. Confidentiality: The company does not disclose anything to third-parties, and our interactions with customers remain confidential.
3. High-Quality The products are thoroughly proofread and counter-checked to ensure they meet the expected quality levels.
Guarantees
4. Quality is a Guarantee: Our writers are accurately matched with their area of expertise to ensure proper quality is maintained. We are also equipped with adequate software to guarantee error-free products.
5. Money Back Policy: As a client-oriented service, we offer 100% refund for the following: if we received a double payment from you; if you placed similar orders twice (or more) and paid for all of them; the writer has not been assigned; you asked to cancel the order within 20 minutes after placing it; an e-Check payment has been sent (the Dispute Manager will contact you accordingly). Other cases involve a comprehensive investigation by the Dispute Department and feedback given within 24 hours. We value our customers; therefore, the process will be fair, fast, and precise.
5 .Free Revisions: You can request for revisions at no additional cost. Nonetheless, this does not include complete change of the initial order instructions and if it is not past ten days upon your approval.
6. 24/7 Customer Support: Our support staff are always online to provide any assistance when needed
Ordering Process
NOTE: If you have any question, always contact our support team before the commencement of your project. ALL THE BEST”:
Recent Comments