Answered You can hire a professional tutor to get the answer.

QUESTION

Entity Attributes Relationship to other Entity* 1 . EMPLOYEE ( superclass ) - name ( overlap parent / child -( subclass ) SALES - San / primary...

What are the specifications for this database Structured English:

-relationships concerning the disjoint relationship (project(superclass), future acquisitions, product)

-relationship connecting Project to Employee

-relationship connecting Project to Management

EntityAttributesRelationship to other Entity*1 . EMPLOYEE ( superclass )- name( overlap parent / child-( subclass ) SALES- San / primaryrelationship )- ( subclass ) PUBLICKey )EMPLOYEE -- SALESMANAGEMENT ( supervise N : 1 ,RELATIONSemployee must have a manager )- sales ranking- commissionrate- PR- social media- marketingadvertisement2 .- name( disjoint parent / childMANAGEMENT ( superclass )- Sun ( primaryrelationship )key )EMPLOYEE -- positionMANAGEMENT ( supervise N : 1 ,manager may have one or moreemployees )3. SHARE- nameMANAGEMENT & SHAREHOLDERHOLDER ( superclass )-san ( primaryunion to make EXECUTIVEKey )BOARD- share2 - 3 2 . EXECUTIVE- corporate No .Subclass for unionBOARD ( weak entity / union )( partial key )-head4. PROJECT- name( disjoint parent / child-( subclass )relationship )PRODUCTnumber ( primaryPROJECT - MANAGEMENT ( 1 : 1)- ( subclass ) FUTUREKey )PROJECT - EMPLOYEE ( M : N )-PRODUCTACQUISITIONS- id number- tech type- FUTUREACQUISITIONS- long term- short term5. BUILDING- building No .PROJECT - BUILDING ( 1: N )- address( primary key)
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question