ISM 4212 Database Administration Sample Midterms - Questions with Verified Answers

ISM 4212 Sample Midterms 1. Explain each of the following terms in no more than 1-2 sentences. You can provide an example if you want. a. Partial dependency: b. Candidate key: c. Deletion anomaly: d. Domain definition: e. Modality: 2. Indicate whether the following statements are true, false, or uncertain, and justify your answer in 1-2 short sentences. Please note that no points will be awarded without adequate justification. a. The first step in a database design process is a logical database design. b. An entity instance is stored in a database in form of a table. 1 c. A second-normal form association relation with no non-key attribute is always in third normal form. d. A third normal form relation has no anomalies. e. The maximum number of entity involved in any relationship is called cardinality. 3. Steve operates a cinema chain and has given you the following information: I have many cinemas. Each cinema can have many theaters. Movies are shown throughout the day starting at 11 am and finishing at 1 am. Each movie is given a 2-hour time slot. We never show a movie in more than one theater at a time, but we do shifts movies among theaters because seating capacity varies. I am interested in knowing how many people, classified by adults and children, attend each showing of a m