CONCEPTS OF DATABASE MANAGEMENT
CONCEPTS OF DATABASE MANAGEMENT
9th Edition
ISBN: 9780357323366
Author: Pratt
Publisher: CENGAGE C
Question
Book Icon
Chapter 6, Problem 3SPTC
To determine

(a)

To design a database, using DBDL and ER diagram, for the following user view:

Provide vendorID, name, address, city, state, zip code, telephone number and type of supply for each vendor.

To determine

(b)

To design a database, using DBDL and ER diagram, for the following user view:

For each supply,provide the product number, product name, description, vendor ID, quantity and price.

To determine

(c)

To design a database, using DBDL and ER diagram, for the following user view:

For each order provide the product number, product name, vendorID, quantity, total price, date of order and expected date of arrival.

Blurred answer
Students have asked these similar questions
I need help to resolve or draw the diagrams. thank you
You were requested to design IP addresses for the following network using the addressblock 166.118.10.0/8, connected to Internet with interface 168.118.40.17 served by the serviceprovider with router 168.118.40.1/20.a) Specify an address and net mask for each network and router interface in the table provided. b) Give the routing table at Router 1.c) How will Router 1 route the packets with destinationi) 168.118.10.5ii) 168.118.10.103iii) 168.119.10.31iii) 168.118.10.153
I would like to get help to draw an object relationship diagram for a typical library system.
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage