Muhammet Yalcin Ozdemir
Next locate the foreign key values and describe the relationships that exist between the foreign
keys and the primary keys. State the values in each table that form the relationships.
Order# in Orderitems table is a foreign
A company has various rules for how payments to suppliers are to be authorized.
Some payments are in response to an approved purchase order.
For approved purchase orders under $5,000, the accounting clerk can immediately issue a check
against that purchas
A nonprofit organization depends on a number of different types of persons for its successful
The organization is interested in the following attributes for all of these persons: SSN, Name,
Address, City/State/Zip, and Telephone.
Three types o
Muhammet Yalcin Ozdemir n01070049
Q1- Which tables and fields would you need to access to determine
which books have been purchased by a customer in the current months
I would need to access these tables and fields:
M.Yalcin Ozdemir n01070049
Violations of rules
1-Context diagram should not include data stores.
1 Consistency: Data store is from level-0 diagram but showed in context
2- Primitive DFD: It is the lowest logical level for the sys
A relatively small company that sells eyeglasses to the public wants to incentivize its sales staff to sell
customers higher quality frames, lenses, and options.
To do this, the company has decided