Consider entity type Employee with attributes empNumber (this is unique), empName, and the year when he/she was hired. An employee can either be a technical employee, a marketing employee, or a business executive. For a technical employee, we know his/her undergraduate degree major. For a marketing employee, we know the revenue generated by this employee to date. For a business executive, we know the number of years of experience.

Model the above using ER, translate the ER schema to SQL DDL. Include the ER schema, the SQL statements and appropriate screen shots showing that your CREATE TABLE statements succeeded into your submission document.

Posted Date: 3/20/2013 1:57:29 AM | Location : United States

Ask an Expert

Related Discussions:- Er schema, Assignment Help, Ask Question on Er schema, Get Answer, Expert's Help, Er schema Discussions

Write discussion on Er schema
Your posts are moderated

Write your message here..

Related Questions

What is a built-in, What is a Built-in A notation of identity is built-... What is a Built-in A notation of identity is built-into the data model or programming language and no user-supplied identifier is needed. This form of identity is used in objec

Relational data base management system, explain in detail about crash recov... explain in detail about crash recovery

Explain the concept of a data model, Explain the concept of a data model ? ... Explain the concept of a data model ? Data Model - Model is an abstraction procedure which hides irrelevant details although highlighting details relevant to the application

Consistency-transaction , Consistency: This property makes sure that a com... Consistency: This property makes sure that a complete transaction implementation takes a database from one consistent state to another consistent state. If the transaction fails e

What is an index, What is an Index? An index is a small table having on... What is an Index? An index is a small table having only two columns. The first column has a copy of the primary or candidate key of a table and the second column having a set o

Explain the steps for reduction of e-r model, Explain the steps for reducti... Explain the steps for reduction of E-R model into relational model. Ans:(a) Entity set in E-R model will be considered as table name in relational Model. (b) Attributes of e

The third normal form (3nf), The Third Normal Form (3NF) Even though, t... The Third Normal Form (3NF) Even though, transforming a relation that is not in 2NF into a number of relations that are in 2NF take out many of the anomalies, it does not neces

Locks, Locks: Serialisabilty is just a test whether a given interleaved sch... Locks: Serialisabilty is just a test whether a given interleaved schedule is ok or has a concurrency related trouble. Though, it does not make sure that the interleaved concurrent

Example of ancestry database , Ancestry database records information about ... Ancestry database records information about family trees . Following information is recorded about each person: FIRSTNAME first name SURNAME surname MNAME maiden name (if

Tour Operator Agency Database , #A multinational tour operator agency has g... #A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six mont