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

How can you map null values to other values while display, How can you map ... How can you map NULL values to other values while display? IF( ) , IFNULL( ) keywords are used to do so. They are 'LIMIT' is used for the following kinds of problems: 1) Ans

Entity Relationship for music band managem modeliing, i am required to come... i am required to come up with entities relationships, optionality and cardinality from a scenario. there is a night club and bookings for a musician band

Explain recursive relationship type, Explain Recursive relationship type? ... Explain Recursive relationship type? Recursive relationship type: A recursive relationship is one in that the similar entity participates more than once in the relationship

ERD DIAGRAM, Law Associates is a large legal practice based in Sydney. You... Law Associates is a large legal practice based in Sydney. You have been asked to design a data model for the practice based upon the following specification: The practice employs

Data warehousing and business intelligence, I need help with data warehousi... I need help with data warehousing and business intelligence course project about designing a data warehouse for a jewelry company that does not have one

Employees and projects scenario, how many hourse have been spent on a certa... how many hourse have been spent on a certain project

Data warehouse, #queDefine a job scheduling strategy that will meet busines... #queDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pic

Importance of file organisation in database, Importance Of File Organisatio... Importance Of File Organisation In Database To execute a database efficiently, there are various design tradeoffs needed. One of the most vital ones is the file Organisation. F

Decompose the table with the functional dependencies, Decompose the table w... Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. This database stores records from a (ve

What is the disadvantage of a call by reference, What is the disadvantage o... What is the disadvantage of a call by reference? During a call by reference damage or loss of data is not restricted to the subroutine, but will instantly lead to alters to th