I need help with this procedure, I am using Microsoft Sql Server 2012. I need it
ID: 3835886 • Letter: I
Question
I need help with this procedure, I am using Microsoft Sql Server 2012. I need it in SQL, not in Oracle. Please help!:)
2. Create table as shown in the diagram. Please make sure you specify the primary and foreign key in the tables. [6+2] FIGURE 10.1 THE CH10 SALECO DATABASE RELATIONAL DIAGRAM LINE INVOICE INV NUMBER INV NUMBER UNE NUMBER CUST NUMBER INV DATE PROD CODE INV SUBTOTAL LINE UNITS INV TAX LINE PRICE PRODUCT INV TOTAL LINE AMOUNT PROD CODE CUSTOMER INV PAY TYPE PROD DESCRIPT CUST NUMBER INV PAY AMOUNT PROD INDATE CUST LNAME INV BALANCE PROD.QOH CUST FNAME PROD MIN CUSTLINITIAL PROD PRICE CUST AREACODE co PROD DISCOUNT CUST PHONE VENDOR VEND NUMBER v VEND NUMBER L ACCT TRANSACTION CUST BALANCE ACCT TRANS NUM VEND-NAME ACCT TRANS DATE VEND CONTACT CUST NUMBER VEND AREACODE ACCT TRANSTYPE VEND PHONE ACCT TRANS AMOUNT VEND STATE VEND ORDERExplanation / Answer
A primary key also called a primary keyword, is a key in a relational database that is unique for each record.
Primary keys are CUST_NUMBER (CUSTOMER table)
INV_NUMBER (INVOICE table)
INV_NUMBER (LINE table)
LINE_NUMBER (LINE table)
PROD_CODE (PRODUCT table)
ACCT_TRANS_NUM (ACCT_TRANSACTION table)
VEND_NUMBER (VENDOR table)
A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table.
Foreign keys are those that which are primary keys in another table, through foreign keys is that two tables are get related.
CUST_NUMBER (INVOICE table)
CUST_NUMBER (ACCT_TRANSACTION table)
INV_NUMBER (LINE table)
PROD_CODE (LINE table)
VEND_NUMBER (PRODUCT table)