Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . In a new SQL Server 2 0 1 9 instance on either an existing Windows Server image or a new one. Choose appropriate
In a new SQL Server instance on either an existing Windows Server image or a new one. Choose appropriate service accounts, enable remote SQL TCP connections, and ensure that all SQL necessary SQL Server services are set to start automatically and accept secure network connections.
Design a database that will be used to store information for an IT Consulting Company that provides services for client organizations as well as purchases and resells equipment servers desktops, software, routers, etc. to clients. Ensure that you diagram the tables, columnsdatatypes and table relationships.
Create the database and tables from the previous step as well as populate the tables with at least records you can use a bulk import process to save time Also ensure that the tables have the appropriate indexes and that the database has appropriate database options.
Create a SQL login and user that can be used to access and modify records within the database, as well as a separate SQL login that can only read records within the database. Also create a login for the app developer within your organization. Use appropriate names for each one.
Ensure that you can isolate performance problems when they occur, as well as monitor ongoing SQL performance and usage. Optimize the performance of your database by performing the appropriate tasks. Ensure that your database is regularly checked for inconsistencies and backed up Any problems should be emailed to your trioscollege.com email address.
Provide suitable fault tolerance for your database.
For steps document what you did to achieve each step pointform under each step within this document, with appropriate screenshots or code output to illustrate your choices Hint: You can reuse parts of the code used to mark your SQLA final project!
Send me a copy of this document as well as a FULL backup of your database for marking either via email or MS Team chat
Optional bonus: Design a new database that will be used as a data warehouse for your IT Consulting Company database. Identify which information from your database is most valuable for business intelligence analysis. Next, define your dimensions for the data warehouse as well as the data points to store in the fact table. Finally, select the columns to include in each dimension table, and optionally implement your desig
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started