Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Table 1.5: Sample data for Relation of Department Dept_Name Marketing Accountant Logistic Dept_ld A B C Table 1.6: Data structure for Department Description Primary Key Attribute Туре Dept_ld Char(1) Dept Name Varchar(20) Construct a SQL Data Definition Language (DDL) or Data Manipulation Language (DML) for the following statement: a) Create table without constraint for Employee and Position relations. b) Create table with constraint for Department relation. c) Add constraint primary key for Position relation. d) Add constraint primary key and foreign key for Employee relation. e) Insert value one by one for Position relation. f) Change the attribute for Salary from 5,2 to 8,2. g) Insert all values for Department and Employee relations.

Table 1.5: Sample data for Relation of Department Dept_Name Marketing Accountant Logistic Dept_ld A B C Table 1.6: Data structure for Department Description Primary Key Attribute Туре Dept_ld Char(1) Dept Name Varchar(20) Construct a SQL Data Definition Language (DDL) or Data Manipulation Language (DML) for the following statement: a) Create table without constraint for Employee and Position relations. b) Create table with constraint for Department relation. c) Add constraint primary key for Position relation. d) Add constraint primary key and foreign key for Employee relation. e) Insert value one by one for Position relation. f) Change the attribute for Salary from 5,2 to 8,2. g) Insert all values for Department and Employee relations.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

The subject is called Database

QUESTION 1 Given the following relations and data structure for each relation: Emp_ld 101 102 103 104 105 106 107 Table 1.1: Sample data for Relation of Employee Post_id 500 501 Emp_Name Johan Endut David a/l Maniam Siti Sarimah Ghazali Anne Raj Mohd Farid Tumiran Halimahton Hamid Al Azim Al Amin Emp_ld Emp_ Name Emp_Date Post_ld Dept_ld Emp_Date 11 Jun 2009 07 Feb 2007 12 Jan 2010 15 Nov 2000 Table 1.2: Data structure of Employee Attribute Type Description Primary key 02 Jan 2011 23 Jun 2000 10 Oct 2003 503 Number(3) Varchar(30) Date Number(3) Char(1) 500 501 502 500 503 Table 1.3: Sample data for Relation of Position Post Id Position Salary 500 3000.00 501 2000.00 502 1500.00 2050.00 Senior Manager Junior Executive Clerk Secretary Foreign key Foreign key Number(3) Varchar(20) Number(5,2) Table1. 4: Data structure for Position Attribute Type Description Post_id Primary key Post Salary Dept_ld A B A B C A A
Transcribed Image Text:QUESTION 1 Given the following relations and data structure for each relation: Emp_ld 101 102 103 104 105 106 107 Table 1.1: Sample data for Relation of Employee Post_id 500 501 Emp_Name Johan Endut David a/l Maniam Siti Sarimah Ghazali Anne Raj Mohd Farid Tumiran Halimahton Hamid Al Azim Al Amin Emp_ld Emp_ Name Emp_Date Post_ld Dept_ld Emp_Date 11 Jun 2009 07 Feb 2007 12 Jan 2010 15 Nov 2000 Table 1.2: Data structure of Employee Attribute Type Description Primary key 02 Jan 2011 23 Jun 2000 10 Oct 2003 503 Number(3) Varchar(30) Date Number(3) Char(1) 500 501 502 500 503 Table 1.3: Sample data for Relation of Position Post Id Position Salary 500 3000.00 501 2000.00 502 1500.00 2050.00 Senior Manager Junior Executive Clerk Secretary Foreign key Foreign key Number(3) Varchar(20) Number(5,2) Table1. 4: Data structure for Position Attribute Type Description Post_id Primary key Post Salary Dept_ld A B A B C A A
Table 1.5: Sample data for Relation of Department Dept_Name Marketing Accountant Logistic Dept_ld A B C Table 1.6: Data structure for Department Description Primary Key Attribute Type Dept_ld Char(1) Dept Name Varchar(20) Construct a SQL Data Definition Language (DDL) or Data Manipulation Language (DML) for the following statement: a) Create table without constraint for Employee and Position relations. b) Create table with constraint for Department relation. c) Add constraint primary key for Position relation. d) Add constraint primary key and foreign key for Employee relation. e) Insert value one by one for Position relation. f) Change the attribute for Salary from 5,2 to 8,2. g) Insert all values for Department and Employee relations.
Transcribed Image Text:Table 1.5: Sample data for Relation of Department Dept_Name Marketing Accountant Logistic Dept_ld A B C Table 1.6: Data structure for Department Description Primary Key Attribute Type Dept_ld Char(1) Dept Name Varchar(20) Construct a SQL Data Definition Language (DDL) or Data Manipulation Language (DML) for the following statement: a) Create table without constraint for Employee and Position relations. b) Create table with constraint for Department relation. c) Add constraint primary key for Position relation. d) Add constraint primary key and foreign key for Employee relation. e) Insert value one by one for Position relation. f) Change the attribute for Salary from 5,2 to 8,2. g) Insert all values for Department and Employee relations.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Arrays
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS