ITD 256 Advanced Database Management Assignment

11 Pages1263 Words498 Views

Advanced Database Management (ITD 256)

Added on 2019-09-19

ITD 256 Advanced Database Management Assignment

Advanced Database Management (ITD 256)

Added on 2019-09-19

BookmarkRelated Documents

Project Plan Maya’s Home Inventory Presented by Maya Rai ITD 256 (E80W) Oct. 20, 2016

ITD 256 Advanced Database Management Assignment_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

ITD 256 Advanced Database Management Assignment_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.

ITD 256 Advanced Database Management Assignment_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 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.

ITD 256 Advanced Database Management Assignment_4

End of preview

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

Making a Home Inventory List

|11

|1288

|428

Home Inventory Database | Assignment

|1147

|411

Web Development Assignment | Mobile Web Application

|1646

|583

Algorithms for the Inventory Management System

|11

|2691

|13

Home Inventory Database: Software Tool Description, SQL Section, Security Measures, Testing and Validation Strategies

|800

|134

Product Maintenance Application system documentation Project 2022

|11

|2243

|22

ITD 256 Advanced Database Management Assignment