Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PART A - There are 15 multiple choice questions in this section (30 points - 2 points for each question). Answer ALL questions in this

image text in transcribed

PART A - There are 15 multiple choice questions in this section (30 points - 2 points for each question). Answer ALL questions in this section using the answer sheet provided. Choose the best answer. Answers with multiple responses are not accepted. Answers questions 1 and 2 based on Diagram 1 below. Employee Project Emp_Id{pk) Assign Proj_Id{pk} Name Proj_Name Position 0..1 Start Date Salary Budget Diagram 1 1. Which of the following statements IS NOT TRUE about the above ER-Model (see Diagram 1)? A. Project is a Parent Entity B. Employee is a weak entity C. Proj_Id and Emp_Id must be unique D. This is a one-to-many relationship 2. Which of the following statements IS TRUE about the multiplicity constraints of the above ER-Model (see Diagram 1)? A. Employee participation is optional B. Each project must have many employees C. Some Project do not have any employee D. Some Employees have many projects 3. What is the SQL command to insert Ahmad" as the "LName" in the "Student" table? A. INSERT ("Ahmad') INTO Student (LName); B. INSERT Table Student SET LName = 'Ahmad'; C. INSERT INTO Student ("Ahmad') INTO (LName); D. INSERT INTO Student (LName) VALUES ('Ahmad'); Which of the following will produce the lowest of all standard prices? A. select standard_price from min(product_v); B. select min(standard price) from product_v; C. select standard price from product_v where standard price = min; D. select min(standard price) from product_v where standard_price order by min(standard price)

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

Step: 3

blur-text-image

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

Pro SQL Server Wait Statistics

Authors: Enrico Van De Laar

1st Edition

1484211391, 9781484211397

More Books

Students also viewed these Databases questions

Question

=+j Enabling a productive global workforce.

Answered: 1 week ago