Using the EMPLOYEE table structure shown in the following, submit the final rela

Question

Using the EMPLOYEE table structure shown in the following, submit the final relational schema, dependency diagram and ERD.

Attribute Name

Sample Value

Sample Value

Sample Value

EMP_ID

7369

7499

7521

EMP_NAME

SMITH

ALLEN

WARD

EMP_TITLE

DEVELOPER

DIVISION PRESIDENT

ADMINISTRATOR

PROJ_NAME

FINANCIAL

ACCOUNTING

NETWORKING

DEPT_NAME

RESEARCH

HUMAN RESOURCE

INFORMATION

DIV_NAME

EAST

WEST

GERMANY

Attribute Name

Sample Value

Sample Value

Sample Value

EMP_ID

7369

7499

7521

EMP_NAME

SMITH

ALLEN

WARD

EMP_TITLE

DEVELOPER

DIVISION PRESIDENT

ADMINISTRATOR

PROJ_NAME

FINANCIAL

ACCOUNTING

NETWORKING

DEPT_NAME

RESEARCH

HUMAN RESOURCE

INFORMATION

DIV_NAME

EAST

WEST

GERMANY

Explanation / Answer

struct employee

{

char emp_name[20],emp_title[20],proj_name[20],dept_name[20],div_name[20];

int emp_id;

};

void main()

{

int i,b;

cout<<"enter no of entry;

cin>>b;

employee a[b];

for(i=0;i<b;i++)

{

cout<<"Enter employee ID , name ,title,project name, dept name and division name ";

cin>>a[i].emp_id>>a[i].emp_name>>a[i].emp_title>>a[i].proj_name>>a[i].dept_name>>a[i].div_name;

}

for(i=0 i<b;i++)

{

cout<<" emp_ID"<<a[i].emp_id<<" EMP_NAME "<<a[i].emp_name<<" EMP_title"<<a[i].emp_title<<" Project name "<<a[i].proj_name<<" a[DEPT_NAME "<<a[i].dept_name<<" DIV NAME"<<a[i].div_name;

}

}

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.