Please only do the VISIO drawing for the Macy's Database. I dont need an access database.

Directions: The first thing you need to do is do the ACCESS tutorial. In the tutorial, you will create a very simple database for Lawyers. It is only two tables; the Lawyer Table and the Client Table. One lawyer can have many clients and one client can only have one lawyer. Populate each table. Make sure that each lawyer has more than one client. Be sure that you add yourself to the database either as a lawyer or as a client. 1. 2. Using VISIO, create the ERD for the Macy's database The ERD exercise for this lab is similar to the sample ERD exercise presented above. On the next page is a partial spreadsheet for Macy's It is not normalized data. That means that there is a lot of data redundancy. Your job is to create an ERD for the database. You must put it in first, second, and third normal forms. Normalizing a table can be easily done by first finding the entities and then putting attributes ithin each entity that describe that entity The solution will have four tables. The table relationships will all be one to many relationships. Your job is to find the tables (entities) and figure out the relationships that they may have with each other Find the entities and their relationships from it. First, find the entities. The entities are decomposable nouns or what is also called Non- atomic nouns. The Non-atomic nouns can be broken down into nouns that are atomic. The atomic nouns will be attributes in the entities. So, find those Non-atomic nouns first. You will find the entity names in the columns below. One entity is STORE because it is a noun and it is NOT ATOMIC. It can be broken down into several atomic nouns like store address and store phone number. It has several attributes as you can see below Next find the primary key column for each entity. A primary key candidate is a column or columns that must have unique values for each row. In this exercise, the entities' primary keys are all just one column. Then, find the attributes that belong to each entity. Each entity has a theme. That means that the attributes must describe the entity or in other words its theme. An attribute must be dependent on the primary key attribute of that entity. For instance, an employee will have his own unique employee ID Primary Key. After you do that, then find the relationships. For instance, a region can have many stores. A store can have many employees. Then add the foreign keys to the proper entities. 3. Test your ERD out by creating the Macy's database using ACCESS. Populate your tables with the data you see below. But also add your name to the database as an employee in one of the stores. You pick the store. Make sure you have created the relationships with the proper foreign keys and make sure you check "Enforce Referential Integrity" check box when creating your relationship lines. CIS336 Week 1 Lab Page 3 Employee Last Name Employee First Store Address Store Phone Store Code Job Code Description Job Base Pay Store YTD Sales NorthWest 123 Main NorthWest 123 Main NorthWest 123 Main 813-343-3333 813-343-3333 813-343-3333 100 Jones 100 SalesPerson J101 Clerk J102 Manager 1,000,000 william 100 Wilson NorthWest 200 Elk Ave NorthWest 200 Elk Ave 813-679-1234 101 Carter 813-679-1234 100 Salesperson 1,200,000 NorthWest S00 Low St NorthWest 500 Low St. NorthWest 500 Low St. 87-487-4534 687-487-4534 687-487-4534 234 Jamison 234 Clover 234 DeLuca 100 SalesPerson J101 Clerk 800 3rd St NorthEast 800 3rd St NorthEast 800 3rd St. 345-564-7867 345-564-787 345-564-7867 897 Thompson Bruce 897 100 SalesPerson 2,000,000 101 Clerk Manager SouthEast SouthEast SouthEast 1Superior Lane 1 Superior Lane 1Superior Lane 675-688-3457 675-688-3457 675-688-3457 600 Hamilton Mary 600 Stanford Grace 600 Thompson Bruce 692 J100 SalesPerson 1101 Clerk J102 Manager 150,000 150,000 SE SE 923 SouthWest SouthWest SouthWest 100 Rt 4 345 Lotus St. 5178 Randolf Ave. 286-456-3879 286-456-7945 286-456-7812 2,450,000 2,450,000 300 Roberts 678 J100 SalesPerson J101 Clerk 301 Williams Taylor James 167 SouthWest 300 High St SouthWest 300 High St. SouthWest 300 High St 378-341-5679 378-341-5679 378-341-5679 678 Jones William J100 SalesPerson 101 Clerk 102 Manager 1,600,000 678 Randolf Alex 1,600,000 SouthWest 1000 Verdugo SouthWest 1000 Verdugo SouthWest 1000 VerdugO 555-567-5781 555 567-5781 555-567-5781 650 650 Smith 650 Barnes Margaret 566 J100 SalesPerson Terry 900 Deliverables: You must do number 1 OR number 3 below or both. Everyone must do number 2 below. Put it all in a zipped folder with the filename: YourLastName CIS336.Week1 Do the ACCESS tutorial creating the Lawyer Database. Submit your ACCESS database. Be sure each table is populated Using VISIO, draw the ERD for Macy's, using Crow's Foot notation using VISIO. Copy and Paste your ERD to an empty Word Document for your submission Create the database using ACCESS. Submit your ACCESS database. Be sure each table is populated with the above data 1. 2. 3. CIS336 Week 1 Lab