logo

Making a Home Inventory List

11 Pages1288 Words428 Views
   

Added on  2019-09-16

Making a Home Inventory List

   Added on 2019-09-16

ShareRelated Documents
Running Head: MAYA HOME INVENTORY[ MAYA HOME INVENTORY ]Project PlanStudent Name: MayaStudent ID: Course Name: ITD 256 (E80W)Course ID:Faculty Name: University Name: Date: Oct. 20, 2016
Making a Home Inventory List_1
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
Making a Home Inventory List_2
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.
Making a Home Inventory List_3
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 access thesystem 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 otherdescriptioin.itemConditionDescription: this is the additional field to describe item condition in better ordescriptive way.
Making a Home Inventory List_4

End of preview

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

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

Requirement Analysis and Modelling Case Study 2022
|10
|1526
|8

Home Inventory Database | Assignment
|9
|1147
|411

Web Development Assignment | Mobile Web Application
|5
|1646
|583

Algorithms for the Inventory Management System
|11
|2691
|13

System Analysis
|8
|876
|42