reate Physical 3NF model computer science homework help

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.

Disclaimer: It is illegal to use the research material ordered on this website for other than research purposes. You must quote the sources appropriately. The company bears no responsibility for the use of research work, not intended for education use, the work is sold as-is with the highest quality and service available and written by freelancers.