CIS 424 Assignment 2 – Creating a Database – Preplanning

CIS 424 WK 10 Assignment 2 – Creating a Database – Preplanning

To buy this assignment, click below link:

https://www.homeworkfortune.com/CIS-424-Assignment-2-Creating-a-Database-Preplanning-CIS424-003.htm

 

Imagine you work in the IT department of a new company called Web Assets (WA), located in Denver CO. WA builds custom Websites and provides technical support for clients. The Chief Information Officer (CIO) wants you to create a new customer database using Microsoft SQL 2012 that will interface with the company’s Web server, so that any inquiries or potential customer data can be stored and retrieved by the sales force. The company is expecting to expand and offer these same services in Phoenix AZ, and Sacramento CA. The pertinent information required from each potential customer includes:

  • First and Last name
  • Contact Phone Number
  • Contact Email address
  • Description of project
  • Address

Since there will be three (3) sites, the CIO wants to ensure that the database and Website are available for customers 24 / 7 days a week.

Write a six to eight (6-8) page paper in which you:

  1. Review the available SQL 2012 editions. Recommend the edition which you believe should be installed based on the usage. Justify your recommendation. Note: Keep in mind to consider scalability into the decision.
  2. Suggest the naming convention you would use for the object in the database.

……….

Further details are hidden…

 

 

CIS 424 Assignment 1 – Pre-planning for a SQL Upgrade

CIS 424 Assignment 1 – Pre-planning for a SQL Upgrade

To buy this assignment, click below link:

https://www.homeworkfortune.com/CIS-424-Assignment-1-Pre-planning-for-a-SQL-Upgrade-CIS424-002.htm

 

Your organization is planning to deploy SQL Server 2012 on two (2) servers as a production database. You have been asked to outline the steps required to implement these severs into the existing network, with the knowledge that 500 users will be connecting to these servers daily. Use the Internet to search for information pertaining to SQL 2012 installation and planning.

Write a four to five (4-5) page paper in which you:

  1. Create a list of items that your organization should consider prior to the installation of the SQL servers.
  2. Review the available SQL 2012 editions (e.g., Standard, Business, Enterprise, Express, and Web and Developer). Recommend the edition of SQL 2012 that your organization should deploy based on the usage. Justify your response. (Hint: Remember to consider scalability into the decision).

……….

Further details are hidden…

CIS 424 Discussions (WK 4, WK 5, WK 6, WK 7, WK 8, WK 9 Discussions)

CIS 424 Discussions (WK 4, WK 5, WK 6, WK 7, WK 8, WK 9 Discussions)

To buy all discussions, click below link:

https://www.homeworkfortune.com/CIS-424-Discussions-WK-4-WK-5-WK-6-WK-7-WK-8-WK-9-Discussi-CIS424-001.htm

 

WK 4 Discussion: “Database Concepts”

Please respond to the following:

  • Per the text, tables are large storage areas that contain specific entity data. A row is considered a record, and each column contains specific attribute data concerning the row. Describe the relationship between the column attribute and the record contained in the row. Then, explain how this information is used to form a relationship with other tables.

WK 5 Discussion: “Entity Relationship Diagram”

Please respond to the following:

  • Suggest three (3) ways that an Entity Relationship Diagram (ERD) can be used to simplify the creation and management of a database from the inception to the creation of the database. Justify the means in which your suggestions simplify the process.

WK 6 Discussion: “Normalization and Performance”

Please respond to the following:

  • Determine whether first normal form (1NF), second normal form (2NF), or third normal form (3NF) should be the goal when a DBA designs a database. Justify your response.
  • Suppose that you overhear two colleagues debating the issue of performance versus availability. Since they are divided; they have asked you to provide an opinion on which of the two concepts is most important when designing and managing a database. Defend your position with at least three (3) reasons.

WK 7 Discussion: “Filegroup”

Please respond to the following:

  • Describe the purpose of file-groups and examine the key ways it helps with minimizing administration to backups or with multiple databases within an organization. Suppose you managed a server with 200 terabytes of data, determine whether you would use full backup, transaction or file groups. Provide a rationale for your response.

WK 8 Discussion: “Advantages of Tables”

Participate in the following activities in order to complete the discussion:

  • Suppose you are a DBA of a 5,000-person organization. Your boss wants to know the advantages of using a partitioned table and the ways it will affect performance of the server, specifically during peak hours. Decide whether or not a vertical partitioned table is more effective than a horizontal table. Justify your response.

WK 9 Discussion: “Clustered versus Non-clustered Indexes” 

Participate in the following activities in order to complete the discussion:

  • As a DBA that manages over 25 SQL Servers, one of your responsibilities is to ensure that data can be easily accessed with the help of indexing. Compare and contrast clustered and non-clustered indexes and provide three examples which demonstrate how indexing can be used to improve the overall performance of a query.