\n Entity-Relationship Diagram Assignment\n <\/p>\n
\n Draw the associated E-R Diagram and signify which components need to be included to meet the defined needs.\n <\/p>\n
\n 1)\u00a0\u00a0\u00a0\u00a0 The user is a director of research for a large foundation. Approximately three hundred facilities are staffed by the foundation\u2019s twelve-hundred employees. Over seventeen hundred projects are currently underway, with some three-hundred and fifty waiting to be worked on in the future.\n <\/p>\n
\n The system is responsible for information regarding the current state of affairs only. Requests for information are:\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 List all current employees in name sequence\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 List all employees who work at a particular facility\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Determine which facility has the most employees; which has the fewest\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Display the names of all employees currently working on a particular project\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Display all projects an employee is currently working on\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Locate inactive (no employee assigned) project\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Determine the ratio of active to inactive projects\n <\/p>\n
\n 2)\u00a0\u00a0\u00a0\u00a0 The user is responsible for all shared hardware devices in the building. Approximately five-hundred and twenty-five devices are installed in three-hundred offices. Each device can be shared by any number of users.\n <\/p>\n
\n The system is responsible for keeping track of:\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 The office in which each device is installed\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 The date the device was installed\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 The users authorized to employ the device\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 The ten devices that have the largest number of users; and the ten witch have the fewest\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 The total number of devices currently installed\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 The average number of devices per office; the office with the most devices; and the office with the fewest\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Users who are authorized to use devices in more than one office\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 A list of all offices without a device of some sort\n <\/p>\n
\n 3) \u00a0 The user is a manager of a growing air freight service. Seven-hundred routes are traveled by some of the firm\u2019s eight-hundred and fifty planes each day. Customer packages are assigned to a particular route. Each route is assigned to a particular plane each day.\n <\/p>\n
\n The system is responsible for the following operations:\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Display the plane for a given route\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Display the route for a given plane\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Determining how many packages are on each route, the average number of packages per route, the route with the most packages and the route with the fewest\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Keeping track of the total number of unavailable (route assigned) and available (no route assigned) planes\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Displaying all the packages given a customer name\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Locating the customer for a particular package\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Calculating the percentage of currently available planes\n <\/p>\n
\n 4) The user is a manager of a large taxi cab service. Seven hundred cabs are manned by about fourteen-hundred drivers on two shifts. The city of operation is divided into nine-hundred square areas, each consisting of a number of streets. All streets are straight and run either east\/west or north\/south. A street may be in more than one area. Street names are unique. Each driver is assigned to a particular cab and area when they arrive for work. The driver reports to the dispatcher by radio upon pick-up (\u201ccab 47, in use\u201d) and delivery of customers at their destination (\u201ccab 47, available\u201d). The driver also reports area changes (\u201ccab 47, area 13\u201d).\n <\/p>\n
\n The system is responsible for the following operations:\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Locating the area, given the names of two intersecting streets\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Locating an available cab in a given area\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Determining how many cabs are in each area, the average number of cabs per area, the area with the most cabs and the area with the fewest cabs\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Keep track of the total \u201cin use\u201d and \u201cavailable\u201d cabs\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Locating a driver given his name\n <\/p>\n
\n \u00b7\u00a0\u00a0\u00a0\u00a0\u00a0 Calculating the percentage of currently \u201cavailable\u201d cabs.\n <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Entity-Relationship Diagram Assignment Draw the associated E-R Diagram and signify which components need to be included to meet the defined needs. 1)\u00a0\u00a0\u00a0\u00a0 The user is a director of research for a large foundation. Approximately three hundred facilities are staffed by the foundation\u2019s twelve-hundred employees. Over seventeen hundred projects are currently underway, with some three-hundred and […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/246419"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=246419"}],"version-history":[{"count":1,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/246419\/revisions"}],"predecessor-version":[{"id":249303,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/246419\/revisions\/249303"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=246419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=246419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=246419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}