Ask a question from expert

Ask now

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

BookmarkShareRelated 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.