Categories
Computer Science

Prior to beginning this discussion, read Chapter 5: Advanced Data Modeling and C

Prior to beginning this discussion, read Chapter 5: Advanced Data Modeling and Chapter 6: Normalization of Database Tables from the course text. In addition, you may also want to complete problems 10.a, 10.b, and 10.c in Chapter 6. These problems will assist you in completing this discussion.
In relational database design, the process of organizing data to minimize redundancy usually involves dividing a database into two or more tables and defining relationships between the tables. In your initial post, list the first three normal forms, and describe the criteria required to satisfy each one of them. Support your analysis with practical examples.

Categories
Computer Science

Database normalization is the process of organizing the columns (attributes) and

Database normalization is the process of organizing the columns (attributes) and tables (relations) of a relational database to reduce data redundancy and improve data integrity. Denormalization is the reverse process of the normalization process. Denormalization works by adding redundant data or grouping data to optimize the performance. For this assignment:
Denormalize the following three tables, into one table called tbl_location:
tbl_state contains (state_id,state_name)
tbl_county contains (conty_id,county_name)
tbl_city contains (city_id,city_name).
Discuss the steps you took to create the new tbl_location table and if the new table design increased or decreased the performance of the query.
Take a screen shot of the new combined table and attach it (via a Word document) with your response in your initial post.

Categories
Computer Science

Prior to beginning work on this assignment, read Chapter 5: Advanced Data Modeli

Prior to beginning work on this assignment, read Chapter 5: Advanced Data Modeling and Chapter 6: Normalization of Database Tables from the course text. This week you will develop the third task for the Online Food Ordering Database Final Project due in Week 5.
If you designed separate tables for employee and department in your Week 2 assignment, you will want to combine the employee and department tables before you begin this assignment. Your combined table should be called tbl_employee. The tbl_employee contains information about the employee and its department, and it contains the following fields (you may also include other missing fields from your Week 2 design): employee_id, employee_gender ,employee_salary, employee_annual_sallary, department_name, department_location, department head.
For this assignment, you will make use of the database normalization skills you have learned to normalize your database to the third normalization form. You will need to organize your columns and tables to reduce data redundancy and arrange attributes based on the relationships.
In your paper,
Provide a screen shot of the database design before the normalization. Create a heading titled “Database Before Normalization.”
Provide a screen shot of the database design after the normalization. Create a heading titled “Database After Normalization.”
Describe the three normalization forms and the guidelines for transforming from lower normal forms to higher normal forms. Your descriiption should be a minimum of 300 words.
The Online Food Ordering Database – Task 3 paper
Must describe the three normalization forms and the guidelines in a minimum of 300 words and be formatted according to APA style as outlined in UAGC’s The Writing Center Links to an external site..
Must include screenshots of database before and after normalization.
Must include a screen shot, short descriiption, and guideline of Task 3.
Must include a separate title page with the following:
Title of paper
Student’s name
Course name and number
Instructor’s name
Date submitted
Must use at least one scholarly, peer-reviewed, and/or credible sources in addition to the course text.
The Scholarly, Peer Reviewed, and Other Credible Sources Links to an external site.table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
Must document all sources in APA style as outlined in the UAGC Writing Center.
Must include a separate references page that is formatted according to APA style as outlined in the UAGC Writing Center.

Categories
Computer Science

Critical Review Purpose and Audience When you write an essay that reviews the t

Critical Review
Purpose and Audience
When you write an essay that reviews the text of an author, your purpose is to evaluate the potential of their work to the community for whom the text is relevant. For example, if you are writing a critical review of an article in physics, then your commentary should be directed to members of that scholarly community. In writing your critical review, you are sharing your assessment of the text (whether it be an article, book, or book chapter) and supporting your evaluative position with evidence that is valued in the scholarly community. In other words, your critical review should speak into the issues and concerns of the academic community for whom you are writing.
In general, there are many ways that you can write a critical review, but the most common is to:
Provide an introduction that mentions the author and title of the work, along with a brief interpretive summary of his or her main point(s).
Present what you believe are the most important strengths and weaknesses of the text and explain why you believe they are positive or negative (remember, your explanation should be based on disciplinary information and evidence). Use examples from the article to support your claims, and add a statement about why you think this criteria matters.
Therefore, the outline for the Critical Review is:
Introduction
Strengths
a. Key Criteria
b. Key Criteria
Weaknesses
a. Key Criteria
b. Key Critera
Conclusion
You do not need to come up with criteria about every aspect of the text, but focus on a select few that you believe need addressing. You should write the critical review as an argument; that is, you must be able to present your evaluative claims convincingly. You should use examples from the text itself or draw from other disciplinary sources (class discussions, notes, or readings) to support your claims about the value of the text.
This assignment will help you learn to recognize an author’s claims and the logic of his or her argument. It will also help you to begin to position yourself in relation to information in your major as you find yourself agreeing or disagreeing with certain information or aspects of information over others. Finally, the critical review will help you begin to understand that in order to improve upon our current understandings of phenomena, scholars must dismantle the work of others to create new ways of thinking (theories, methods, etc).
For the purpose of this assignment, you should assume that your readers have not read the original text. Convince them that your evaluation is plausible by presenting enough detail and explanation that they can “see” the evaluation of the text as you do.
Requirements
Your critical review should be 3 pages, typed, double-spaced, using 1″ margins and 12 point font. Add the course name, instructor name, your name, and date at the top (single-spaced). Please add page numbers and a Works Cited page.
In addition, address all of my comments from the Rough Draft assignment. Let me know if you have questions about this feedback, well in advance of the final due date.
Use subheadings throughout the essay to guide the reader, and make sure your paragraphs all include a topic sentence and supporting sentences.
See a Sample Critical Review here.
And here is a list of Criteria for the Critical Review Assignment.
Grading:
This paper will be graded based on the following criteria:
Organization: Is the review organized logically? Is each section clearly marked with good transitions (or headings and/or subheadings)? Does the conclusion summarize the review ‘s main points?
Argument: Does the review have a clear claim that is supported throughout? Does each section have sufficient support with examples from the scientific article? Are examples sourced accurately with in-text citations?
Language: Is the review professional in tone, appropriate for publication in a scientific journal? Is the point of view third person (no I, we, or you). Is the wording clear and concise? Is the review free of errors in grammar, punctuation, mechanics, or spelling? Is the Works Cited / References page accurate?

Categories
Computer Science

Database normalization is the process of organizing the columns (attributes) and

Database normalization is the process of organizing the columns (attributes) and tables (relations) of a relational database to reduce data redundancy and improve data integrity. Denormalization is the reverse process of the normalization process. Denormalization works by adding redundant data or grouping data to optimize the performance. For this assignment:
Denormalize the following three tables, into one table called tbl_location:
tbl_state contains (state_id,state_name)
tbl_county contains (conty_id,county_name)
tbl_city contains (city_id,city_name).
Discuss the steps you took to create the new tbl_location table and if the new table design increased or decreased the performance of the query.
Take a screen shot of the new combined table and attach it (via a Word document) with your response in your initial post.

Categories
Computer Science

Prior to beginning this discussion, read Chapter 5: Advanced Data Modeling and C

Prior to beginning this discussion, read Chapter 5: Advanced Data Modeling and Chapter 6: Normalization of Database Tables from the course text. In addition, you may also want to complete problems 10.a, 10.b, and 10.c in Chapter 6. These problems will assist you in completing this discussion.
In relational database design, the process of organizing data to minimize redundancy usually involves dividing a database into two or more tables and defining relationships between the tables. In your initial post, list the first three normal forms, and describe the criteria required to satisfy each one of them. Support your analysis with practical examples.

Categories
Computer Science

Prior to beginning work on this assignment, read Chapter 5: Advanced Data Modeli

Prior to beginning work on this assignment, read Chapter 5: Advanced Data Modeling and Chapter 6: Normalization of Database Tables from the course text. This week you will develop the third task for the Online Food Ordering Database Final Project due in Week 5.
If you designed separate tables for employee and department in your Week 2 assignment, you will want to combine the employee and department tables before you begin this assignment. Your combined table should be called tbl_employee. The tbl_employee contains information about the employee and its department, and it contains the following fields (you may also include other missing fields from your Week 2 design): employee_id, employee_gender ,employee_salary, employee_annual_sallary, department_name, department_location, department head.
For this assignment, you will make use of the database normalization skills you have learned to normalize your database to the third normalization form. You will need to organize your columns and tables to reduce data redundancy and arrange attributes based on the relationships.
In your paper,
Provide a screen shot of the database design before the normalization. Create a heading titled “Database Before Normalization.”
Provide a screen shot of the database design after the normalization. Create a heading titled “Database After Normalization.”
Describe the three normalization forms and the guidelines for transforming from lower normal forms to higher normal forms. Your descriiption should be a minimum of 300 words.
The Online Food Ordering Database – Task 3 paper
Must describe the three normalization forms and the guidelines in a minimum of 300 words and be formatted according to APA style as outlined in UAGC’s The Writing Center Links to an external site..
Must include screenshots of database before and after normalization.
Must include a screen shot, short descriiption, and guideline of Task 3.
Must include a separate title page with the following:
Title of paper
Student’s name
Course name and number
Instructor’s name
Date submitted
Must use at least one scholarly, peer-reviewed, and/or credible sources in addition to the course text.
The Scholarly, Peer Reviewed, and Other Credible Sources Links to an external site.table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
Must document all sources in APA style as outlined in the UAGC Writing Center.
Must include a separate references page that is formatted according to APA style as outlined in the UAGC Writing Center.

Categories
Computer Science

Cloud-Enabling Technologies Overview It is often necessary for information techn

Cloud-Enabling Technologies
Overview
It is often necessary for information technologists to evaluate new and emerging technologies and to assess the potential impacts on an enterprise’s current information technology (IT) operations and future IT project planning.
In this assignment, you write about the interaction of cloud-enabling technologies.
Directions
Pick two of the following cloud-enabling technologies that directly interact with one another:
Broadband network technology.
Data center technology.
Internet technology.
Virtualization technology.
World Wide Web (WWW) technology.
Multitenant technology.
Service technology.
Write 3–4 pages explaining how your chosen cloud-enabling technologies function. Explain how they interact with one another to create a cloud consumer network, a cloud provider network, an enterprise internet connection, or another cloud component.
Make sure to do the following:
Describe the primary functions of cloud-enabling technologies.
Explain how cloud-enabling technologies interact to create a cloud component.
Submission Requirements
Submit a single 3–4 page Word document with both parts of this assignment.
Font: Times New Roman, 12 point.
Format: Double spaced lines. Use current APA style and format.

Categories
Computer Science

This assignment is designed to allow you to display your mastery of the material

This assignment is designed to allow you to display your mastery of the material and to provide you with a creative and realistic way to apply the knowledge and experience you gained.
Create a detailed, organized, and unified technical solution given the scenario described below. Your solution should draw on the content presented in the course. The outline below lists points/topics to cover. You are free to provide additional, related information. Provide technical and justification reasons for each choice, citing resources as appropriate.
Option #2: You work in the IT department for a software development firm. The firm is interested in setting up a server lab environment that requires a Windows Active Directory infrastructure.
This lab will require centralized management of user identity, resources, and data. The firm is interested in using this lab environment to create and test software that they develop for clients. The lab should also allow them to test other technical scenarios that concern the firm.
The firm is very interested in the new Container feature offered in Windows Server 2016. This will require the ability to use Containers to develop and test applications and software that the firm is working on.
The firm is also concerned about its ability to recover and continue business operations in the event of a major disaster. Therefore, the lab will be used to perform and test high availability and disaster recovery scenarios without having a major impact on software development and testing activities currently taking place in the lab.
Requirements
Address each of the following topics in your plan:
Deployment and Server Editions
How many total servers are needed? Which roles will be combined?
What edition of Windows will be used for each server (e.g., Standard, Datacenter)?
Will Server Core be used on any servers?
Where are each of the servers located (which of the two sites)?
Active Directory
This environment should replicate a real production Active Directory environment.
Number of AD domains? Keep in mind that this is a test lab where a variety of scenarios will require testing. Make sure you discuss domain name design.
Will there be any Read-Only Domain Controllers? Explain why or why not.
How will AD organizational units be organized (considering how group policy will be used and users will be organized?
Discuss requirements for deploying Active Directory.
Containers
Discuss the role that containers play and how they can benefit the firm.
High Availability
How will clustering be utilized?
What role will load balancing play?
Hyper-V
Discuss the role of Hyper-V and benefits.
How will Hyper-V high availability be achieved?
Disaster Recovery
What role will Windows Backup Server play?
Discuss backup strategies.
Is a third-party backup and recovery solution required?
Maintenance
How will Windows Server Update Services be utilized?
Discuss a plan to keep Servers updated and patched with minimal interruption to servers and services. Keep in mind, Microsoft issues patch and updates to its operating systems and software on the second Tuesday Links to an external site of each month. Your plan should be based on this schedule.
Monitoring
Discuss the importance of system monitoring.
Describe tools available for monitoring Windows Servers.
Include one Windows Server 2016 tool that is not included in the readings or text. This may require additional research.
Your paper should be 6-8 pages in length (not including diagrams) and conform to the standards in the CSU Global Writing Center Links to an external site.. Include at least one diagram illustrating your chosen Active Director design with DNS namespace hierarchy. Include no fewer than three scholarly references in addition to the course textbook, readings, and media. The CSU Global Library is a good place to find these references.

Categories
Computer Science

Cloud-Enabling Technologies Overview It is often necessary for information techn

Cloud-Enabling Technologies
Overview
It is often necessary for information technologists to evaluate new and emerging technologies and to assess the potential impacts on an enterprise’s current information technology (IT) operations and future IT project planning.
In this assignment, you write about the interaction of cloud-enabling technologies.
Directions
Pick two of the following cloud-enabling technologies that directly interact with one another:
Broadband network technology.
Data center technology.
Internet technology.
Virtualization technology.
World Wide Web (WWW) technology.
Multitenant technology.
Service technology.
Write 3–4 pages explaining how your chosen cloud-enabling technologies function. Explain how they interact with one another to create a cloud consumer network, a cloud provider network, an enterprise internet connection, or another cloud component.
Make sure to do the following:
Describe the primary functions of cloud-enabling technologies.
Explain how cloud-enabling technologies interact to create a cloud component.
Submission Requirements
Submit a single 3–4 page Word document with both parts of this assignment.
Font: Times New Roman, 12 point.
Format: Double spaced lines. Use current APA style and format.