Learning New Skills - Languages, Oracle Certification, etc

Requirement Specifications for object relational database and SQL-3 as query language
The requirement specification for the store which loans Books, CDs and DVDs. For this purpose the requirements are oracle as an object relational database and SQL-3 as query language. The other requirement is to make this system as a data mart, so the concern is to consider all possible approaches of Object Relational databases to make it as data mart. The main entities and transactions of the system are:
PERSON
This entity contains two sub entities Customer and Employee. The main properties of both are like, Name, Address, Rented Items for customer, over due items, balance amount, likely wise for employees the main properties will be, Name, Address, salary, department.
ITEM
This Entity contains three sub entities, Books, CDs and DVD. The possible attribute for each item will be, Name of the item, quantity, price, type, authors, detail of contents.
LOAN
In this Entity the person and Item entity will be used, so the user can see the record of Customer and particular Item for loan, rent, availability, due date, overdue rent date, customer info etc.
PURCHASE
This Entity will contain the record of Items, which are purchased, and the availability of different Items in Stock.
ACCOUNT
This Entity will contain the rent price, defaulters, and salaries of Employees. It will also contain the information of Person Entity, Purchase and Loans.
Possible Transactions:

Rent Items to the Customers.
Return items in Stock and update items available.
Add new item in stock.
Calculate rent for the rental Items.
List of all rented Items.
List of all over due rented Items.
List of particular customer rented items.
Calculate most rented Item.
List for all rented Items for any particular month.


Advance Feature

As this is a data mart, so the features of object relational databases will be use like triggers, the possible trigger will be, rent the item which is not available or short in stock, so the trigger will generate a massage for upgrading the stock, the other trigger can be defaulter customer, in this trigger after over due date it will give the massage for the particular item, name of the customer. These feature will use in the data mart of the store.

# posted by eCommerce Team @ 12:49 AM