SIT772 - Database and Information Retrieval

Added on -2020-02-24

| SIT772| 7 pages| 527 words| 151 views

Trusted by 2+ million users,
1000+ happy students everyday

Showing pages 1 to 3 of 7 pages

Running head: DATABASE MAAGEMENT SYSTEMDatabase Management SystemName of the Student:Name of the University:Author Note
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;
2DATABASE MAAGEMENT SYSTEMselect * from price order by retailer_ID, item_ID;select * from retailer order by retailer_ID;desc item;

Found this document preview useful?

You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss

Premium

$45

Q&A Library Access

Chat support

12

Document Unlocks

4

Answer Unlocks

Students who viewed this