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 the difference between primary key and a unique key, What's the dif... What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim

What is document scanning and imaging, What is document scanning and imagin... What is document scanning and imaging? Document scanning and imaging, or digital archiving, is the method of scanning a document into a digital image to archive and retrieve a

Entity relaionship, multiplicity constarin multiplicity constarin

Create a database model, Submit the table creation statements (including co... Submit the table creation statements (including constraints) for the Database Model. Submit them all in a single script file. Also submit a document explaining what test data yo

Dataware house, multidimensional data model multidimensional data model

Ddl compiler-database management system, DDL Compiler The DDL compile... DDL Compiler The DDL compiler changes the data definition statements (such as CREATE TABLE .... in SQL) into a set of tables having metadata tables. These tables have infor

Describe substring comparison in sql, Describe substring comparison in SQL.... Describe substring comparison in SQL. For the relation Person (name, address), write a SQL query that retrieves the names of people whose name starts along with ‘A' and address co

Define the wait for graph, Define the Wait for graph Ans: The wait-for-... Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap

What are the uses of functional dependencies, What are the uses of function... What are the uses of functional dependencies? To test relations to see whether they are legal under a given set of functional dependencies. To state constraints on the set

Compare wait-die deadlock prevention with wait-wound scheme, Compare wait-d... Compare wait-die deadlock prevention scheme with wait-wound scheme   Ans:  Wait-Die Scheme  a) Based upon a nonpreemptive technique.  b) If Pi requests a resource present