Assignment 1
Database Modeling
After reading this week's article, "Modeling for the Future," expand on the subject of Database Modeling. There are several tools listed and reviewed in the article. Research these tools further (or identify other commercially available modeling tools), compare three tools, and apply your findings as if you were selecting one of the tools for use at your place of employment. Be sure to include comparative detail information on implementation scenarios, target industries, company types most suited for the tool, costs, software type, the type of operating system required, and the target user population.
Select one of the tools previously compared, and discuss the benefits and the shortcomings. Discuss how this tool will help meet the data modeling requirements for your employer's database development needs.
Be sure to integrate vocabulary from the text to demonstrate your understanding of concepts. In addition to the article, include a website reference for each of the three tools you research. The website references must come from the software vendor or other credible source.
Your paper must be two to three pages in length and must be formatted according to APA style as outlined in the Ashford Writing Center.
Modeling for the Future
https://books.google.com/books?id=xz4EAAAAMBAJ&pg=PA60&dq=Modeling+for+the+future+InfoWorld&hl=en&sa=X&ved=0ahUKEwinmI6fl63OAhXDOCYKHYapCnQQ6AEIHDAA#v=onepage&q=Modeling%20for%20the%20future%20InfoWorld&f=false
Assignment 2
Customer Service Database
Show a Structured Query Language (SQL) query, and screenshot your results into a Microsoft Word document to submit to your instructor. For Part 2, provide explanations and screenshots documenting Steps 1 through 4.
Part 1:
Please download, unzip, and open this zip file of the Microsoft Access Customer Service Database.
Save your database.
You should now be able to use Microsoft Access and the database created to complete the assignment.
Part 2:
Add 10 customers to the database using the Customers table. Show the table, including the SQL Code.
Using SQL query, update more than one element in a customer record. Show before and after data, including the SQL code.
Add an 11th customer, and then delete them with a SQL query. Show before and after data, including the SQL Code.
Create a report displaying the customer records using multiple tables. Identify the primary keys in the tables you are reporting on, and show the results of your report.
Screenshot your results into a Microsoft Word document to submit to your instructor using your First and Last name as the file name.
SQL statements should be complex. All data and screenshots should be included in a word document with an explanation of the actions you performed. The document should have a minimum of six screenshots with explanations.
Your paper should be formatted according to APA style as outlined in the Ashford Writing Center.
Assignment 3
The Final Project consists of building a customer service database to be submitted by the final day of the course.
Focus of the Final Project
Using the Microsoft Access database you created in Week Three: Customer Service Database, complete the following:
Output three queries using Structured Query Language (SQL) code (not the standard access view). Provide examples of operations. You should include the following:
A query on all contacts in the customers table showing first name, last name, address, e-mail address and three additional fields from the table.
An update query that changes one or more customer records but not all records.
A delete query that removes one or more customer records but not all records.
Using SQL commands add a field called Birthday to the Customers table. Populate the Birthday field for some of the table records (not all of the table records). This is important for step #4. Populate all other fields with data. Show your SQL query in a screenshot with before and after data.
Report on Customers in Database showing Names, State, and Phone Numbers. Show the SQL query and the resulting report in a screenshot.
Create a report showing contact names and birthdays. Do not show records without a birthday. Show the report and the SQL query in a screenshot.
Provide an explanation of referential integrity, including how a lack of referential integrity can compromise data in the dataset and provide examples. Identify the referential integrity in your database. Show the affected tables in each dataset and how the data elements are impacted as the result of add, change, or deletion (UAD) operations in a before and after screenshot.
All data and screenshots should be included in a Word document with an explanation of the actions you performed.
Book:
Hernandez, M. J. (2003). Database Design for Mere Mortals (2nd ed.). Boston: Addison-Wesley. ISBN: 9780201752847