Database System Object Relational Assignment

24 Pages2005 Words143 Views

Added on 2020-07-23

Database System Object Relational Assignment

Added on 2020-07-23

BookmarkRelated Documents

PART 1: OIL AND GREASE LIMITED (OGL) DATABASE SYSTEM

Database System Object Relational Assignment_1

OBJECT-RELATIONAL VERSION OF THE OGL DATABASECREATE OR REPLACE TYPE INDUSTRIALUNIT AS OBJECT (UNITID NUMBER(4),LOCATIONVARCHAR2(50),COUNTRYVARCHAR2(50));CREATE OR REPLACE TYPE PRODUCT AS OBJECT(PRODIDNUMBER(4),DESCPNUMBER(4), STDCOSTPERUNITNUMBER(12,2), STDLABCOSTPERUNITNUMBER(12,2));CREATE OR REPLACE TYPE EMPLOYEE AS OBJECT(EMPIDNUMBER(4), EMPNAMEVARCHAR2(100), YTDEARNINGSVARCHAR2(12), YTDTAXVARCHAR2(4),YTDNICONTVARCHAR2(4), UNITIDNUMBER(4),TAXCODENUMBER(4));CREATE OR REPLACE TYPE WORKORDER AS OBJECT(WORKORDERIDNUMBER(4), QTYNUMBER(4), UNITPRICENUMBER(12,2), ORDERDATEDATE, PROMISEDATEDATE, COMPDATEDATE, SHIPDATEDATE, STATUSVARCHAR2(4),PRODIDNUMBER(4));

Database System Object Relational Assignment_2

CREATE OR REPLACE TYPE LABOURUSAGE AS OBJECT(EMPIDNUMBER(4), WORKORDERIDNUMBER(4), WORKDATEDATE, HOURSNUMBER(2), HOURLYRATENUMBER(4), POSTEDCHAR(1));CREATE TABLE INDUNITPRODUCT (UNITIDINDUSTRIALUNIT,PRODIDPRODUCT);INSERT INTO INDUNITPRODUCT VALUES ( INDUSTRIALUNIT (1, 'NY', 'USA'),PRODUCT ((1, 'IPHONE', '$5000','$4000')); INSERT INTO INDUNITPRODUCT VALUES ( INDUSTRIALUNIT (2, 'NY', 'USA'),PRODUCT ((2, 'TV', '$6000', '$4000')); INSERT INTO INDUNITPRODUCT VALUES ( INDUSTRIALUNIT (3, 'NY', 'USA'),PRODUCT ((3, 'CELL', '$3000', '$2000')); INSERT INTO INDUNITPRODUCT VALUES ( INDUSTRIALUNIT (4, 'NY', 'USA'),PRODUCT ((4, 'DISH', '$1000', '$800')); INSERT INTO INDUNITPRODUCT VALUES ( INDUSTRIALUNIT (5, 'NY', 'USA'),PRODUCT ((5, 'FAN', '$500', '$400'));CREATE INDEX I_UNITID

Database System Object Relational Assignment_3

ON INDUSTRIALUNIT (UNITID);CREATE INDEX I_PRODID ON PRODUCT (PRODID);CREATE INDEX I_EMPID ON EMPLOYEE(EMPID);CREATE INDEX I_WORKORDERID ON WORKORDER(WORKORDERID);

Database System Object Relational Assignment_4

Database System Object Relational Assignment_5

Database System Object Relational Assignment_6

End of preview

Want to access all the pages? Upload your documents or become a member.

Database Implementation Assignment Report

|10

|1642

|12

Logical Database Design for Desklib

|16

|2710

|153

Restaurant Management System Analysis

|15

|1266

|20

Database Management Systems Analysis

|697

|34

Draft SQL Implementation Assignment

|12

|1254

|190

Database System Object Relational Assignment