Q1:

Convert the given DFD into its equivalent System Flowchart. Exact Conversion is not necessary.

Hint: Students can use Order Receiving Officer, Order Processing Officer, and Cashier as Areas of Responsibility.

Q2:

Lets consider an enterprise called BrotherBikes. BrotherBikes manufactures bicycles and resells t-shirts. BrotherBikes sells bikes and t-shirts to a network of customers (specialized, dealers throughout the world, individual customers). It procures raw materials for bikes from a variety of suppliers, acquires ready-made t-shirts from a set of sewing labs and it has a network of investors and creditors that allows it to support its finance.

The following figure shows an overall REA business process level model for the BrotherBikess acquisition/payment business process.

.Give the relational model corresponding to the given entity-relationship diagram.

Q3:

Consider this table StudentTable:

CollegeName	IDCollege	Address	level	StudentName	StudentID
cci	1	Dammam	1	N1 LN1	s123123
cci	1	Ryadh	3	N2 LN2	S456456
Business administration	2	Abha	2	N3 LN3	S789789

a. Could you tell where the one fact-one place rule is violated in this table?

b. Reverse engineer to get the ER model that this table must represent

c. What is the correct relational model?

Q4:

Draw Level 0 DFD for the given Context Level DFD

NOTE: PLEASE SOLVE ALL THE QUESTION AT ONE TIME BECAUSE I ONLY HAVE 20 PER-MONTH AND SOLVE ALL OF THEM BY COMPUTER BECAUSE IT IS HARD TO UNDERSTAND THE HAND WRITING SOMETIMES

Cust tomers Order Payment Process Customer orders Desired Shipping nformation request data Desired Decision information makers Process Customer deliveries nts receivable Desired nformation data Process Customer payments