BA 3340 Lecture 37: 2018 summer semester lecture137
Document Summary
Quiz week 4 - ch1,3 and lecture week 1 &2. Scenario: a local video shop manually processes video loans and returns, and keeps their records in paper format. The owners of the shop are considering computerising their business operation and record keeping. What data from the video shop could be stored in database jles? customer details, date borrowed, due date etc. The local video shop has an option to record its data this way: David low has rented avatar on 23/8/12 at 1pm. Patrick vidgen has rented titanic on 19/8/12 at 2pm. John campbell has rented rebirth on 1/8/12 at 4pm. Option 2 is clearly the easier way, straight forward. Date t name t name vid rick n. Can only connect two tables through a common column. Foreign key - key borrowed from another table. Entity - relationship diagram entity - somethings user wants to track relationships - verb entity - noun.
