Question: In assignments 6 to 10, create a simple E-R model depicting entities and relationship lines for each data scenario. 6. A college needs to track
In assignments 6 to 10, create a simple E-R model depicting entities and relationship lines for each data scenario. 6. A college needs to track placement test scores for incoming students. Each student can take a variety of tests, including English and math. Some students are required to take placement tests because of previous coursework. 7. Every employee in a company is assigned to one department. Every department can contain many employees. 8. A movie megaplex needs to collect movie attendance data. The company maintains 16 theaters in a single location. Each movie offered can be shown in one or more of the available theaters and is typically scheduled for three to six showings in a day. The movies are rotated through the theaters to ensure that each is shown in one of the stadium-seating theaters at least once. 9. An online retailer of coffee beans maintains a long list of unique coffee flavors. The company purchases beans from a number of suppliers; however, each specific flavor of coffee is purchased from only a single supplier. Many of the customers are repeat purchasers and typically order at least five flavors of beans in each order. 10. Data for an information
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
