Prior to beginning work on this assignment, read Chapters 4, 6, 7, 8, and 15 from your textbook Database Systems: Design, Implementation, & Management (14th ed.). These chapters cover ERDs, normalization, SQL, and database connectivity, which are foundational for this project.
For the final assignment of this course, you will analyze user needs to facilitate the development of a database using an SQL server to track the software and hardware assigned to the employees of a given organization. The purpose of this database project is to facilitate the development of data models that can be translated into relational databases.
Organizations are legally required to track software and ensure that only legally procured software licenses are deployed. As a database architect, your task is to develop a database to track software and hardware for the ConstructCo Company. ConstructCo is a small construction company that employs 50 employees and owns over 80 desktop computers, laptops, and servers. You will be using the SQL Server environment provided during this course. This database will ultimately be used as a basis for a software license management tool to assist the company in tracking how the licenses and workstations/PCs are deployed throughout the organization.
You must use the template when creating your assignment. For each section of the template, include the content required as listed in the following sections.
Document History
The information in this section will be pre-populated in the template. The only required content will be your name in the Revised By column.
Executive Summary
For the executive summary,
- Summarize the project parameters.
- Describe each of the following sections briefly:
- Conceptual Design
- Normalization phase
- Physical design
- Data retrieval and connecting to online databases
There is a sample of an Executive Summary on the Writing Centers page for your reference.
Conceptual design (ERD creation)
For the conceptual design,
- Review the feedback provided for your Week 2 ERD Creation discussion forum.
- Review the .
- Revise your Visio conceptual model (or entity-relationship diagram) for your database.
- Ensure that the following requirements are met:
- Identify all entities and attributes.
- Identify all primary keys.
- Define all relationships between entities.
- Ensure that the following requirements are met:
Normalization
Once the ERD is completed for your ConstructCO database project, you will create the Logical Data Model and check the model against 3rd Normal Form (3NF).
For this phase of the project,
- Review your existing ERD feedback from your Week 3 assignment where you converted your ERD into a Logical Data Model in 3NF.
- Revise your Logical Data Model using information from your Week 3 assignment feedback.
- Describe the three normal forms.
- Justify how each of your tables meets 1st, 2nd, and 3rd Normal Form.
- Utilize a minimum of three professional sources to support your statements.
Physical Design
In Week 4, you created your database in the SQL server you were provided with within your lab environment and translated this design into SQL server tables with appropriate fields.
- Select the appropriate data type for every field.
- The specific data type you select will depend on the size and range of the values that will be stored in the field.
- Specify all primary keys as identity fields and not as auto-increment.
After creating the tables, use the insert command to populate the tables with sample data for all the tables. (This will be affirmed in your SQL server in the lab environment.)
Data Retrieval
Provide select statements to satisfy the following data requests:
- List all available laptops assigned laptops to managers.
- List all available named licenses.
- List the workstations that are over three years old (from the date of purchase) and assigned to leads.
- List the names of the leads, workstation IDs, and location.
- List the names of all the leads in the operations department.
- List all the workstations with a disk space that is less than the average disk space available in all workstations.
- List the names of all managers with employees who have not been assigned a workstation.
- Provide screenshots of the SQL statements used to perform each step and the result sets resulting from the execution of the SQL statements.
- Describe what you did to complete each step.
Connect Online Databases with Front-End Interfaces
In order to connect the database with the front-end interface, you will
- Modify the Java code provided on the website to retrieve the list of all workstations assigned to managers.
- The output must include the
- first name
- last name
- department of the managers
- workstation ID
- date of purchase
- The output must include the
- Modify the Java Code to insert new workstation records in the workstation table if provided with the WorkstationID, type, location, purchase date, memory, disk space, and CPU speed.
- Include the modified code by copying and pasting the code as plain text at the bottom of this section.
The Database Design Framework final project
- must be 15 to 20 double-spaced pages in length (not including title and references pages) and formatted according to as outlined in the Writing Centers resource.
- must include a separate title page with the following in title case:
- title of paper in bold font
- Space should appear between the title and the rest of the information on the title page.
- students name
- name of institution (The University of Arizona Global Campus)
- course name and number
- instructors name
- due date
- title of paper in bold font
- must utilize academic voice.
- Review the resource for additional guidance.
- must include an introduction and conclusion paragraph.
- Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.
- For assistance in writing and , refer to the Writing Center resources.
- must use at least 2 credible sources in addition to the course text.
- The 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.
- To assist you in completing the research required for this assignment, refer to this tutorial, which introduces the University of Arizona Global Campus Library and the research process, and provides some library search tips.
- You may also refer to the tutorial, which explains keyword searching process in the library to find scholarly articles, or the tip sheet, which provides some tips and strategies to make finding credible online research in a search engine such as Google easier and more efficient.
- must document any information used from sources in APA Style as outlined in the Writing Centers guide.
- must include a separate references page that is formatted according to APA Style as outlined in the Writing Center.
- Refer to the resource in the Writing Center for specifications.
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
Leave a Reply
You must be logged in to post a comment.