logo

Database Management System Case Study

   

Added on  2021-04-21

25 Pages4957 Words107 Views
Running head: DATABASE MANAGEMENT SYSTEMDatabase Management SystemName of Student-Name of University-Author’s Note-
Database Management System Case Study_1
1DATABASE MANAGEMENT SYSTEMAnswer to Question1Part 1: Based on the case study, the tables can be estimated to solve the problem of SFV are:customer_details, manager_details, item_details, item_update, order_details,discount_detailsPart 2: Tables and attributes of the case study are:Tables Attributes customer_detailscustomer_id,customer_fname,customer_lname, customer_address,address_landmark, customer_pincode,customer_phnum, customer_emailmanager_detailsmanager_id,manager_fname, manager_lname,manager_address, manager_pincode,manager_phnum, manager_emailitem_detailsitem_id,customer_id, item_name, item_pckd,item_cost, item_quantity, item_descitem_updateitem_id, manager_id, update_type,itemu_name, itemu_pckd, itemu_cost,itemu_quantity, itemu_descorder_detailsoder_id, customer_id, item_id, item_name,item_acost, item_fprice, order_place_date,delivery_datediscount_detailsitem_id, item_name, item_acost,discount_price, item_fprice, customer_id,manager_idPart 3: 1st Normalized Form
Database Management System Case Study_2
2DATABASE MANAGEMENT SYSTEMFigure 1: 1st Normalized form
Database Management System Case Study_3
3DATABASE MANAGEMENT SYSTEM
Database Management System Case Study_4
4DATABASE MANAGEMENT SYSTEMFigure 2: 2nd Normalized formFigure 3: 2nd Normalized formAnswer to Question 2Part 1: Primary key and Foreign KeyAttributes underlined and bold is primary key and attributes in italics are foreign keyTables Attributes customer_detailscustomer_id,customer_fname,customer_lname, customer_address,address_landmark, customer_pincode,customer_phnum, customer_emailmanager_detailsmanager_id,manager_fname,
Database Management System Case Study_5
5DATABASE MANAGEMENT SYSTEMmanager_lname, manager_address,manager_pincode, manager_phnum,manager_emailitem_detailsitem_id,customer_id, item_name, item_pckd,item_cost, item_quantity, item_descitem_updateitem_id, manager_id, update_type,itemu_name, itemu_pckd, itemu_cost,itemu_quantity, itemu_descorder_detailsoder_id, customer_id, item_id, item_name,item_acost, item_fprice, order_place_date,delivery_datediscount_detailsitem_id, item_name, item_acost,discount_price, item_fprice, customer_id,manager_idPart 2: SQL statements for each tableTablesSQL Statementscustomer_detailsCREATETABLE [dbo].[customer_details]([customer_id] [int] NULL,[custmer_fname] [varchar](50)NULL,[custmer_lname] [varchar](50)NOTNULL,[customer_address] [varchar](50)NULL,[address_landmark] [varchar](50)NOTNULL,[customer_pincode] [int] NULL,[customer_phnum] [int] NULL,[customer_email] [varchar](50)NULL)ON [PRIMARY]manager_detailsCREATETABLE manager_details( manager_ID INTNOTNULL, manager_fname VARCHAR (20)NOTNULL, manager_lname VARCHAR (20)NOTNULL, manager_address CHAR (25), manager_pincode int, manager_phnum int, manager_email varchar (30),PRIMARYKEY (manager_ID));item_detailsCREATETABLE [dbo].[item_details]([item_id] [int] NULL,
Database Management System Case Study_6

End of preview

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

Related Documents
Coversheet Assignment 2022
|22
|1571
|17

Database Design and Implementation for Fashion Outlet
|33
|5708
|93

Sales And Marketing Management Database System Assignment
|28
|1151
|183

H16W 35 Relational Database Management Systems
|16
|1641
|138

Assessment | Database Modelling (KC7013)
|18
|2655
|30

Advanced Management Console
|35
|7601
|31