Question

Please highlight was is needed. I have completed # 2, 6, and I beleive 7.

Everything related to show 7 needs to be highlighted purple which was everything with capital letters needs to be highlighted purple which I have done. The yellow highlight shows all the empty lines which are highlighted already as well. If I could get the rest done that would be great.

1. All SQL scripts should be written to execute in a SQL Server 2016 database. All sQL scripts should include introductory comments. 3. Introductory comments should include separators like -, or before and after the introduction. Note: /*comments */can be used for header or longer comments. 4. Introductory comments should include course name, assignment name, purpose of the script, as well as either Created by/on or Modified by/on with student name, and date. 5. All SQL scripts should include at least one empty line between statements. 6. Each statement should be preceded by comments describing the purpose of the 2. statement. For assignments, this could include the specific directions for each statement. Use or or 7. All uppercase letters should be used for each SQL reserved word. 8. All lowercase letters should be used for table and field names. 9. Separate lines should be used for each subcommand. 10. Indentation is used to improve readability of statements. For example, subcommands continued on the next line should be indented. 11. Manipulations of a specific record must be conducted using the primary key or a field that reduces the number of required commands.

Answer 1

Solution --Create the Customer table CREATE TABLE customer cus_code VARCHAR(10) NOT NULL UNIQUE, cus Iname VARCHAR(50), cus_fname VARCHAR(50), cus_initial CHAR(1), cus_areacode CHAR(3), cus_phone CHAR(7) cus balance MONEY DEFAULT 0.00, PRIMARY KEY(cus_code)); --Create the Vendor table CREATE TABLE vendor( V_code VARCHAR(10) NOT NULL UNIQUE, v_Iname VARCHAR(50) V_contact VARCHAR(100), areacode CHAR(3) V vphone CHAR(7),

V state CHAR(2), v order CHAR(1) NOT NULL DEFAULT 'N', PRIMARY KEY(v_code)); --Create the Product table CREATE TABLE product( p_code VARCHAR(10) NOT NULL UNIQUE, p_descript VARCHAR(100), p indate DATETIME, p_goh INT NOT NULL p_min INT NOT NULL, p price SMALLMONEY NOT NULL p_discount SMALLMONEY V_code VARCHAR(10), PRIMARY KEY(p_code), FOREIGN KEY(y_code) REFERENCES vendor):

--Create the Invoice table CREATE TABLE invoice inv_number VARCHAR(10) NOT NULL UNIQUE, cus code VARCHAR(10) NOT NULL, inv date DATETIME NOT NULL, PRIMARY KEY(inv_number), FOREIGN KEY(cus code) REFERENCES customer); --Create the Line table CREATE TABLE line( line number VARCHAR(10) NOT NULL UNIQUE inv number VARCHAR(10) NOT NULL, p code VARCHAR(10) NOT NULL, line units INT, line_price SMALLMONEY, PRIMARY KEY(line_number) FOREIGN KEY(inv_number) REFERENCES invoice, FOREIGN KEYP_code) REFERENCES product);

--Create the list table CREATE TABLE list( list_id VARCHAR(10) NOT NULL UNIQUE, list_type VARCHAR(25) NOT NULL, list_display VARCHAR(25) list value VARCHAR(25) status CHAR(1) NOT NULL, PRIMARY KEY(list_id));