Assignment: Databases Vs. Spreadsheets/Relationships
Discuss the differences between storing data in a spreadsheet verses storing data in a database.
• In what business scenarios might one approach be superior to the other?
• What are the pros and cons of each approach?
• Why do you think many businesses today use both spreadsheets and databases to manage their data?
OR
Share at least one real-world example of the following types of data relationships:
• 1:1
• 1:M
• M:N (many-to-many)
Your example can be from work, school, a hobby, or daily life.
Discuss why you think making the distinction between these types of relationships is important for database designers. How does each of these types of relationships affect the complexity of storing and retrieving data? How do database architects apply the concepts of primary and foreign keys to each type of data relationship?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.