Database Reference
In-Depth Information
3b.
ITC Software Inc. is developing a database system for one
of its clients, X-Don Inc., based in Miami, Florida. X-Don
has experienced Windows users. They use the Oracle
RDBMS. Additionally, X-Don has very experienced Oracle
Programmers. However, it is strategically imprudent for ITC
Software to design and develop the database in Oracle or
on the Windows platform. They prefer to work on the Linux
platform, using a product called Kylix and PHP. To complicate
matters, ITC Software operates out of Port of Spain, Trinidad.
ITC Software therefore desires to access the X-Don's database,
hosted in Miami, via telecommunication linkage. Is the
project feasible? Using block diagram, explain how the
project could be implemented.
{08}
3c.
Briefly explain the following: Data Definition Language (DDL);
Data Manipulation Language (DML); Data sub-language
(DSL); Structured Query Language (SQL)
{08}
4.
Developing an inventory management system is standard in most
organizations. The main entities to be identified are Purchase
Orders, Receipts (of goods), Inventory (Items), Inventory
Categories, Inventory Requisitions, Departments, Inventory
Issues. Next, we identify relationships among the entities:
•
Departments make requisitions for inventory items;
•
Issues of inventory are made to departments in response to
requisitions;
•
Purchase orders are made to suppliers for inventory items;
•
Goods received are normally accompanied by an invoice,
specifying the items and cost (of course, invoices come from
suppliers);
•
Each inventory item is assigned a category.
4a.
From the information given, draw an ERD for the
inventory management system described.
{10}
4b.
For each relationship, state whether mandatory or
optional; 1:1 or 1:M or M:M or M:1.
{10}
5a.
Write brief notes on five of the terms in following list
(Figure
26-6
):
{10}
Figure 26-6.
Basic Terms Used in the Relational Model