O AutoSave File Home Insert X Cabrillody 8 . Design - 12 ISM Layout Draw References Run Videkatchew - Mailings Review View Help A Styles Editing Dictate - A 2-A Aa A A - 41 Page ISM 360 Assignment 5: Databases and Data Management The rapid increase in the creation of business data has led us to the "Big Data" era, where there is a vast amount of data around us, sometimes more than we could effectively processor understand. Therefore, how to better organize those data for later analysis is of critical importance to modern businesses. Chapter 5 talks about data management and databases. In this assignment, you will need to answer several questions related to this topic. Please type in your answer under each question below. Once you are done, save and rename the file following the naming convention of Your LastName-Your FirstName-AS.docx, and submit it to Bblearn. Q1. To design tables in a database, one very important task is to decide both the primary keyls) and foreign key(s) for those tables. The following picture shows a database with 4 tables. Please identify and list clearly the primary key(s) and foreign key(s) - if any - for each of the 4 tables. Sales Table Transaction Date 567 5679 1240 1/24/09 124/09 567 3728 188 722 37622 37822 Employees Table Employees rame phen 3453 one Sue SO222- 97 Smith, Sam 644-3822 Customers Table name age 1 of 4 491 words English (United States) Focus B E x Ruth Vidnekatchew B Mailings Review A o Help AutoSave ON A 12 M. File Home insert Draw Design Layout References A X Calibri (Body) - 12 - E E BTX, XA ESTE Paste - A 2-A - A A A - 1 Clipboard Paragraph View Styles Editing Dictate Styles Sales Table Trond Dutem 24/09 4567 37822 Employee 2451 2451 5679112409 12 Employees Table Employee Sedele Jones, Sue 2452 SC -2889 850 222 Customers Table Customer name on 37821 X Son OSO 668-1827 37822 Hardt, on 0222-420 37823 Carr Walt (SO222B Inventory Table Name Price Supplier 50" HD-TV 1200-99 Sony RGB Cable 26.50 HD Antenne 79.00 Main 25 Gide S South St Item A llah 3728 The "Sales Table" Primary key(s): O X Acrobave 2 8 File Home insert Draw Design Calibri (Body 12 I BIUX, * A - A 2-A - A A A SM. Ridekatchew - Layout References Mailings Review View Help - 13 A S ESTE Styles Editing Dictate - 21 - Foreign key(s): The "Employees Table" Primary key(s): Foreign key(s): The "Customers Table" Primary key(s): Foreign key(s): The Inventory Table" Primary key(s): Foreign key(s): Q2. Once a database has been created, being able to get the information you need from it is a Page 2 of 4 491 words D English (United States) Focus U 18