Reference no: EM131219010
Figure 5-59 shows a listing of movie times at theaters in Seattle. Using the data in this figure as an example, do the following:
A. Create a model to represent this report using the entities MOVIE, THEATER, and SHOW_TIME. Assume that theaters may show multiple movies. Although this report is for a particular day, your data model should allow for movie times on different days as well. Specify the identifier of the entities and their attributes. Name the relationships and the type and cardinality of all relationships. Explain which cardinalities you can logically deduce from Figure 5-59 and which need to be checked out with users. Assume that distance is an attribute of THEATER.
B. This report was prepared for a user who is located near downtown Seattle. Suppose that it is necessary to produce this same report for these theaters, but for a user located in a Seattle suburb, such as Bellevue, Renton, Redmond, or Tacoma. In this case, distance cannot be an attribute of THEATER. Change your answer in A for this situation. Specify the entity identifiers and attributes. Name the relationships and identify the type and cardinality of all relationships.
C. Suppose that you want to make this data model national. Change your answer to B so that it can be used for other metropolitan areas. Change your answer in A for this situation. Specify the entity identifiers and attributes. Name the relationships and identify the type and cardinality of all relationships.
D. Modify your answer to C to include the leading cast members. Assume that the role of a cast member is not to be modeled. Specify the identifier of new entities and their attributes. Name the relationships and identify the type and cardinality of all relationships.
E. Modify your answer to C to include the leading cast members. Assume that the role of a cast member is specified. Specify the identifier of new entities and their attributes. Name the relationships and identify the type and cardinality of all relationships.
|
Sketch the shift register described by the octal number 75
: Sketch the shift register described by the octal number 75.- Find the sequence output by this shift register assuming that the shift register is initially loaded with all ones.
|
|
Create a single-entity data model for this list
: Modify your answer to A to include entities SENDER and SUBJECT. Specify the identifiers and attributes of entities and the type and cardinalities of the relationships. Explain which cardinalities can be inferred from Figure 5-55 and which need to ..
|
|
Information about the user visit to website
: A cookie-a simple text file that is placed on a user's computer by a Web server-contains information about the user's visit to that website. It might also contain personal information a user provides to a website, such as a user name and preferenc..
|
|
Draw an entity-relationship diagram
: Draw an entity-relationship diagram that describes the following business environment. Must be done by hand, on paper. Not on the computer and include relationship types, ( i.e. Many to many, one to one represented by crows feet etc.
|
|
Create a model to represent this report using the entities
: Modify your answer to C to include the leading cast members. Assume that the role of a cast member is specified. Specify the identifier of new entities and their attributes. Name the relationships and identify the type and cardinality of all relat..
|
|
Compare the estimated filter coefficient with the true value
: Use the filtered data to obtain an estimate for the first-order prediction Wiener filter. - Compare the estimated filter coefficient with the true value.
|
|
Notice the sound output
: Your system was running fine, but you occasionally notice the sound output was "glitchy" and you decide to add a sound card. As luck would have it, a friend gave you his old sound card from a system he threw away.
|
|
Define principal characteristics of selected classroom model
: Do you feel corporal punishment is an appropriate means of behavior management in schools? Why or why not? How does corporal punishment impact a child's psychological development? Do the ends justify the means?
|
|
Describe the website structure and the purpose
: Identify the URL of the website and your assigned business model/category in the first part of the report. Describe the website structure and the purpose of each element (include snapshots and diagrams where appropriate)
|