Computer Science Homework Help

ISM 641 UAGC Wk 4 Creating a Database in Microsoft SQL Server Management Studio

 

Prior to beginning work on this assignment read Chapter 9 of your textbook, review the Microsoft Create a Database website and review any relevant information in this week’s lecture. Review the chapter readings and the website to learn more about the process of creating tables and related attributes.

This assignment will be completed within the Virtual Lab Environment. For this assignment, you will access your virtual Structured Query Language (SQL) server, create a database and translate the normalized ERD from the Week Three assignment into the SQL server entities. Within the SQL server database all the following requirements must be met.

  • Create all entities with appropriate attributes
  • Select appropriate data types for all fields
  • Translate business requirements into integrity constraints
  • Build the ERD using the SQL Server Diagramming tool

Once you have created your SQL server database you will create a document. Take screenshots of the ERD and each of the individual tables within the database and paste these with appropriate labels into the document. You must submit the document via Waypoint for grading. Your instructor will also review your SQL server database within your virtual lab for grading purposes.

The assignment

  • Must be six to eight screenshots in length and formatted according to APA style as outlined in the Ashford Writing Center.
  • Must include a separate title page with the following:
    • Title of paper
    • Student’s name
    • Course name and number
    • Instructor’s name
    • Date submitted