Dr Nick

(4)

$14/per page/Negotiable

About Dr Nick

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

Expertise:
Art & Design,Computer Science See all
Art & Design,Computer Science,Engineering,Information Systems,Programming Hide all
Teaching Since: May 2017
Last Sign in: 340 Weeks Ago
Questions Answered: 19234
Tutorials Posted: 19224

Education

  • MBA (IT), PHD
    Kaplan University
    Apr-2009 - Mar-2014

Experience

  • Professor
    University of Santo Tomas
    Aug-2006 - Present

Category > Programming Posted 02 Aug 2017 My Price 14.00

Entity-relationship diagram

A retail chain owns several stores. Each store, depending on its sizeand the range of products it stocks, is designated as being either a regionalor a local store. Each employee works at a single store. Some employees maymanage a store.

 

20130520042746entity.jpg

Please see attached

Entity types

Employee (EmployeeNo, Name)

Store (StoreCode, Type)

Product (ProductCode, Description,Cost)

Additional constraints

c.1The EmployeeNo attribute of Employee takes a character string value in therange 00000 to 99999.

c.2The StoreCode attribute of Store takes a character string value in the range 00000 to 99999.

c.3The Type attribute of Store takes a value of either regional or local store.

c.4The ProductCode attribute of Product takes a character string value in therange 00000 to 99999. (a) Give the SQL required tocreate a database that represents the E–R data model for the retail chain givenin Figure 1.

In your database definition, you should use:

the‘posted foreign key’ approach to implement the WorksAt and Managesrelationships;

SQLdomains to implement the additional constraints.

(b) Give the SQLrequired to modify the database definition you gave as your solution to part(a) to include CHECK constraints thatrepresent the following additional constraints:

Additional constraints

c.5 The managerof a store (represented by an occurrence of the Manages relationship) works atthe same store (represented by an occurrence of the WorksAt relationship).

c.6 Regionalstores must stock all of the products.

Answers

Dr Nick
(4)
Status NEW Posted 02 Aug 2017 01:08 PM My Price 14.00

----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------amÂ----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill-----------

Not Rated(0)
Relevent Questions