Homework Answers
First Normal Form (1NF):
If a relation contains a multi-valued attribute, it violates the
first normal form.
A relation is in first normal form if it does not contain any composite or multi-valued attribute. A relation is in first normal form if every attribute in that relation is singled valued attribute.
1NF if:
- There are only Single Valued Attributes.
- There is a unique name for every Attribute/Column.
Let's talk about the example given:
- structure of the relation is given here since each column name is unique. so clearly it obeys the property of the table.
- But Dlocations attribute contains multi values in a single cell, that violates the 1NF rule, hence table (b) is not in 1NF form.
- where as table (c) contains redundant data but it is in 1NF. If we convert the relation (b) into 1NF we get relatin (c)
Add Answer to:
Explain the first normal form (INF) based on the example shown in the figure 14.9. Figure...
Search all employee who work total on all project less than 40 hrs from works_on table....
Search all employee who work total on all project less than 40
hrs from works_on table.
Please give me a query for this.
Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Fname Minit Lname Sex Salary Super ssn Dno B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 FranklinT Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 JZelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 9876543214 JenniferSWallace 9876543211941-06-20...
Use the tables in the next page to answer the following questions in SQL. 1. Print...
Use the tables in the next page to answer the following questions in SQL. 1. Print the names of employees who work in a project located in Houston. 2. Print the names of employees with no dependents. 3. Print the names of employees who are managers. 4. Print the names of employees who have more than one wife. 5. Print the names of employees who work in all the projects. EMPLOYEE Frame John Franklin Minit B T S K A...
(SELECT pnumber FROM project, department, employee WHERE dnum=dnumber AND mgr_ssn=ssn AND lname='Smith') UNION (SELECT pnumber FROM...
(SELECT pnumber
FROM project, department, employee
WHERE dnum=dnumber AND mgr_ssn=ssn AND lname='Smith')
UNION
(SELECT pnumber
FROM project, works_on, employee
WHERE pnumber=pno AND essn=ssnAND lname='Smith')
Can you draw the relation step by step , how to solve it
?!
Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Sex Salary Super ssn Dno B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 3334455555 Ssn Fname Minit Lname John Franklin TWong 333445555 1955-12-08 638 Voss, Houston, TXM40000...
Oracle SQL Assignment 4 - List the name of supervisor who has more supervisee than other...
Oracle SQL Assignment 4
- List the name of supervisor who has more supervisee than other
supervisors.
The supervisor would be the Mgr_ssn from the Department table.
Each employee from the Employee table has a Super_ssn which would
be their supervisor.
1 to this PC Picture Tools ew Help Acrobat Storyboarding FormatTell me what you want to de Picture Bonde A Bring Send Selection Tent Pictu楩Layout . | | Forward. Backward . Pane Figure 3.6 One possibie database state for...
Book: Fundamental of database systems Chapter 5 exercise 5.9 Figure 3-6 here provides examples on how...
Book: Fundamental of database systems
Chapter 5 exercise 5.9
Figure 3-6 here provides examples on how to answer this
question:
Photos - 20190906_111020[3691].jpg -ox See all photos + Add to Edit & Create Share : Q u ♡ 2 # d. A view that has the project name, controm of employees, and total hours worked per week on the project for each project with more than one employee working on it. 5.9. Consider the following view, DEPT SUMMARY, defined on...
Please provide the relation algebra, the oracle SQL code and the output tuples for the following (Answer #6 only the BONUS question). I have the others actually I have the BONUS, but I want to compar...
Please provide the relation algebra, the oracle SQL code and the
output tuples for the following (Answer #6 only the BONUS
question). I have the others actually I have the BONUS, but I want
to compare with your solution to make sure I did it correctly.
Thank you very much!
LAB exercises 2 Write the Oracle DML query codes for the following questions and take the screen shot of the output. 1. Retrieve the name and address of all employees...
Query 1: Retrieve names of all the projects as well as First and Last name of...
Query 1: Retrieve names of all the projects as well as First and Last name of managers if they are working on any of these projects. Database: //STEP #1: CREATE TABLE employee ( fname varchar(15) not null, minit varchar(1), lname varchar(15) not null, ssn char(9), bdate date, address varchar(50), sex char, salary decimal(10,2), Super_ssn char(9), dno char(4), primary key (ssn)); CREATE TABLE department ( dname varchar(25) not null, dnumber char(4), Mgr_ssn char(9) not null, Mgr_start_date date, primary key (dnumber)); CREATE...
drop table department cascade constraints; create table department ( Dname varchar2(15) not null, Dnumber int not...
drop table department cascade constraints;
create table department (
Dname varchar2(15) not null,
Dnumber int not null,
Mgr_ssn char(9) not null,
mgr_start_date Date,
primary key (Dnumber),
Unique (Dname));
insert into DEPARTMENT values ('Research', '5', '333445555',
'22-May-1988');
insert into DEPARTMENT values ('Administration', '4', '987654321',
'01-Jan-1995');
insert into DEPARTMENT values ('Headquarters', '1', '888665555',
'19-Jun-1981');
drop table employee cascade constraints;
create table employee (
Fname varchar2(15) not null,
Minit char(1),
Lname varchar2(15) not null,
Ssn char(9),
Bdate date,
Address varchar2(30),
Sex char(1),...
Query #2: List the name of the project and total number of hours worked on by...
Query #2: List the name of the project and total number of hours worked on by all the employees on this project, also report the number of employees working on each project. Database: //STEP #1: CREATE TABLE employee ( fname varchar(15) not null, minit varchar(1), lname varchar(15) not null, ssn char(9), bdate date, address varchar(50), sex char, salary decimal(10,2), Super_ssn char(9), dno char(4), primary key (ssn)); CREATE TABLE department ( dname varchar(25) not null, dnumber char(4), Mgr_ssn char(9) not null,...
New to DB's Please help! You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of...
New to DB's Please help!
You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of a Software Consulting Company to manage their employees and their assigned work (projects) in the company First Step to Design and Create a Database is Creating an E-R Diagram by Identifying Entities, Attributes and Relationships between any two Entities to Create a Company Database Scheme. 1. Create an E-R Diagram for the Company database from the raw data files...
Search all employee who work total on all project less than 40
hrs from works_on table.
Please give me a query for this.
Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Fname Minit Lname Sex Salary Super ssn Dno B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 FranklinT Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 JZelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 9876543214 JenniferSWallace 9876543211941-06-20...
Use the tables in the next page to answer the following questions in SQL. 1. Print the names of employees who work in a project located in Houston. 2. Print the names of employees with no dependents. 3. Print the names of employees who are managers. 4. Print the names of employees who have more than one wife. 5. Print the names of employees who work in all the projects. EMPLOYEE Frame John Franklin Minit B T S K A...
(SELECT pnumber
FROM project, department, employee
WHERE dnum=dnumber AND mgr_ssn=ssn AND lname='Smith')
UNION
(SELECT pnumber
FROM project, works_on, employee
WHERE pnumber=pno AND essn=ssnAND lname='Smith')
Can you draw the relation step by step , how to solve it
?!
Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Sex Salary Super ssn Dno B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 3334455555 Ssn Fname Minit Lname John Franklin TWong 333445555 1955-12-08 638 Voss, Houston, TXM40000...
Oracle SQL Assignment 4
- List the name of supervisor who has more supervisee than other
supervisors.
The supervisor would be the Mgr_ssn from the Department table.
Each employee from the Employee table has a Super_ssn which would
be their supervisor.
1 to this PC Picture Tools ew Help Acrobat Storyboarding FormatTell me what you want to de Picture Bonde A Bring Send Selection Tent Pictu楩Layout . | | Forward. Backward . Pane Figure 3.6 One possibie database state for...
Book: Fundamental of database systems
Chapter 5 exercise 5.9
Figure 3-6 here provides examples on how to answer this
question:
Photos - 20190906_111020[3691].jpg -ox See all photos + Add to Edit & Create Share : Q u ♡ 2 # d. A view that has the project name, controm of employees, and total hours worked per week on the project for each project with more than one employee working on it. 5.9. Consider the following view, DEPT SUMMARY, defined on...
Please provide the relation algebra, the oracle SQL code and the
output tuples for the following (Answer #6 only the BONUS
question). I have the others actually I have the BONUS, but I want
to compare with your solution to make sure I did it correctly.
Thank you very much!
LAB exercises 2 Write the Oracle DML query codes for the following questions and take the screen shot of the output. 1. Retrieve the name and address of all employees...
drop table department cascade constraints;
create table department (
Dname varchar2(15) not null,
Dnumber int not null,
Mgr_ssn char(9) not null,
mgr_start_date Date,
primary key (Dnumber),
Unique (Dname));
insert into DEPARTMENT values ('Research', '5', '333445555',
'22-May-1988');
insert into DEPARTMENT values ('Administration', '4', '987654321',
'01-Jan-1995');
insert into DEPARTMENT values ('Headquarters', '1', '888665555',
'19-Jun-1981');
drop table employee cascade constraints;
create table employee (
Fname varchar2(15) not null,
Minit char(1),
Lname varchar2(15) not null,
Ssn char(9),
Bdate date,
Address varchar2(30),
Sex char(1),...
New to DB's Please help!
You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of a Software Consulting Company to manage their employees and their assigned work (projects) in the company First Step to Design and Create a Database is Creating an E-R Diagram by Identifying Entities, Attributes and Relationships between any two Entities to Create a Company Database Scheme. 1. Create an E-R Diagram for the Company database from the raw data files...
Most questions answered within 3 hours.
-
The Walston Company is to be liquidated and has the following
liabilities:
Income taxes
$
9,400...
asked 58 seconds from now -
If
the more comprehensive data is available in MEPS, why does the NHIS
still exist? How...
asked 20 minutes ago -
Koo argues that the Japanese economy in the 1990s suffered from
a balance sheet recession. What...
asked 13 minutes ago -
Automobile mechanics conduct diagnosis tests on 150 new cars of
particular make and model to determine...
asked 7 minutes ago -
11) Find the proceeds of a 5 year non-interest
bearing note for $6500 discounted 2.5 years...
asked 14 minutes ago -
Required: Prepare the consolidated financial statements of
Griffin Ltd at 30 June 2019.
Griffin Ltd is...
asked 23 minutes ago -
1.How large must the coefficient of static friction be between
the tires and the road if...
asked 38 minutes ago -
What is the time complexity (Big-O) of the following code?
class Main
{
// Recursive...
asked 38 minutes ago -
Economists look at any situation in terms of its component
parts: the people making decisions, the...
asked 44 minutes ago -
What is a population?
Select one:
a. All of the individual organisms belonging to the same...
asked 48 minutes ago -
You have a yeast cell culture with a concentration of 5x10^4
cells/ml. If you dilute this...
asked 52 minutes ago -
In which direction the Reaction goes? Show detailed process.
SeO3 + 2ClO2. + 2H3O <---> Se...
asked 1 hour ago