logo

Design and Implementation of a Database for Warranty and Insurance Management

   

Added on  2019-09-25

9 Pages1147 Words411 Views
 | 
 | 
 | 
Northern Virginia Community CollegePHYSICAL AND LOGICALDESIGNA Home Inventory Database0 | P a g ePRABHAT CHAUDHARYITD256 E70W
Design and Implementation of a Database for Warranty and Insurance Management_1

ContentsLOGICAL DESIGN..............................................................................................................................2PROPOSED DESIGN.......................................................................................................................2ENTITIES AND ATTRIBUTES.......................................................................................................2DESIGN............................................................................................................................................3DETAILED ERD..............................................................................................................................5RELATIONSHIPS............................................................................................................................6BUSINESS RULES...........................................................................................................................6PHYSICAL DESIGN............................................................................................................................6NAMING CONVENTIONS..............................................................................................................6SCHEMA..........................................................................................................................................71 | P a g e
Design and Implementation of a Database for Warranty and Insurance Management_2

LOGICAL DESIGNPROPOSED DESIGNThe ‘home inventory database’ logical design will contain different entities to store the information 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 a need to buy new things, so we will have tables to store the list as well as purchases of what has been purchased their cost, location information etc. Also each entity will have some varied and additional attributes including the basic attributes that were defined the previous phase. This has been done in order to meet the hidden 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 be associated according to the previous requirements yet adding the new fields to them. The plan 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 as per 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
Design and Implementation of a Database for Warranty and Insurance Management_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents