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
Purchase answer to see full attachment
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...