ODBMS Assignment Help | Project | Homework Problem Solution

ODBMS is data base management system around the object and we show the devotion to ODBMS assignment help in DatabaseHomeworkHelp. We gathered every solution in ODBMS to bring you the best ODBMS homework help. As an unfortunate student you do not have to worry any more for help with ODBMS assignment.  We can bring fortunate results for you via our help with ODBMS project.

Online answers for ODBMS are not enough to get ODBMS problem. Right way is to get our ODBMS project help. We felt the need of teaching to students other than helping in homework thus we exert our ODBMS online expert tutor service for this. Readymade help is not enough for you to get desired results than get our ODBMS assignment help, as we got the years of experience in this sector.

We got favorable opinions of all those who got our ODBMS homework help. Our efforts are not ending at the vision of creating a data base learning in students we actually make it happen through help with ODBMS assignment. Positive see the world with aim of delivering help with ODBMS project and we give our full attention in this vision. In case you also feel need of ODBMS problem solution email on our website. We are the only experts with proven good record to give you ODBMS project help.

Object oriented database supports the modeling and creation of data as objects. It support for classes of objects and the inheritance of class properties. It satisfies only two criteria i.e. it should be database and it should be object oriented system. It should also translate into five features i.e. secondary storage management, persistence, concurrency, recovery, and ad hoc query and next is to translate into eight features like complexity of the objects, identity of object, data encapsulation, types or classes, inheritance, extensibility, overriding with late binding and computational completeness.

Note:- The below sample assignment is possesses by databasehomeworkhelp group. The homework solution gives you the flavor on how we provide assignment solution to the students.  Please do note that the below solution is only example and not the solved assignment that we have provided to our previous students. We always maintain privacy, quality check and correctness of our homework before it is delivered to the students.

Task: The database system is based on object relational database.  The database does not use the inheritance in the design, so for the books we can use the inheritance for different book types. Provide the trigger, codes, and explain the report information in detail.
Solution:- Design and Analysis:

  • Book category will keep record of book category like Novel, poetry etc.
  • Book type will keep track of different books type like type name, addr
  • Book entity will keep track of books like name, author, number of pages etc
  • Order will keep track of order date, order item
  • Order line will keep track of book name, book price etc

Design & Implementation of object-relational database
Following are the design and implementation of the book shop.

CREATE TYPE BookCategory AS (

name   CHAR(50),

addr     CHAR(20)

);

CREATE TYPE Book-Type AS (

name   CHAR(50),

manf    CHAR(20)

);

CREATE TABLE Books OF BookCategory {

PRIMARY KEY (name)};

CREATE TABLE BooksType OF Booktype {

PRIMARY KEY (name)};

CREATE TYPE AddrType AS (

Strt      CHAR(30),

City                  CHAR(20),

Zip                   INT

)

CREATE TABLE Customer (

Name  CHAR(30),

Address           AddrType,

Fav_Book       BookType

);

CREATE TYPE MenuType AS OBJECT (

BookCat                      REF BookCategory,

BookType       REF  BookType,

Price    FLOAT,

MEMBER FUNCTION  BookPrice(FLOAT)             RETURN FLOAT,

PRAGMA RESTRICT_REFERENCES(USD_Price, WNDS)

);

CREATE TYPE BarType AS OBJECT (

name   CHAR(20),

addr     CHAR(20),

ORDER MEMBER FUNCTION before(

bar2 IN BarType) RETURN INT,

PRAGMA RESTRICT_REFERENCES(before,

WNDS, RNDS, WNPS, RNPS)

);

CREATE TYPE BookCat AS OBJECT (

Mame  CHAR(20),

Address           AddrType,

ORDER MEMBER FUNCTION before(

Book2 IN BookCategory) RETURN INT,

PRAGMA RESTRICT_REFERENCES(before,

WNDS, RNDS, WNPS, RNPS)

);

CREATE TYPE Book AS OBJECT (

Name  CHAR(20),

No_Pages INT,

Price  Decimal,

Author      Char(20)

);

Create triggers:

CREATE OR REPLACE TRIGGER SECURE_Order

BEFORE INSERT ON Order

BEGIN

IF

(TO_CHAR (SYSDATE, ‘DY’) IN (‘SAT’,’SUN’)

THEN

RAISE_APPLICATION_ERROR(–20500, ‘YOU CAN ONLY

INSERT DATA INTO ORDER DURING WORKING DAYS’);

END IF;

END;

 

CREATE OR REPLACE TRIGGER SECURE_BOOKS

BEFORE INSERT OR UPDATE OR DELETE ON BOOKS

BEGIN

IF (TO_CHAR (SYSDATE, ‘DY’) IN (‘SAT’,’SUN’)) OR

(TO_CHAR (SYSDATE, ‘HH24′) NOT BETWEEN ’06’ AND 05)

THEN

IF DELETING THEN

RAISE_APPLICATION_ERROR(–20501, ‘YOU CAN DELETE IN OFFICE HOURS ONLY’);

END IF;

END;

Report and evaluation Report:

There is only one nested table is used (Book). So we can use more nested table to enhance the reusability. The object relational database management system contains all the features of the object database as well as the features of the relational database.

The system contains the basic tables for books, book type, book categories and customer information. The customer purchases the books and the information related to order and order details are stored in different tables. The triggers are used to enhance the data security and system reliability. The two triggers avoid the unauthorized usage of system. In the future the more objects can be added and some data types like author data type can be added for the book table.More triggers can be implemented on the system to support the validity of the data. Role base triggers can be added to support the system more efficiently.

REF data type should be used to refer the foreign key in the system. The VARRAY should be used as collection of different objects. If we add all these features to the existing database system, then it can be more efficient and reliable.