Database Schema and ERD for Item Insurance System
Added on 2019-09-19
11 Pages1263 Words498 Views
|
|
|
Project Plan Maya’s Home Inventory Presented by Maya Rai ITD 256 (E80W) Oct. 20, 2016
1ContentsLogical Model.............................................................................................................................................2Project design and Scope.........................................................................................................................2Introduction:........................................................................................................................................2Purposes of Plan:.................................................................................................................................2Goal and Objective of Plan:.................................................................................................................2List of Entities with attributes..................................................................................................................3ERD.........................................................................................................................................................6Description of ERD.............................................................................................................................7Five Business Rules..................................................................................................................................7Physical Design............................................................................................................................................8All Naming Convention Details................................................................................................................8Database Schema....................................................................................................................................8
2Logical ModelProject design and ScopeIntroduction: I am making aHome Inventory Listto document my home assets forinsurance purposeand tracking my household expenses. My home Inventory project focuses on project’s purposesand objectives. Keeping a Home inventory is very important to us because it helps to takeadvantage of price discounts and to acknowledge the market conditions. Purposes of Plan:Tracking the household expenses.Keep store’s information for returns and other purposes. To obtain and estimate household values for insurance purposes.To keep product information in case of lost or damages. Goal and Objective of Plan:Keeps high levels of data security.Helps to keep reliable sources. Accomplish project business goals and objectives within defined budget and time parameters.Helps to analyze about future market.
3List of Entities with attributesEntity One: (User)User: In this table all authorized person’s login id and password and their type is stored. Theseonly persons can login to system and view the items details or do more processing according totheir right. This feature increases the security of system. Non-authorized person cannot accessthe system information.Attributes of User Entity:1.userLoginID: this id is unique id, every user has its own id to access the system.2.userLoginPassword: this is the login password used by the user to login to system.3.userType: this is the type of user either user is normal or admin. This user type definesthe user privileges over the system.Entity two: (All_Item_Details)All_Item_Details: in this table all type of home items details will store.Attributes:ItemID: this id is unique id. This id will be autoincremented.ItemName: this is the item name.ItemSerialNumber: this is the item serial number which is unique for each item. This serialnumber can be null for some items. Description: this is the description field. In this field we can describe the item details.itemCategory: this field defines in what category item fall like it is vehicle or electronic orfurniture.itemQuantity: this field defines the item quantity, how many number of items of same name andsame type are there?.itemCondition: this defines the item condition like good, bad or average or any otherdescription.
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents