Implement a database that matches the specifications developed in your Week One individual assignment.

Submit a file containing the SQL code needed to perform the following tasks:

• Create a database named DBM294_LastNamewhereLastNameis replaced with your own last name.
• Create the tables you designed in week one within this database.
• Create the primary and foreign key constraints on those tables in accordance with the original specification.

Your document should be a plain text file (not an MS Office document, PDF, or similar), and it should contain nothing but the SQL code needed to do the above. Make sure that executing your code will result in the creation of the database, tables, and related constraints. This means that you should test your code live against Microsoft® SQL Server® in the Toolwire®environment.

You may use the GUI tools to perform the above tasks and then generate the associated SQL scripts automatically, but again, you should test the execution of those scripts before submitting them.

Do NOT add any data to your tables - that will come in subsequent weeks.

 

Week 1 business proposal is attached below. I need this done asap by today before 8 p.m. 

 

Running head: BUSINESS PROPOSAL1BUSINESS PROPOSALChintan ParekhDBM/294University of PhoenixJuly 19th, 2016DATABASE MANAGEMENT BUSINESS PROPOSAL

• 1495518511-BUSINESS PROPOSAL.docx

ComputerScienceExpert

(11)

Status NEW Posted 23 May 2017 05:05 AM My Price 9.00

-----------

Attachments

file 1495518514-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer