Launched in 2005 in Boston, Massachusetts, Academic Software has consistently been the fastest-growing education-focused software retailer in North America. It is committed exclusively to academic customers, offering thousands of full-version software titles at great discounts. Academic Software has partnered with the top technology manufacturers, including Adobe, Microsoft, Sibelius, Sony Media Software, and Wacom, to offer excellent service and prices, which are available only to students, schools, and teachers. From the very beginning, Academic Software has relied heavily on technology to ensure a positive shopping experience for its customers. The companys philosophy is simple: Hire amazing people, give them the best tools, and help them deliver an unbeatable customer experience. One facet of Academic Softwares business that needs assistance is its database organization. You have been asked to assist Academic Software with creating a relational database structure for organizing software, vendors, and academic categories. Currently, this information is stored in an Excel spreadsheet, T6_AcademicSoftware_Data.xls, which Academic Software has provided to you.

Specifically, you are asked to:

1. Create a Microsoft Access database.

2. Create the tables, fields, data types, and primary key(s) for the database using the structure provided in the T6_AcademicSoftware_Data.xls file.

3. Create the relationship(s) needed between the tables.

4. Populate the database with the data provided in the T6_AcademicSoftware_Data.xls file.

A. Special notes to use with the 4 questions from the workbook:

1. Three tables will be created for this MS Access database according to the assignment instruction: Categories, Software, and Vendors

2. Use the attached MS Excel file to populate the MS Access database file you will create for this assignment

3. Software ID Use as the primary key for the Software table.

4. Create unique ID field for vendors and academic categories tables, which are to be used as the primary key: Vendors (e.g., Academic Software = AS) and Academic Categories (e.g., Math = MTH).

Academic Software Vendor Address Vendor Vendor Vendor Vendor Phone Software ID Softvare Name Categoy Price Vendor Name City Sta Zip $79.95Learnit Software145 Oak Ave. Wilmington DE 0593 0870 1603 1693 2573 2603 3933 Math Tester Math Easy Calculus Math 19808 302-475-4477 92688 714-336-4785 01013413-572-8292 19808 302-475-4477 92688 714-336-4785 01013 413-572-8292 19111 215-780-3953 01013 413-572-8292 19111215-780-3953 19111215-780-3953 92688 714-336-4785 ton DE19808 302-475-4477 Number Crunch Math hiem Scice1%055 lma Kid-Writer Pendulum Storywriter $49.95 Edusoft Inc Costa Mesa CA i Kin]P.ringgiierkMA 1625 Brook St. C $19.95 Compuschool Co. 9661 King Pl. Springfield MA ington DE 1625 Brook St. Costa Mesa CA $24.95 Compuschool Co 9661 King P. Springfield MA $39.95 Academic Software346 Magee Ave. Philadelphia PA $39.95Compuschool Co. 9661 King Pl. Springfield MA $69.95 Academic Software 346 Magee Ave. Philadelphia PA $24.95 Academic Software 346 Magee Ave.Philadelphia PA 1625 Brook St. Costa Mesa CA $29.95 Learnit Software 145 Oak Ave.Wilm Science $24.95 Edusoft Inc 3963 4353 5820 Writing is Fun English Math Academic Software 346 Magee Ave Edusoft Inc Test Tube Science 5940 Science Quest Science$89.95 5950Easy English English $29.95 Learnit Software 145 Oak Ave. Wilmingt