cs101 assignment 2 solution fall 2022

• High School
• You don't have any recent items yet.
• You don't have any courses yet.
• You don't have any books yet.
• You don't have any Studylists yet.
• Information

Fall 2022 CS101 2 - notes

Computer science (cs101), virtual university of pakistan.

Recommended for you

Students also viewed.

• Fall 2022 CS101 2 SOL - notes
• Activity-Template -Project-charter
• Examples of Exception handling in C++
• Assignment Solution CS101
• A function can be called with its name in the same function
• CS101 Most important Modules Final term

Related documents

• Cs101 Long Questions-1
• Fall 2022 CS501 2 - i need this
• Cs201-midterm-subject
• Mid term syllabus - BSIT
• Highlights pak301 handsout

Preview text

Introduction to computing (cs101), assignment # 02.

Total marks = 10

Deadline Date January 23, 2023

Please carefully read the following instructions before attempting the assignment.

RULES FOR MARKING It should be clear that your assignment would not get any credit if:  The assignment is submitted after the due date.  The submitted assignment does not open or the file is corrupt.  Strict action will be taken if the submitted solution is copied from any other student or the internet.

You should consult the recommended books to clarify your concepts as handouts are not sufficient. You are supposed to submit your assignment in Doc or Docx format. Any other formats like scan images, PDF, ZIP, RAR, PPT, BMP, etc. will not be accepted.

Objectives:  To learn about relational databases.  To learn the use of relational database operators.  To learn the syntax of writing relational database queries.

No assignment will be accepted after the due date via email in any case (whether it is the case of load shedding or internet malfunctioning etc.). Hence refrain from uploading assignments in the last hour of the deadline. It is recommended to upload the solution file at least two days before its closing date.

If you people find any mistake or confusion in the assignment (Question statement), please consult with your instructor before the deadline. After the deadline, no queries will be entertained in this regard. For any query, feel free to email at: [email protected]

Question Marks (10)

A software developer has built a relational database model for the Learning Management System of an online learning website. Various relations (tables) are defined to store data records related to each entity in a separate relation. Three of the Relations (STUDENT, COURSE, and ENROLLMENT) defined in that database model along with their attributes are given below:

StudentID StudentName DegreeProgram ResidentCity ... ... ... ... ... ... ... ... ... ... ... ...

COURSE CourseCode CourseTitle TeacherID DegreeProgram CreditHours ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...

ENROLLMENT StudentID CourseID Semester ... ... ... ... ... ... ... ... ...

The developer needs to extract the following information given in Table-1 from his defined database model using the relational database queries that consist of SELECT, PROJECT and JOIN operators.

Table-1: Required Information Sr. No. Information required to be Extracted 1 Extract all the students from the STUDENT table belonging to a specific city. 2 Extract all the students from the STUDENT table who are enrolled in “BSCS” degree program. 3 Extract all the records in the columns “Student Name” and “Degree Program” of the STUDENT table. 4 Extract all the records in the columns “Course Code”, “Course Title” and “Degree Program” of the COURSE table. 5 Extract all the courses from the COURSE table having three or more credit hours. 6 Join STUDENT and COURSE tables using the Degree Program attribute.

Now, you need to fill the remaining five (5) entries in the below given table with the Reference label of correct relational database against each Sr. No. of the required information table.

(Provide your Answer only in the below given Table)

Sr. No. of Required Information given in Table-

Reference label of the Correct Relational Query {Out of A, B, C, D, E, F, G, H, I, J, K, L} from Table- 1 A (solved) 2? 3? 4? 5? 6?

Note: You don’t need to copy the assignment statement or write any queries in your solution file. Just mention the “reference label” of the correct relational database query from table-2 against the Sr. No. of “Required Information” in the above table.

Best of Luck

• Multiple Choice

Course : Computer science (CS101)

University : virtual university of pakistan.

• More from: Computer science CS101 Virtual University of Pakistan 900   Documents Go to course

• No category

Fall 2022 CS101 2 (1)

Related documents

Add this document to collection(s)

You can add this document to your study collection(s)

Add this document to saved

You can add this document to your saved list

Suggest us how to improve StudyLib

(For complaints, use another form )

Input it if you want to receive answer