Home Inventory Database | Assignment

Added on - 25 Sep 2019

  • 9

    pages

  • 1147

    words

  • 57

    views

  • 0

    downloads

Showing pages 3 of 9
Northern Virginia Community CollegePHYSICAL AND LOGICALDESIGNA Home Inventory Database0|P a g ePRABHAT CHAUDHARYITD256 E70W
ContentsLOGICAL DESIGN..............................................................................................................................2PROPOSED DESIGN.......................................................................................................................2ENTITIES AND ATTRIBUTES.......................................................................................................2DESIGN............................................................................................................................................3DETAILED ERD..............................................................................................................................5RELATIONSHIPS............................................................................................................................6BUSINESS RULES...........................................................................................................................6PHYSICAL DESIGN............................................................................................................................6NAMING CONVENTIONS..............................................................................................................6SCHEMA..........................................................................................................................................71|P a g e
LOGICAL DESIGNPROPOSED DESIGNThe ‘home inventory database’ logical design will contain different entities to store theinformation for each of the following things:1.Products or goods2.Insurance information3.Warranty information4.Location information.Since home inventory is something which keeps on growing with time and there arises aneed to buy new things, so we will have tables to store the list as well as purchases ofwhat has been purchased their cost, location information etc.Also each entity will have some varied and additional attributes including the basicattributes that were defined the previous phase. This has been done in order to meet thehidden requirements that may arise in future. Apart from this, it will help in managing thedata more precisely. The data will atomic and each row will have a unique information.So accordingly the keys will also be designed in the logical phase. All the entities will beassociated according to the previous requirements yet adding the new fields to them. Theplan below has entire logical design for the home inventory database’.ENTITIES AND ATTRIBUTESThe entities and attributes that will be present in the database to meet all the requirements asper the proposed design are as follows:ENTITYATTRIBUTESGOODSThis entity will store general information aboutthe goodsPROD_ID (PRIMARY KEY)PROD_NAMEPURCHASE_DATELOCATION_IDCOSTPRODUCT_INSURANCEINSURANCE_ID (PRIMARY KEY)INSURANCE_STATUS2|P a g e