Ask a question from expert

Ask now

Home Inventory Database | Assignment

9 Pages1147 Words411 Views
   

Added on  2019-09-25

Home Inventory Database | Assignment

   Added on 2019-09-25

BookmarkShareRelated Documents
Northern Virginia Community CollegePHYSICAL AND LOGICALDESIGNA Home Inventory Database0 | P a g ePRABHAT CHAUDHARYITD256 E70W
Home Inventory Database | Assignment_1
ContentsLOGICAL DESIGN..............................................................................................................................2PROPOSED DESIGN.......................................................................................................................2ENTITIES AND ATTRIBUTES.......................................................................................................2DESIGN............................................................................................................................................3DETAILED ERD..............................................................................................................................5RELATIONSHIPS............................................................................................................................6BUSINESS RULES...........................................................................................................................6PHYSICAL DESIGN............................................................................................................................6NAMING CONVENTIONS..............................................................................................................6SCHEMA..........................................................................................................................................71 | P a g e
Home Inventory Database | Assignment_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
Home Inventory Database | Assignment_3

End of preview

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

Related Documents
A Study on Functional Dependency and Relational Schema
|7
|557
|237

Database Development Management
|7
|917
|144

Database Systems for Toulis Construction: Diagrams, SQL Queries, Security Measures and Future Improvements
|23
|2197
|298

Making a Home Inventory List
|11
|1288
|428

ITD 256 Advanced Database Management Assignment
|11
|1263
|498

Assignment : Database Management System ITECH 1006
|10
|612
|137