by admin | Sep 1, 2022 | SQL
using MySQL Workbench to describe and reflect upon your work in a paper that describes the process for developing insights. This is the essence of creating analytic horsepower from data.
Based on the scenario above, be sure your paper addresses the following:
Include your problem statement, statement of significance for solving this problem to the literature or industry.
Identify your process for database design and indicate which facets you determined were needed to develop the endpoint insights and thus reflected in the tables and fields you created.
Determine and describe the factors necessary to ensure referential integrity in the database.
Discuss what future research or industry problems could be solved from the existing schema with the addition of additional tables from other data sources (cite your assumptions and references to the literature).
Describe any assumptions or limitations for each relationship between attributes in your schema.
Create an ER diagram (schema) in MySQL Workbench. Take a screenshot of the full schema diagram. Label your screenshots when you paste them into your document.
Export your database to your computer. Be sure and select the option to “Export to Self-Contained File.”
Include a standard title page at the beginning of your document.
Submit your database file and your paper to the assignment Dropbox.
Length: 10-12 pages, not including title page
References: Include a minimum of 3 scholarly resources.
by admin | Aug 29, 2022 | SQL
You will create a technical design specification that will include screenshots of your created MySQL database, your entity-relationship diagram, and a detailed description of what you are solving for. You are permitted to build off of the database created in earlier weeks, or you may start with a new research topic of interest. If you build off of the previously created database, you must add significantly to the previous design to address new analytic issues.
Your database design and document should include the following:
Research problem statement – includes citations to the literature in support of any assertions or facts presented
Stakeholder analysis – identifies who cares about this research, or who will weigh in on future use of the database and/or insights the data can provide
Endpoint discussion – includes intended use of the database and any insights planned to be achieved by the design and the data to be housed in the schema; includes citations to the literature for any assertions or statements of facts presented
Technical design – includes screenshots and/or descriptions of all tables, fields, and description of the data contained in the fields (metadata (i.e., field data types), and example data contained with each field)
At least 8 tables – 8 new tables, if building off your previously developed assignment database), with no orphaned tables (i.e., no tables that do not relate to at least one other table in the schema); each table should have no less than 2 fields and no more than 8 fields
Entity-relationship diagram, with cardinality – includes showing the nature of relationships between related tables
Length: 5-10 pages, not including title page
References: Include a minimum of 3 scholarly resources.
by admin | Aug 24, 2022 | SQL
Based on the database design and report information from previous project sections, explain how you would use SQL commands to generate those reports.
Provide at least 7 examples of SQL statements that you would use to either pull data from your tables or statements to modify data to a specific format such as date/time.
Assignment requirement:
The assignment will need to be in an APA format
Assignment length should be 1-2 pages long, not including the cover and reference page(s)
The assignment should have an explanation of SQL statements and examples of various statements that would be used to generate queries/reports for the project.
This content should be added to the paper that was created in Weeks 1, 2, 3, and 4
by admin | Aug 19, 2022 | SQL
Instructions
In order to complete the assignment, you will need to answer the below questions. Please complete the questions in a Word document. When assigning a name to your document please use the following format (ubogu_Assignment #7). Use examples from the readings, lecture notes, and outside research to support your answers. The assignment must be a minimum of one (1) full page in length with a minimum of two (2) outside sources. Please be sure to follow APA guidelines for citing and referencing sources.
Discuss the two key requirements for writing SQL Server audits to the Windows Security log.
by admin | Aug 19, 2022 | SQL
Instructions
In order to complete the assignment, you will need to answer the below questions. Please complete the questions in a Word document. When assigning a name to your document please use the following format (ubogu_Assignment #7). Use examples from the readings, lecture notes, and outside research to support your answers. The assignment must be a minimum of one (1) full page in length with a minimum of two (2) outside sources. Please be sure to follow APA guidelines for citing and referencing sources.
Discuss the two key requirements for writing SQL Server audits to the Windows Security log.
by admin | Aug 12, 2022 | SQL
11-16 page Employee Trainning Manual for WeWin Legal Services
The purpose of this assessment is to demonstrate an understanding of how data and information can be
used to help an organization make data driven decisions.
As a database administrator, it is important to be familiar with the various types of databases and
database management systems available and be able to distinguish between rational data models,
schemas, manipulations, and attributes. Being familiar with these tools will allow you to perform
common maintenance tasks that will be required to improve the performance and functionality of your
database. In addition, it will allow you to take the appropriate steps to secure your database, protect
the integrity of data, and ensure that your system is scalable and can support future growth.
For this assessment, you will be assuming the role of database administrator for WeWin Legal Services.
You will be evaluating the existing database environment and will be making recommendations for
configuration and optimization with the goal of improving performance.
The organization has been very successful and continues to grow. You are planning on hiring a new
employee to help you manage the database. In preparation for your new hire, you will create a training
manual for your new employees that provides detailed information on how to manage and administer
the database.Specifically you should include guidance on how to:
● Create tables, views, and stored procedures
● Explain steps required to copy a database
● Explain steps required to attach and detach a database
● Explain steps required to import data from external sources
● Utilizing SQL Profiler explain steps required to correctly baseline a database
In addition, you will want to include an introduction that describes your plans of incorporating GIS into
the database along with a description of how GIS can be used within the organization.
The written report must follow APA formatting and include the following sections. Each section should
include the relevant heading:
A. Title Page.
B. Introduction to the database and database management system (1 page)
C. Recommendations on the tools that can be used to visualize data. (1-2 pages)
D. Effective design of a database (2 pages)
E. Database design lifecycle (2 pages)
F. Recognize the effects of poor database design (2 pages)
G. Tools that can be used to visualize data (1-2 pages)
H. Recommendation for database maintenance (2 pages)
I. Summary (1 page)
J. References (1 page)
Before you submit, check to see if you believe you have met the criteria noted below.
Did you…
✓ Provide an insightful and thorough analysis of the database? Did you make sure your
comparisons are clear and clearly defined and described?
✓ Demonstrate sophisticated understanding of all IT systems as they relate to the organization.
✓ Consistently and accurately recommend and analyze the systems discussed.
✓ Accurately and precisely integrate at least five references into the Final Paper and provide
well-documented in-text citations and a reference page?
✓ Make sure your writing is logical and organized? Is your writing free of errors in grammar,
spelling and writing mechanics? Is your report of the specified length. Did you follow APA
formatting throughout?
