In addition to the Database Management System template including section headings (project outline), submit a Transact-SQL Implementation section of 4–5 pages that includes the following SQL statements for your chosen case study company (AgCredit):
1. Data Definition Language (DDL): Write the CREATE scripts to create the data structures in the database schema. Based on the physical data model that you presented, the scripts should match the data model (e.g., entities, attributes, relationships, constraints, etc.).
2. Transact-SQL (T-SQL): Include transactions (with flow control using Begin, End, Commit, and Rollback) as follows:
a. SELECT statements that identify which products should be purchased based on inventory level constraints
b. INSERT statements that add products identified in (a) to the Purchases table
c. SELECT statements that identify that products that were previously unavailable are now available to ship
d. INSERT statements that add products identified in (c) to the Shipping table
3. Data Manipulation Language (DML): Include the following SQL statements:
o UPDATE statements to mark any previously unavailable products as “shipped” and any orders not previously completely shipped as “completely shipped”
Be sure to provide a rationale for your approach to the SQL statements.
All sources should be cited both in-text and in the References section using APA format.
Links
https://class.ctuonline.edu/_layouts/MUSEViewer/MUSE.aspx?mid=4004674
https://msdn.microsoft.com/en-us/library/ff848799.aspx
https://msdn.microsoft.com/en-us/library/ff848766.aspx
https://msdn.microsoft.com/en-us/library/ms174290.aspx
https://msdn.microsoft.com/en-us/library/bb510741.aspx
http://www.w3schools.com/sql/