Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Write the data definition statements of SQL that modify the structures of a database listed on a page 2 of the examination paper such that

Write the data definition statements of SQL that modify the structures of a database listed on a page 2 of the
examination paper such that after the modifications the following data manipulations are possible.
(1) It should be possible to add to the database information about the present employer of each applicant.
(2) It should be possible to store in the database information about the courses passed by each applicant;
assume that an applicant passes zero or more courses and each course is described by a unique
name, no more than 30 characters long.
(3) It should be possible to store information about the types of position offered by the employer; assume
that a type of position is either "admin" or "production" or "security".
(4) It should be possible to skip information about phone number when entering data of a new applicant or
modifying data of already recorded applicant.
(5) The skill level that possessed by an applicant and needed for a position can be a positive integer that up
to 10.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Multimedia Database Systems

Authors: V.S. Subrahmanian

1st Edition

1558604669, 978-1558604667

More Books

Students explore these related Databases questions