I need help with this assignment. All instruction are in .docx, there will is link in this .docx with blue letter with underline underneath that will follow you with instruction of that assignment. If you have any question let me know please.

I need this asap.

Thank you!

 

Module 09 Database Project - SQL Server DatabaseImplementationThis is the last submission involving your Database project. This phase of the project willallow you to implement your database design from the first two phases into SQL Server.Please check with your instructor concerning which files need to be submitted.Before You StartDownload and save theDatabase Implementation Instructionsdocument to your computer.These instructions give details on how to create the database, tables, and queries, and howto submit the database. Please note that these instructions were written for SQL Server2005, but are only slightly different for SQL Server 2008.Steps of Your Assignment1.Use SQL Server to build a database. The database name should be yourCompany_lastName where lastName is your last name.2.Create each of the following tables:*Call*Customer*Department*Employee*Product3.Populate the tableswith at least four records in each table (three for the Departmenttable). Make-up your own data to populate the tables based on your companyinformation. Data should be selected to demonstrate the required outputs outlined in thequeries.4.Use an identity column for the primary keyin each table, except for the tables createdfrom the associative entities.5.Implement the referential integrity (foreign key) constraints. Remember that the datatype must be the same between a foreign key and its associated primary key. It is notnecessary to implement any other constraints or indexes.6.Create the following queries.Name of query is given in ( ) at beginning of query.o(AllProducts) List all products in inventory. For each product, list number, name,location, and quantity on hand. Sort entries in order by location.o(SalesStaff) List name (last, first), job title, office and phone for all sales staffpersonnel. (Sales Department)

• 1494464951-Module 09 Database Project.docx

ComputerScienceExpert

(11)

Status NEW Posted 11 May 2017 01:05 AM My Price 8.00

-----------

Attachments

file 1494464952-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