Tutorial week 4
Question 1
What these symbols represents? Write a brief description against each symbol.
Question 2:
Explain the types of attributes that tables possess in a relational database.
Question 3:
Abby Burke has created custom statues made out of scrap metal for over ten years. Abby has kept detailed records of every statue she has ever created. For every sale, she obtains the customer’s name and address, a description of the statue, and a picture of the statue sold to the customer. Her unique style has recently attracted the attention of several celebrities. Ready to take her business to the next level, Abby has hired you to construct an accounting information system, which she wants modeled after her paper records. As you look over her records, you realize that some customers bought multiple statues at the same time. For example, Yasmeen Ghuari bought a Tin Man Status, a flying horseman statue, and a terrier statue. You realize that in these cases, a single written record will have to be translated into multiple sales records. This is an example of what type of problem in the existing records?
Question 4:
What are the basic requirements when logically designing a relational database model?
Question 5:
Make a data flow diagram of the following transaction process
A customer made a payment on account of purchases made last month. The customer payment was processed by receipt department and deposited in the bank. The remittance advice is forwarded to Account receivable department of updating of record. The credit manager is informed about the receivable information from the customer.
Question 6:
Describe the flow of data in the below mentioned diagram.