logo

ITECH 1006 : The Database Management System Report

21 Pages3550 Words123 Views
   

Federation University of Australia

   

Database Management Systems (ITECH 1006)

   

Added on  2020-05-16

ITECH 1006 : The Database Management System Report

   

Federation University of Australia

   

Database Management Systems (ITECH 1006)

   Added on 2020-05-16

ShareRelated Documents
Running head: THE DATABASE MANAGEMENT SYSTEMThe Database Management SystemName of the StudentName of the University
ITECH 1006 : The Database Management System Report_1
THE DATABASE MANAGEMENT SYSTEM1Table of Contents1. Introduction:................................................................................................................................22. Relational Schema:......................................................................................................................33. Create Query:...............................................................................................................................44. Insert Query:..............................................................................................................................105. DML Query:..............................................................................................................................156. Conclusion:................................................................................................................................18Bibliography:.................................................................................................................................19
ITECH 1006 : The Database Management System Report_2
THE DATABASE MANAGEMENT SYSTEM21. Introduction:The Database Management System is the way of storing, manipulating, deleting andretrieving data to the database. The MySQL database has been used for implementing the ERDinto a database. The report is consists of the relational schema, create queries to create table anddatabase, insert queries to insert data into database and the quires to retrieve various data setform the database based on predefined condition.
ITECH 1006 : The Database Management System Report_3
THE DATABASE MANAGEMENT SYSTEM32. Relational Schema:customerIDCustomerfirstNamelastNamephoneemail addresssuburbpostcodeloyaltyDiscountOrder1customerIDdateOrdereddateFulfilled postageAmountdiscountAppliedOrder_LinequantityamountInventorycategorytitle abstract yearPublished unitPrice inventoryIDBookwholesaler qtyInStock wholesalerID Wholesalername contactName phone email address suburb postcode country comments inventoryID E_BookEBookType categoryID Categoryname description ebookTypeID E_Book_TypefileType description authorID AuthorfirstName surname country bio authorID Written ByinventoryID role Reviewername email avatar customer ReviewinventoryID reviewText reviewDate reviewerID reviewerID inventoryIDorderIDorderIDinventoryID
ITECH 1006 : The Database Management System Report_4
THE DATABASE MANAGEMENT SYSTEM43. Create Query:Create Database bfe_30307885CREATE TABLE CUSTOMER ( customerID int NOT NULL PRIMARY KEY, firstName varchar(40), lastName varchar(40), phone int, email varchar(40), address varchar(40), suburb varchar(40), postcode int, loyaltyDiscount double);CREATE TABLE ORDER1 (orderID int NOT NULL PRIMARY KEY,customerID int,dateOrderedDATE,dateFulfilled DATE,
ITECH 1006 : The Database Management System Report_5
THE DATABASE MANAGEMENT SYSTEM5postageAmount decimal(10,2),discountApplied double,FOREIGN KEY (customerID) REFERENCES CUSTOMER(customerID));CREATE TABLE ORDER_LINE (orderID int NOT NULL, inventoryID int NOT NULL, quantity int,amount decimal(10,2),CONSTRAINT PK_O_LINE PRIMARY KEY (orderID, inventoryID), FOREIGN KEY (orderID) REFERENCES ORDER1 (orderID), FOREIGN KEY (inventoryID) REFERENCES INVENTORY(inventoryID));CREATE TABLE INVENTORY(inventoryID int NOT NULL PRIMARY KEY,category int NOT NULL, title varchar(40),abstract varchar(150),
ITECH 1006 : The Database Management System Report_6

End of preview

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

Related Documents
Database Management System (DMS) Assignment
|5
|531
|198

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

Database Implementation Assignment Report
|10
|1642
|12

ITECH 1006 - Database Management Systems
|14
|4017
|282

Primary and Foreign Key | Exercise Solutions
|8
|1070
|31

Restaurant Management System Analysis
|15
|1266
|20