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 Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 18RQ
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
SEE MORE TEXTBOOKS