Create Physical 3NF model
XVS Pharmacy has provided you with a spreadsheet that contains the file layout of all the attributes. It also contains the business rules that you need to use when building your 3NF physical model. Your assignment is to transform this spreadsheet layout (using the business rules) into a 3NF physical model. The spreadsheet is located in the documents folder above. The spreadsheet is called File Layout XVS Pharmacy.
Make sure yourphysical model uses Crow’s Feet Notation. Also you shouldhave all your attributes for each entity clearly labeled and include a PK for each table. I also want to see all appropriate FKs for each entity.
Data Types are not critical within your model.