Database Design Design a database and show the relationship between each tables. I need multiple tables....

Database Design

Design a database and show the relationship between each tables. I need multiple tables. *Must meet the requirements for Third Normal Form.

These are the information for employee DB.

Employee Number, First Name, Last Name, Date of birth, Address, city, state, zip, department, job title, supervisor, health insurance number, health insurance provider, dental insurance number, dental insurance provider, spouse/partner, children, children's ages.

Solutions

Expert Solution

Here is the design of the database

From the design of database, it can be said that above tables are not inter related to each other primarily but they can be joined to get the required data .

The tables are in the third normal form as

a) It is in second normal form.
b) All non primary fields are dependent on the primary key.
The above design confirms that.

venereology answered 1 year ago

Next > < Previous

Related Solutions

A database needs to be developed that supports a supermarket. (i) Design an entity-relationship diagram that...

A database needs to be developed that supports a supermarket. (i) Design an entity-relationship diagram that captures, as far as possible, the requirements stated below. (Statements in brackets are additional explanations and not part of the requirements proper.) If you make any assumptions in your design, please write them down. Assumptions, however, must not contradict the requirements. 1. The supermarket sells products. Each product is uniquely identified by its product number. Moreover, a product has price. The supermarket also records...

I have tables student, professor, and person. The relationship between student and person, and professor and...

I have tables student, professor, and person. The relationship between student and person, and professor and person is Is A inheritance. A person may be a student but not a professor, a professor but not a student, or neither a professor or a student. How do I write a trigger in SQL that forces the constraint that a person cannot be a student and a professor. Some extra info: I have defined ID to be PK of person. ID is...

I need to design an air nozzle for a compressed air system with multiple outlets. All...

I need to design an air nozzle for a compressed air system with multiple outlets. All I know about the current system is there is 109 psi available in the air line. If I use the mass flow rate equation for a compressed ideal gas, how do I know the pressure hasn’t dropped in the line to decrease the Mach number as I increase the area of the nozzles? If the flow is choked, will the velocity remain constant as...

One of the characteristics of good relational database design is normalized tables. Discuss two ways in...

One of the characteristics of good relational database design is normalized tables. Discuss two ways in which normalization helps minimize data redundancy and anomalies such as insertion, deletion, and update anomalies. What are some other characteristics of good database design?

i need a scenario for factorial design

I can't figure this problem out! The problem is: Show the relationship between income and crime...

I can't figure this problem out! The problem is: Show the relationship between income and crime using indifference curves.

what is the relationship between calcium and cancer? vitamin D and cancer ? please I need...

what is the relationship between calcium and cancer? vitamin D and cancer ? please I need a long answer about 2 pages in details and citation .

what is the relationship between linear, multiple and logistic regrerssion

What is the relationship between dose, clearance, bioavailability and Steady State plasma concentration? i need it...

What is the relationship between dose, clearance, bioavailability and Steady State plasma concentration? i need it in 160 words please

Create tables according to the mapping. Add 2 records to each. Create 5 queries for database...

Create tables according to the mapping. Add 2 records to each. Create 5 queries for database of 3 table joins to use most of the tables or group of tables in database. You should not have tables that are of no use. Student(ssn, name, major) Class(classID, name, f_ssn) Faculty(ssn, name, office_num, dept_id) Department(Dept_id, office_num, f_ssn) Enroll(s_ssn, classID, grade) Professor(f_ssn, alma-mater, tenured) Instructor(f_ssn, term_degree, type) Lecture(classID, method) Lab(classID, location) Person(ssn, dob, gender)

Subjects