data bases
|
Pg. 01 |
|
Question One |
|
|
|
|
Assignment 2
Deadline: Day 24/02/2021 @ 23:59
[Total Mark for this Assignment is 5]
Fundamentals of Database
IT403
College of Computing and Informatics
|
|
|
|
|
|
|
|
Question One
1.5 Marks
Learning Outcome(s):LO6
Create a database application to store and retrieve data.
Consider the following collection of relation schemes:
· Instructor (inst_name, deptname, salary)
· Department (deptname, building, budget)
· Committee (committee_name, commit_type, num_of_members)
· instructor_committee (inst_name, committee_name)
Write Relational Query Expression to do the following:
a. Find all the committee names where instructor Abdullah is a member
b. Find the maximum given salary.
c. Find the total number of instructors for each department.
Question Two
2 Marks
Learning Outcome(s):LO6
Create a database application to store and retrieve data.
Consider the following relation instances:
Student
|
Student_id |
Name |
Course_code |
|
Abdullah |
IT244 |
|
|
10002 |
Mohammed |
CS140 |
|
10003 |
Nasser |
CS141 |
|
10004 |
Khalid |
IT403 |
Course
|
Course_code |
Course_name |
|
IT244 |
Introduction to databases |
|
CS140 |
JAVA I |
|
CS141 |
JAVA II |
|
CS566 |
Cyber Security |
Write the output of the following relational algebra expression:
a. Student Course
b. Student Course
Question Three
1.5 Mark
Learning Outcome(s):LO1
Describe fundamental data and database concepts
You have been asked to design a database of documents, authors, and readers. described as follows:
• Document: has a docID, title
• Publisher: each author is the creator of several documents, and each document is published by one or several publishers.
• Readers: each reader reads several documents, and each document is read by several readers.
Draw an E/R diagram, which includes entity, attributes, and relationships. Remember to indicate the key for each entity, as well as the multiplicity of each relationship using the appropriate notation.(You may presume your own scenario)