I have homework I need every Q one Paragraph

User Generated

f_n989

Programming

Description

Q1 A friend shows you his awesome spreadsheet (his words) he uses to track customers for his small business. His spreadsheet shows his customers information, their orders, and other pertinent information. You, after being empowered by this class, notice multiple issues with his spreadsheet. Further, you know this spreadsheet, while "awesome," is a terrible idea for a small business What would you say to your friend to convince him to use a relational database for his small business? Give him some examples of how his "awesome" spreadsheet could cause trouble for his business in the future

Q2 what is Normalization ?

Q3 Explain the concept of a foreign key ?

Q4 see the


Unformatted Attachment Preview

nts Started: Oct 10 at 5:42pm Quiz Instructions D Question 12 C 5 pts Is the following table a relation? If not, please describe what is preventing it from being a relation. Time El Attempt 4 Hours H. ... Name Phone Phone State JOHN 7035551231 7329783244 MD City Eldersburg Primary keyi 1. 703556039 JIM 703555232 7032223232 VA 2 JON 4105551212 4102221212 FL JOHN Eldersburg Eldersburg Eldersburg Eldersburg 7021212121 2321111212 VA 4! JOHN 7035551231 7329783244 MD 1: an od Maak B I y A- A - IX E FE x x = = D? VAST T T12pt Paragraph urces 33
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey I am through. The attached word file has all the correct answers to the questions

Q1.
One advantage of the relational database is avoidance of duplication. The records are therefore
stored once. When data is usually stored in a relational database, there are no multiple record
changes needed, and there is more efficient storage of data. There is also ease of data retrieval
from the relational database when compared to the file system. When the table JOINS are used,
relevant data from the tables is displayed, and the results can be filtered using any criteria defined
by the use. The disk space needed to ma...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags