Please show me how you did?

Thanks

This assignment consists of two parts. Both parts should be implemented

in the same MS Access Database.

PART 1

Using MS Access:

1. Import data from the attached AcademicSoftware_Data Excel file into a new database as

following:

Table/Entity Name: AcademicSoftware

Attributes:

a. Software ID (Integer, Primary Key)

b. Software Name (Short Text)

c. Software Category (Short Text)

d. Software Price (Currency)

e. Vendor Name (Short Text)

f. Vendor Address (Short Text)

g. Vendor City (Short Text)

h. Vendor State (Short Text)

i. Vendor Zip (Short Text)

j. Vendor Phone (Short Text)

Note: Check the imported table and make sure to delete any unwanted fields (e.g. as Field1 or

FLD11 etc.) that might have been imported.

When you import data, sometimes the source data isnt properly split out into related tables.

To get the most benefit from Access, data needs to be normalized, i.e. separated into different

Tables/Entities, each about one thing, that are related by key pieces of information.

2. Use the Table Analyzer to normalize this imported AcademicSoftware Table as following:

Split the existing AcademicSoftware Table appropriately into the following 3 Entities with

proper relationships defined.

1. Software

2. Vendors

3. Categories

George Mason University, School of Business, MIS303-12 Fall2018 - Dr. Gohar Mukhtar Page 2

Note: Make sure to delete any unwanted entities from the ERD page.

3. Create a query named Affordable Software which shows Software Name, Vendor Name,

Software Price, and Tax (in that order) where the Software Price is $25 or less.

The Tax is to be calculated as 4.5% of the Software Price. Should be formatted with a

currency sign and should carry two decimal places only.

4. Create another query named Avg Price by Category which should only list Software

Categories and their average Software Prices.

Academic software data below:

Software ID	Software Name	Software Category	Software Price	Vendor Name	Vendor Address	Vendor City	Vendor State	Vendor Zip	Vendor Phone
593	Easy Calculus	Math	$79.95	Learnit Software	145 Oak Ave.	Wilmington	DE	19808	302-475-4477
870	Number Crunch	Math	$49.95	Edusoft Inc.	1625 Brook St.	Costa Mesa	CA	92688	714-336-4785
1673	Chem Works	Science	$19.95	Compuschool Co.	9661 King Pl.	Springfield	MA	01013	413-572-8292
1693	Kid-Writer	English	$29.95	Learnit Software	145 Oak Ave.	Wilmington	DE	19808	302-475-4477
2573	Pendulum	Science	$24.95	Edusoft Inc.	1625 Brook St.	Costa Mesa	CA	92688	714-336-4785
2603	Storywriter	English	$24.95	Compuschool Co.	9661 King Pl.	Springfield	MA	01013	413-572-8292
3933	Math Tester	Math	$39.95	Academic Software	346 Magee Ave.	Philadelphia	PA	19111	215-780-3953
3963	Writing is Fun	English	$39.95	Compuschool Co.	9661 King Pl.	Springfield	MA	01013	413-572-8292
4353	Rhythmetic	Math	$69.95	Academic Software	346 Magee Ave.	Philadelphia	PA	19111	215-780-3953
5820	Test Tube	Science	$24.95	Academic Software	346 Magee Ave.	Philadelphia	PA	19111	215-780-3953
5940	Science Quest	Science	$89.95	Edusoft Inc.	1625 Brook St.	Costa Mesa	CA	92688	714-336-4785
5950	Easy English	English	$25.00	Learnit Software	145 Oak Ave.	Wilmington	DE	19808	302-475-4477