CS403-DBMS Quiz MCQS #Objective #Questions #Finalterm 1. Consider a table “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’ ORDER BY Age; The statement has a syntax error The statement displays the entire fields from emp in …
CS403-DBMS Quiz MCQS #Objective #Questions #Midterm 1. Student and Book are two entities, what is the cardinality between the two? Many to One One to Many Many to Many One to One 2. A description on a particular collection of data using the given data model Database Relation Schema None 3. Level of data at …
Subject: CS403-DBMS Semester: SPRING 2019Assignment No. 2Due date: 30 May 2019 CS403 DBMS ASSIGNMENT 2 SOLUTION SPRING 2019 CS403-DBMS Assignment 2 #Question Our second assignment is the continuation of the first assignment. In the first assignment, an ERD was required for the given scenario. The ERD of the first assignment is given below: You’re required …
