A5_SQLSever.pdf - Assignment 5 Using SQL Server and...

This preview shows page 1 - 2 out of 3 pages.

Assignment 5: Using SQL Server and Transaction Open your remote space in the SQL Server. Drop or delete all previous tables you created there [e.g. DROP TABLE VENDOR]. Open a ‘New Query’ window . Download the script A5_initial.sql from Canvas. Review the SQL statements and run them. The SQL script will help you create the tables: Vendor, Product, Customer, Invoice and Line, and load some data rows into the tables. Check to see whether your tables are created. Open another ‘New Query’ window, an d create the Payment table. Remember to save your query for this. See the screenshot below for detailed info. Note: o The PAYMENT table records any time a customer made a payment. o Use PMT_ID INT instead of autonumber for PMT_ID. o Add validation rule to the PMT_TYPE so that it only allows three values [check the script on creating Customer table for the CHECK statement]. o The Cus_code is a foreign key referencing Customer table. Review the scenario below and create the transaction statements.
Image of page 1

Want to read all 3 pages?

Image of page 2

Want to read all 3 pages?

You've reached the end of your free preview.

Want to read all 3 pages?

  • Spring '19
  • Dr. Bin Li
  • Database, Homework, lab, Assignment, Database Concepts

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern