Er schema, Database Management System

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







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
Related Questions
Mention the type of constraints we can specify in the CREATE command of DDL. The type of constraints that can be specified are as follows:- PRIMARY KEY, NOT NULL, UNIQUE, FOR

Explain the Natural join Natural join is a binary operator which is written as (R* S) in which R and S are relations. The effect of the natural join is the set of all combinati

How can you Start MySQL Server? To start the mysql program type it is name in the command- line prompt. After starting mysql program just display A welcome letter using the

Question 1 Suppose the employee employee id, name, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequen

Explain the B + tree? B + tree is a type of tree which denotes sorted data in a way that permits for efficient insertion, retrieval and removal of records, each of which is

Explain the integrity constraints: Not Null,  Unique, Primary Key with an example each. Is the combination 'Not Null, Primary Key' a valid combination. Justify. Not Null - Shou

Use Access 2007 to create a database called UniLib.mdb. - this file should be created on your personal drive at the university (or C: if you're using Access 2007 at home) and t

I need some help with my normalization database homework.

Explain the term- signal-to-noise ratio A signal-to-noise ratio of 20 dB means that S/N = 100. As log2101 is around 6.658, the Shannon limit is around 19.975 kbps. The Nyquist

Lack of Redundancy We have talked about the problems of repetition of information in a database. Such repetition should be stay away as much as possible. Let us state once again t