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

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

 

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.
  • Item #: CIS424-001

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

Price: $20.00
* Marked fields are required.
Qty: *
Reviews (0) Write a Review
No Reviews. Write a Review