Midterm Paper Session 20-24

The University of Azad Jammu & Kashmir
Department of Software Engineering
th
Subject: Introduction to Databases Systems (CS-2202) Class: 4 Semester Time: 180 mints Max. Marks: 25
Course Instructor: Engr. Sadaqat Hussain Exam: Mid Roll No. ____________________
1 Note:
Note: Answer to the point. Don’t write irrelevant material. Draw neat and clean labeled diagrams
where necessary.
SOPs for Online Examination
1. Exam timing is from 02:00 am to 5:00 pm & (1 hour for uploading (5:00pm-6:00pm)
There will be no relaxation in timing.
2. Handwritten paper will be acceptable only.
3. There should be no Plagiarism/Copy in paper otherwise it will be
considered as cheating.
4. Each page of paper must contain page number and roll number.
5. Soft copy uploaded on MS Teams. Do not share your answer sheet on WhatsApp
group otherwise your paper will be considered cancelled.
6. Paper Softcopy must be submitted before 6:00pm of same day. After that no paper will
be acceptable.
7. Softcopy must be in pdf format. For this purpose download clear Scanner app on your
mobile. Make sure you make single file containing all pages of your paper.
8. File name must be in format “complete roll number_ subject name” for
example
20-SE-01_ Database Systems
9. After completion of examination student will send hardcopy of all papers in a seal
envelope to department of software engineering University of Azad Jammu and
Kashmir Chellah campus Muzaffarabad.
10. Make sure there must be no difference between hardcopy and softcopy otherwise the
paper will be considered cancelled..
1. Give answers to the following questions. Avoid unnecessary details. CLO1 (10)
a. Make relation b/w two tables with foreign key? With example?
b. How to implement one-to-one relationship while designing tables.
c. The following diagram describe a part of E-R diagram
Considering the above diagram, which of the given statements are true and which are false .if statement
is wrong then do correction
i. Entity2 is a weak entity.
ii. Cardinality ratio for Entity1:Entity2 in Rel1 is 1:N.
iii. Attribute 6 represents an attribute which is having composite nature.
iv. Attrib3 is a kind of a derived attributes.
v. Entity2 is participating totally in the Rel1 relationship.
d. What is the importance of determining minimum cardinality in a relationship
2. Identify the entities with their proper attributes from given below Case Study . (06)
Case Study 1 CLO 3
Suppose we have a wireless ad hoc network. A wireless ad hoc network is a decentralized type of wireless
network. The network is ad hoc because it does not rely on a pre -existing infrastructure, such
as routers in wired networks or access points in managed (infrastructure) wireless networks. Instead,
each node participates in routing by forwarding data for other nodes, so the determination of which
nodes forward data is made dynamically on the basis of network connectivity.
Nodes in the ad hoc network has unique id that identify it across the network. Each of the nodes uses a
certain protocol.
Various protocols are used including aodv, dsdv, dsr etc. There are various version of a specific protocol.
An ad hoc network typically refers to any set of networks where all devices have equal status on a network
and are free to associate with any other ad hoc network device in link range.
Nodes in the ad hoc network send packets to each other. Each packet has two parts namely: header and
data. Header information contains source destination IP address and some other information. Every
packet will leave for a certain time of period around the network called RTT (Round trip time). Each
packet is sent on one of the route based on the source destination address. There can be several hops
around one route. Every route is assigned a weight based on some pre -defined rule.
3. From the Case Study 2, construct DFD for given below case study. (09)
CLO2
Case Study 2:
In this technological era manually managing any system is a time-consuming task. A construction company named
“Global Construction” wants to computerize their manual system, so that they can easily and efficiently manage
their employees, clients, projects and finance. It will be beneficial for both clients and company. Company has
different employees who work on different projects. Global Construction database system will store all the
information in an organized manner by following the below business rules:
Client can visit the website, view completed projects details and client’s review/feedback about projects, places an
order by filling the order form, give review/feedback.
Manager can assign projects to employees, view assigned projects. Manger can also view placed orders, can
accept or cancel the order. He can also generate receipt; client will be able to view and download the receipt.
Employees will be able to view assigned projects, he can also update status of the project as started, partially
completed, or completed.
You are required to perform the following tasks according to above scenario.
 Draw the context level diagram.
 Draw the level 0 DFD.
Best of Luck

Midterm Paper Session 20-24

Uploaded by

Copyright:

Available Formats

Midterm Paper Session 20-24

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Midterm Paper Session 20-24

Uploaded by

Copyright:

Available Formats

The University of Azad Jammu & Kashmir

Department of Software Engineering

You might also like