SIT772 - Database and Information Retrieval

7 Pages527 Words151 Views

Deakin University

Database and Information Retrieval (SIT772)

Added on 2020-02-24

SIT772 - Database and Information Retrieval

Deakin University

Database and Information Retrieval (SIT772)

Added on 2020-02-24

Related Documents

Running head: DATABASE MAAGEMENT SYSTEMDatabase Management SystemName of the Student:Name of the University:Author Note

SIT772 - Database and Information Retrieval_1

1DATABASE MAAGEMENT SYSTEMAnswer to question number 1The main advantages of using the database over the other file systems in the computerare:It provides a very efficient way of storing the data in the system.This would also help in maintaining the data integrity n the system.This would also provide efficient backup and restore functions for the systems.Answer to question number 2The provided table is Shopping (ItemID, ItemName, ItemYear, ItemPrice, RetailerID,RetailerName)After the normalization functions are performed on the tables the table would be divided intothree different tables.Item (ItemID, ItemName, ItemYear)Price (ItemID, RetailerID ItemName, ItemPrice)Retailer (RetailerID, RetailerName)SET ECHO ON;select * from item order by item_ID;

SIT772 - Database and Information Retrieval_2

2DATABASE MAAGEMENT SYSTEMselect * from price order by retailer_ID, item_ID;select * from retailer order by retailer_ID;desc item;

SIT772 - Database and Information Retrieval_3

End of preview

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