SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 337 Weeks Ago, 4 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 16 Dec 2017 My Price 10.00

Identify all relationships and specify cardinality

Study the ERD and answer the following questions:

  1. Identify all relationships and specify cardinality and business rules. For example: 1:M between Customer and Orders: a customer can place many orders; an order will be placed by one and only one customer.

 

1:M between Customer and Orders: a customer can place many orders; an order will be placed by one and only one customer.

 

 

and what am i doing wrong ; getting table does not exist error

 

CREATE TABLE CUSTOMER (

   CUSTNO VARCHAR2(8) PRIMARY KEY,

   CUSTFIRSTNAME VARCHAR2(20) NOT NULL,

   CUSTLASTNAME VARCHAR2(30) NOT NULL,

   CUSTSTREET VARCHAR2(50),

   CUSTCITY VARCHAR2(30),

   CUSTSTATE VARCHAR2(2),

   CUSTZIP VARCHAR2(10),

   CUSTBAL NUMBER(12,2)

);

CREATE TABLE ORDERS(

  ORDNO VARCHAR2(8) PRIMARY KEY,

  ORDDATE DATE NOT NULL,

  CUSTNO VARCHAR2(8) NOT NULL,

  EMPNO VARCHAR2(8),

  ORDNAME VARCHAR2(50),

  ORDSTREET VARCHAR2(50),

  ORDCITY VARCHAR2(30),

  ORDSTATE VARCHAR2(2),

  ORDZIP VARCHAR2(10),

  CONSTRAINT FK_CUSTNO FOREIGN KEY (CUSTNO) REFERENCES CUSTOMER(CUSTNO),

  CONSTRAINT FK_EMPNO FOREIGN KEY (EMPNO) REFERENCES EMPLOYEE(EMPNO)

);

CREATE TABLE EMPLOYEE (

   EMPNO VARCHAR2(8) PRIMARY KEY,

   EMPFIRSTNAME VARCHAR2(20) NOT NULL,

   EMPLASTNAME VARCHAR2(30) NOT NULL,

   EMPPHONE VARCHAR2(15),

   EMPEMAIL VARCHAR2(50) NOT NULL UNIQUE, 

   SUPEMPNO VARCHAR2(8),

   EMPCOMMRATE NUMBER(3,3),

   CONSTRAINT UK_EMPEMAIL UNIQUE (EMPEMAIL),

   CONSTRAINT FK_SUPEMPNO FOREIGN KEY (SUPEMPNO) REFERENCES EMPLOYEE(SUPEMPNO)

);

CREATE TABLE PRODUCT (

   PRODNO VARCHAR2(8) PRIMARY KEY,

   PRODNAME VARCHAR2(50) NOT NULL,

   PRODMFG VARCHAR2(20) NOT NULL,

   PRODQOH NUMBER(*,0),

   PRODPRICE NUMBER(12,2)

   PRODNEXTSHIPDATE DATE,

);

CREATE TABLE ORDER_LINE (

   ORDNO VARCHAR2(8) PRIMARY KEY,

   PRODNO VARCHAR2(8),

   QTY NUMBER(*,0),

   CONSTRAINT FK_ORDNO FOREIGN KEY (ORDNO) REFERENCES ORDERS(ORDNO),

   CONSTRAINT FK_PRODNO FOREIGN KEY (PRODNO) REFERENCES PRODUCT(PRODNO)

);

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 16 Dec 2017 12:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)