Database Structured English

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 ManagementEntityAttributesRelationship 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)

Custom Papers

We will write a custom paper for you

Free title page

Free reference page

Free formatting

Unlimited revisons