IS 515 Midterm Exam Due date: October 24, 2021, 11:59PM CT Upload your completed exam as a single PDF in the course Moodle. Your name should appear in the filename as follows...

is151


IS 515 Midterm Exam Due date: October 24, 2021, 11:59PM CT Upload your completed exam as a single PDF in the course Moodle. Your name should appear in the filename as follows lastname-firstname-midterm.pdf (e.g., schneider-jodi-midterm.pdf). The submission must include a narrative document as a PDF file (to be read by a human). Label each question correctly. Please provide robust explanations to your answers that show your understanding of information modeling concepts. The exam is open book. You may use any reference materials (e.g., course readings). You may pose questions on the Course Help forum. You may discuss what the questions mean with other students, but do not work with other students and do not discuss or share your answers! 1. You’re designing an online dating app. Which of the following system requirements can be represented directly as use cases? Explain in a sentence why or why not. (5 points) a. The user will be able to set up a dating profile. b. The back-end of the system will be implemented as a neo4j graph database. c. The system will use strong encryption features. d. The system shall allow the user to search for nearby matches. e. The system will push notifications about potential matches to the user. 2. You’re designing an online system for a coffee shop. A user needs to first create an account, specify their favorite beverage, and payment preferences to use the system, The system allows the customer to browse the standard menu by beverage type (e.g., cold/hot), size (regular/large, etc.), and to create their own drinks by selecting ingredients from a separate menu. Further, the customer can save the drink they created as their favorite beverage. When ordering a beverage, they can set a pickup time and select an alternative payment if they prefer. The system sends an automatic message to the user when the barista indicates that the order is completed. The manager of the coffee shop can check the inventory using the system and order the ingredients that are low in stock or sold out from a supplier. Draw a diagram with a single use case representative of the system functionality described above. Clearly indicate the actors, use case, and each actor’s relationship to the use case. Provide the use case description, including preconditions, flow of events, and postconditions. (10 points) 3. Produce an E-R diagram for a part of a movie database with the following requirements. Be sure to include cardinality and participation constraints. Use specialization constraints if necessary. (15 points) a. Each movie is identified by title and year of release, has a length in minutes, a production company, and is classified under a single genre (e.g., horror, comedy, action, etc.). b. Each movie has one or more directors and one or more actors appear in it. c. Actors are identified by name and date of birth, and appear in one or more movies. Each actor has a role in each movie in which they appear. d. Directors are identified by name and date of birth and direct one or more movies. It is possible for a director to act in one or more movies. e. Production companies are identified by name and each has an address. A production company produces one or more movies. 4. Consider the relational schema of tennis tournaments above. Write relational algebra expressions for the queries described below. (10 points) a. List the names of all the tournaments that ‘Novak Djokovic’ played in as the 2nd seeded player. b. List the names of all male Canadian players who registered for the ‘2021 French Open’ tournament. (Note: ‘2021 French Open’ is the tournament name.) 5. Consider the relational schema of tennis tournaments above. Write SQL statements for the following queries. (10 points) a. Retrieve the names of the female players who won 2-set matches. b. List the names of American players who have participated in at least two tournaments in 2021. 6. Show the following logical equivalences and implications using truth tables. Explain in a sentence how you reach the conclusion. (5 points) a. ¬(P ↔︎ Q) ⇔(P ) ∨ (¬P ∧ Q) b. (AB) ∧ (CD) ∧ (A C) ⇒ (B D) 7. Using propositional logic, show whether the following argument is valid or not. Show clearly how you reach that conclusion. (5 points) Russia was a superior power, and either France was not strong or Napoleon made an error. Napoleon did not make an error, but if the army did not fail, then France was strong. Hence the army failed and Russia was a superior power. 5. Consider the XML DTD definition below, which models a conference management system. ] a. Write a well-formed and valid XML Document that conforms to this XML DTD definition. (10 points) b. Produce a relational schema that corresponds to the XML DTD definition. Show primary key and foreign key constraints clearly. Explain your design decisions. You may add new entity types or attributes if you feel it is necessary. (10 points)
Oct 24, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here