Skip to content
FeatherEssaysFeatherEssays
FeatherEssays
Expert Essay and Academic Writing Services
1-343-433-433-444support@featheressays.com

our-guarantee

  • HOME
  • ABOUT US
  • OUR SERVICES
  • HOW IT WORKS
  • FAQ
  • TESTIMONIALS
  • ORDER A CUSTOM PAPER NOW
  • CONTACT US
  • HOME
  • ABOUT US
  • OUR SERVICES
  • HOW IT WORKS
  • FAQ
  • TESTIMONIALS
  • ORDER A CUSTOM PAPER NOW
  • CONTACT US
July 21, 2017UncategorizedBy classhelp24@gmail.com [email if you need fresh paper done]

Module 3: Critical Thinking

Grade:N/A

Creating Databases and Tables Using SQL Server 2012?(80 Points)

For this Critical Thinking Assignment, you will use the SQL Server named instance SQLSERVERCSU that you created in the Module 1 Critical Thinking Assignment. The objectives of this activity are to configure two new user databases, and to create new tables and a foreign key relationship.

  1. Use SQL Server Management Studio to connect to the SQLSERVERCSU instance. Create a new user database with the name HandsOnOne using the New Database dialog box from Object Explorer. Use the default database settings with the following exceptions:
    1. Data file initial size: 40 MB
    2. Log file initial size: 15 MB
    3. Autogrowth enabled with 15 MB in file growth
    4. Unlimited maximum file size
  2. Use Object Explorer to generate a CREATE DATABASE script from the HandsOnOne database in a new Query Editor window. Change the name of the database in the SQL script to HandsOnTwo and modify the data file initial size to 35 MB. Execute the SQL?script to create the database named HandsOnTwo.
  3. Using either Object Explorer or Query Editor, set the recovery mode for the HandsOnOne database to full. Set the recovery mode for the HandsOnTwo database to simple. Document this step by taking a screenshot of the options page in the database?properties window for each database.
  4. Using Object Explorer?or by running a SQL command in the Query Editor window?rename the HandsOnTwo database to HandsOnTwo_Delete.
  5. Execute a SQL command to DROP the HandsOnTwo_Delete database.
  6. Using Object Explorer, create a new table named Customer with the following column names, associated data types, and constraints:

Column name

Data type

Constraint

CustomerID

int

Primary key

CustomerName

nvarchar(40)

Not null

CustomerAddressID

int

Not null

Take a screenshot of the Table Designer window to document this step.

  1. Using Query Editor, construct and execute a SQL command to create a new table named Address with the following column names, associated data types, and constraints:

Column name

Data type

Constraint

AddressID

int

Primary key

Street

nvarchar(50)

Not null

City

nvarchar(40)

Not null

State

char(2)

Not null

ZipCode

nvarchar(10)

Not null

After executing the SQL command, document this step by taking a screenshot of the Query Editor window to show that the query completed successfully.

  1. Using Object Explorer, create a foreign key relationship between the Customer and Address tables. The AddressID of the Address table is the primary key, and the CustomerAddressID of the Customer table is the foreign key. After creating the key, view the dependencies of the Address table in Object Explorer and take a screenshot to document this step.
  2. Reflect on what worked well and which steps you struggled with in a one page paper that follows theCSU-Global Guide to Writing and APA Requirements.

Combine the four appropriately labeled screenshots and the writing assignment into a single MS Word document, and upload it to the assignment page.

Posted?Thu Feb 25, 2016 at 1:02 pm

Submissions

  • Assignment submittedOpens a dialog 1 itemApr 2, 2016 at 4:52 pm

Re-submit Assignment

Request A Fresh Paper Done For You!You are guaranteed plagiarism free paper within 3-8 hrs
About the author

classhelp24@gmail.com [email if you need fresh paper done]

What are you looking for?
Visit
  • HOME
  • ABOUT US
  • OUR SERVICES
  • HOW IT WORKS
  • FAQ
  • TESTIMONIALS
  • ORDER A CUSTOM PAPER NOW
  • CONTACT US
Happy Client Quotes
  • When I made the decision to seek help from you guys, I didn’t know I was making a choice that would positively change my life forever. I am so much more confident with my ability to go to work and still be able to finish my research paper on time. The research you guys did for me was great and I was highly awarded for it. I mean, all along I was having difficulty managing my time. It was so hard to decide what I ought to give priority, work or research? Thanks to you guys I can now go to work without worrying too much about how great my research should be. I am still the same person, just to be sure, but with lot of skills and ability, courtesy of feather essay. I wish you guys were around 30 years ago when I started doing research while still in school. Great research paper, thanks feather essays.

    Scott Williams, Chicago
  • Feather essays is awesome, really. I can’t just say enough about how well their services are custom-made to meet students’ needs. I mean have been using other services from different websites with erratic degree of satisfaction, but this is way too perfect. I’m thankful their team understand all about essays requirement. I had an essay assignment due in two days so I had to seek for their help, at first I thought they wouldn’t be able to do it perfectly since it was the first time I was using their service. Well, I guess I was wrong. Another thing I also liked about feather essays is how they communicate with clients, so simple, they made me feel at ease even though I was under pressure. From my standpoint, their platform is very intuitive, and it’s pretty much dummy-proof. Thanks to you guys I passed, it’s really hard to recommend anything but feather essays for quality service.

    Joseph Levoh, Phoenix University
  • I mostly do silly mistakes in term papers and essays, and while going through the instructions I used to get stuck after a few steps. I must say I always get annoyed whenever this happened and I had started doubting if I will make it through college. I had lost confidence in myself, I felt uncomfortable and unmotivated in doing assignments. One day I was just going through the internet looking for help with my essay, I found out about feather essay. I was not really sure if they could help me, but considering my situation I decided to give it a try. To say the least, I’ve never regretted making the decision. They are amazing, they offer instant help on assignment and term papers, and whenever I come across any assignment with doubts, all I do is talk to them. They instantly help me with my essays and explain to me everything about it. Thanks to you guys, you help me save a lot of time and concentrate on other class work.

    Eleona Miller, New York City
  • I’d never sought out for help with my essays before, so I was a bit uncertain how to go about it. All this doubts disappeared as soon as I talked to feather essays. You guys took your time to comprehend what my short term and long term needs were, and perfectly lined up different options for me. Considering the fact that I needed a quick response and solution, the options you guys offered were so organized. I thought the steps involved could take up several weeks or days, but I was surprised when all it took was less than four hours. I guess as soon as the agreement was made, the worked started immediately. The way you delivered that essay showed me how top class service professional you guys are. For quick essays help, I recommend you guys. The best thing is that you understand when a client needs more time to think. Thanks to you guys.

    Laurette, Ohio
  • Quick Essay Help

    I’d never sought out for help with my essays before, so I was a bit uncertain how to go about it. All this doubts disappeared as soon as I talked to feather essays. You guys took your time to comprehend what my short term and long term needs were, and perfectly lined up different options for me. Considering the fact that I needed a quick response and solution, the options you guys offered were so organized. I thought the steps involved could take up several weeks or days, but I was surprised when all it took was less than four hours. I guess as soon as the agreement was made, the worked started immediately. The way you delivered that essay showed me how top class service professional you guys are. For quick essays help, I recommend you guys. The best thing is that you understand when a client needs more time to think. Thanks to you guys.

    Diana Ross, California
  • Unique service and quality work!!!Feather essays not only offer wonderful essays but also helped me pass with flying colors!! I could not also believe it. And what makes me love them more is how work is done instantly after ordering!!i will never worry about school essays anymore. Absolutely the best!

    Sasha Kelly, Cleveland
Recent Posts
  • Week 7 – Assignment: Integrate Waste Elimination Techniques into Training Development (10 Points)
    June 5, 2019
  • (Let professional handle your assignment. Get an A) Cloud Architectures Application
    June 25, 2018
  • (Let professional handle your assignment. Get an A) Cloud Architectures Application
    June 25, 2018
  • (Let professional handle your assignment. Get an A) Cloud Architectures Application
    June 25, 2018
  • (Let professional handle your assignment. Get an A) Cloud Architectures Application
    June 25, 2018
  • (Let professional handle your assignment. Get an A) Cloud Architectures Application
    June 25, 2018
  • HOME
  • ABOUT US
  • ORDER A CUSTOM PAPER NOW
  • FAQ
  • CONTACT US
  • TERMS & CONDITIONS
  • CHEAP AND AFFORDABLE PRICES
footer

Copyright © 2015 FeatherEssays