Draw Level 0 DFD for the given Context Level DFD.

Answer:

Q2

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.

ANS:

Q3

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.

Q4

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?

Investors/ Creditors Cash Cash Labor Employees Cash Goods, Services Cash Suppliers RSWS Goods, Services Cash Customers