1.Consider the software domain of an auto parts store, like Autozone. Do the following: a). Describe...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1.Consider the software domain of an auto parts store, like Autozone. Do the following: a). Describe the main activities of this store in English. b). Identify major verbs/verb phrases and nouns/noun phrases. Then create one or more ER diagrams for this software domain. Include attributes, usually derived from minor nouns/noun phrases, for entities and relationships. c). Translate the ER model, as shown in the ER diagram, into a relational mode, which is a collection of tables (relations). (25 pts) 2.Consider a company as the software domain. Managers manage different departments. Managers are employees. Draw an ER diagram for it. Translate this ER diagram into a relational model (a collection of tables). Assume that it is a one-to-many relationship. That means one manager can manage multiple departments, but one department can be managed by one manager. Show the schemas (definitions of the tables), and clearly mark the keys in the schemas. (18 pts) 2. Consider a company as the software domain. Managers manage different departments. Managers are employees. Draw an ER diagram for it. Translate this ER diagram into a relational model (a collection of tables). Assume that it is a one-to-many relationship. That means one manager can manage multiple departments, but one department can be managed by one manager. Show the schemas (definitions of the tables), and clearly mark the keys in the schemas. (18 pts) 3. Consider the following relations (tables): (48 pts) Student(No, firstName, lastName, streetAddress, city, state, zipcode) Course( crn, courseNo, sectionNo, course Title.hours) RegistersForCourse(iNo, cm, dateRegistered) Create a SQL statement for each of the following queries. a). List jNo, firstName, lastName of all students from the state 'MS'. b).List courseNo, sectionNo, course Title of all courses taken by students from the state 'MS". c).List state, the number of students in each state with more than 50 students. d).List jNo, firstName, lastName, totalHours for all the students who are taking less than 12 hours. Do only SQL. (8 pts) e). List jNo, firstName, lastName of all students who registered before 08/20/2021. f).List jNo, firstName, lastName, courseNo, section No, course Title, hours for all the courses registered under the specific student with jNo=J00123456. g).List courseNo, courseTitle, firstName, lastName of all the students registered for courseNo='csc330' and course Title = 'Database Systems'. h).List jNo, firstName, lastName, total number of hours registered for each student. 1.Consider the software domain of an auto parts store, like Autozone. Do the following: a). Describe the main activities of this store in English. b). Identify major verbs/verb phrases and nouns/noun phrases. Then create one or more ER diagrams for this software domain. Include attributes, usually derived from minor nouns/noun phrases, for entities and relationships. c). Translate the ER model, as shown in the ER diagram, into a relational mode, which is a collection of tables (relations). (25 pts) 2.Consider a company as the software domain. Managers manage different departments. Managers are employees. Draw an ER diagram for it. Translate this ER diagram into a relational model (a collection of tables). Assume that it is a one-to-many relationship. That means one manager can manage multiple departments, but one department can be managed by one manager. Show the schemas (definitions of the tables), and clearly mark the keys in the schemas. (18 pts) 2. Consider a company as the software domain. Managers manage different departments. Managers are employees. Draw an ER diagram for it. Translate this ER diagram into a relational model (a collection of tables). Assume that it is a one-to-many relationship. That means one manager can manage multiple departments, but one department can be managed by one manager. Show the schemas (definitions of the tables), and clearly mark the keys in the schemas. (18 pts) 3. Consider the following relations (tables): (48 pts) Student(No, firstName, lastName, streetAddress, city, state, zipcode) Course( crn, courseNo, sectionNo, course Title.hours) RegistersForCourse(iNo, cm, dateRegistered) Create a SQL statement for each of the following queries. a). List jNo, firstName, lastName of all students from the state 'MS'. b).List courseNo, sectionNo, course Title of all courses taken by students from the state 'MS". c).List state, the number of students in each state with more than 50 students. d).List jNo, firstName, lastName, totalHours for all the students who are taking less than 12 hours. Do only SQL. (8 pts) e). List jNo, firstName, lastName of all students who registered before 08/20/2021. f).List jNo, firstName, lastName, courseNo, section No, course Title, hours for all the courses registered under the specific student with jNo=J00123456. g).List courseNo, courseTitle, firstName, lastName of all the students registered for courseNo='csc330' and course Title = 'Database Systems'. h).List jNo, firstName, lastName, total number of hours registered for each student.
Expert Answer:
Answer rating: 100% (QA)
Solutions 2Consider a company as the software domain Managers manage different departments Managers ... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these programming questions
-
According to Giallombardo, many female inmates engage in marriages with fellow female inmates during their incarceration. There is some debate as to what percentage of female inmates participate in...
-
Grow Well (Horticulture Systems) Ltd would like six weeks to fit out the premises before the lease commences and would like a three-year lease with two rights of renewal. The landlord is happy to...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
The Sooner Equipment Company has total assets of $100 million. Of this total, $40 million was financed with common equity and $60 million with debt (both long- and short-term). Its average accounts...
-
Repeat Prob. 7.9, using the polynomial profile suggested by K. Pohlhausen in 1921: Does this profile satisfy the boundary conditions of laminar flat-plate flow?
-
Suppose that X1, X2, and X3 are independent random variables each with a mean of and a variance of 2. Compare the means and variances of Y = 3X1 and Z = X, + X2 + X3
-
VMO is typically a ________ limitation.
-
Daves Pizza bought a used Toyota delivery van on January 2, 2014, for $28,600. The van was expected to remain in service for four years (154,000 miles). At the end of its useful life, Daves officials...
-
The following is a sequence of eight numbers: 01 2 3 4 5 6 7 350 100 250 400 300 50 200 150 Use QuickSort to sort the numbers in the sequence in ascending order. Show the result of each step by...
-
Kalogridis Corp. manufactures industrial dye. The company is preparing its 2011 master budget and has presented you with the following information: a. The projected December 31, 2010, balance sheet...
-
Which one is the balanced chemical equation for the AH for H3BO3(s)? O 3H(g) + B(s) + 30(g) H3BO3(s) OH(g) + B(s) + O(g) H3BO3(s) OH3BO3(s)%2H(g) + B(s) + 2O(g) OH(g) + B(s) + O(g) H3BO3(s)
-
What are three abilities in negotiation? Which one is the most important ability to apply during the negotiation full of hoax? Please provide reasons as well as examples to support
-
The type of pricing policy that takes the amount it cost you to make the product and increments that amount by a set percentage to determine the final price,what is this called and how is it working?
-
Why is it important for childcare workers and administrators at every level to participate in ongoing professional development/training. Explain
-
List at six (6) instruction styles for providing clear instructions to students
-
A long-time customer scheduled work to be done on her vehicle. Swifty Auto Repairs, recorded the work on job cost sheet #140 The following cost information was recorded on this customer's job. Direct...
-
Do Kirlian photographs show the soul of an organism?
-
This problem continues the Draper Consulting, Inc., situation from Problem 12-45 of Chapter 12. In October, Draper has the following transactions related to its common shares: Oct 1 Draper...
-
Consider the following situation: Your manager comes to you and says, I dont understand why everyone is talking about the total-life-cycle costing approach to product costing. As far as I am...
-
Evaluating system performance Suppose that you are the manager of a production facility in a business that makes plastic items that organizations use for advertising. The customer chooses the color...
-
Tenneco, Inc., produces three models of tennis rackets: standard, deluxe, and pro. Following are the sales and cost information for 2011: Fixed manufacturing support costs are $800,000, and fixed...
-
Create a complete stable pattern by using the tips and heuristics provided in this chapter.
-
Develop the following systems using the fairness pattern: 1. Tax fairness: A tax platform based on an ideal that aims to create a system of taxation that is fair, clear, and equivalent for all...
-
BOs make this pattern stable and extendible. Do you agree?
Study smarter with the SolutionInn App