Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started