2023 Individual Assignment 4 Part A Answer the following questions based on the textbook 5 points each 1 What | Assignment Collections

Computer Science 2023 sql assignment 4 online

2023 Individual Assignment 4 Part A Answer the following questions based on the textbook 5 points each 1 What | Assignment Collections

Individual Assignment 4

 

Part A:  Answer the following questions based on the textbook – 5 points each.

1.       What are the four categories of update anomalies and why could these problems occur when a relation is in first normal form but not in second normal form?   

 

 

 

2.       Give an example of a column A and a column B such that B is functionally dependent on A.  Give an example of a column C and a column D such that D is not functionally dependent on C.

 

 

 

Part B:  Answer Question #2 from the Premiere Products Exercises on pg. 180 in the textbook.  (Note: two-part answer – 5 points each)

 

 

 

Part C:  Answer Question #1 from the Henry Books Case on pg. 181 in the textbook.  (Note: four-part answer – 10 points total)

 

 

 

 

 

 

 

 

 

 

Part D: Normalization – 45 points

Data File needed for this Problem:

·         Student.xlsx

 

Data Files to Upload to Moodle:

·         Students.accdb

 

Your client wants to build a database for a school that contains the contact information for students as well as the courses they have taken and the grades they have received. They provided the attached Excel spreadsheet to show you how they are currently storing this information.

 

Upon studying the file, you see that it is not properly normalized. For this assignment, you will need to create a database with normalized tables, similar to the classroom discussion.

 

Your new database should include the following elements:

 

a) Main table for student information. The data provided in the Excel spreadsheet should be entered into the tables in proper format. Remember that it may be necessary to breakdown the Excel name or address fields into multiple columns in your new Access table.

 

b) Phone Type Table. It should contain, at minimum, the types of phones listed in the Excel spreadsheet.

 

c) Student Phone Table. It should contain the student ID, phone type ID and the student’s phone number.

 

d) Course Table. This table should contain the Course # and Description for each course offered at the school.

 

e) Student Transcript. This table should contain information linking the student with a course and the grade received.

 

For each table, ensure you have the following in place to receive full credit:

·         Correct primary keys. Some tables will require 2 fields for a primary key.

·         Appropriate and meaningful names for the table and the fields.

·         Database relationships with enforced referential integrity and Cascade Updates turned on

 

Be sure to enter all data into the database before submitting your assignment!

 

 

 

 

 

 

 

 

 

Part E:  Normalization Modifications – 25 points

 

Data File needed for this Problem:

·         Contacts.accdb

·         ContactAddress.xlsx

 

Data Files to Upload to Moodle:

·         Contacts.accdb

 

We are using the database created in example 4 during class. I have provided a copy of this database for you, Contacts.accdb. In this case, the client has decided to add address tracking for each client, so you will need to modify the database to capture this data.

 

Upon studying the PDF file, you see that each contact can have multiple addresses. For this assignment, you will need to add two tables to the database.

 

Your new tables should include the following elements:

 

a) Address Type Table. It should contain, at minimum, the types of Addresses listed in the PDF file.

 

b) Table that relates the Contact with a given address. The data provided in the PDF should be entered into the tables in proper format. Remember that it may be necessary to breakdown the name or fields into multiple columns in your new Access tables. Also, you should track whether this is a mailing address or not.

 

For each table, ensure you have the following in place to receive full credit:

·         Correct primary keys. Some tables will require 2 fields for a primary key.

·         Appropriate and meaningful names for the table and the fields.

·         Database relationships with enforced referential integrity and Cascade Updates turned on

 

Be sure to enter all data into the database before submitting your assignment!

 

 

 

We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we have successfully helped more than 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.

Place Order Now

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational