no chatgpt and kindly provide me the proper pictures otherwise I will cancel the question if you
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assignment 2: Database design (5%) This assignment relates to the following Course Learning Requirements: CLR 2: CLR 3: CLR 4: Objective of this Assignment: The following assignment has 2 use cases, you are to use Normalization to split the use cases up and create an ERD (Entity Relationship Diagram) out of all the entities. Pre-Assignment Instructions: 1. To prepare you for this assignment, read the module 3 content and follow the embedded learning activities. 2. Open a piece of software to create an ER diagram. (Eg. Powerpoint, MySQL Workbench, ERD PLUS, LucidCharts) Assignment Tasks: Task 1 Given the following problem description, draw an ER diagram that identifies all entities, attributes, primary keys, cardinality and degree of relationships. (10 marks. Entities correctly identified: 3 marks. Attributes correctly identified: 3 marks. Relationships and cardinality: 3 marks. Primary keys: 1 mark) A shipping company ABC Courier offers the most efficient package delivery service by ensuring it can track the location and processing of every single package. They use a database system to store this information. In order to ship a package, customers drop off the package at a store location. The store must receive the packages and enter them into the system. The store can be described by store number, and location. The shipped packages are described by package number, delivery address, weight, dimensions, and delivery date. Once the packages have been entered, they will be transported to the delivery address, this can be through ground or air or a combination of both. To keep track of the packages during transportation, each transportation event is given a type (ground or air), route number and schedule number. | 1 Assignment 2: Database design (5%) This assignment relates to the following Course Learning Requirements: CLR 2: CLR 3: CLR 4: Objective of this Assignment: The following assignment has 2 use cases, you are to use Normalization to split the use cases up and create an ERD (Entity Relationship Diagram) out of all the entities. Pre-Assignment Instructions: 1. To prepare you for this assignment, read the module 3 content and follow the embedded learning activities. 2. Open a piece of software to create an ER diagram. (Eg. Powerpoint, MySQL Workbench, ERD PLUS, LucidCharts) Assignment Tasks: Task 1 Given the following problem description, draw an ER diagram that identifies all entities, attributes, primary keys, cardinality and degree of relationships. (10 marks. Entities correctly identified: 3 marks. Attributes correctly identified: 3 marks. Relationships and cardinality: 3 marks. Primary keys: 1 mark) A shipping company ABC Courier offers the most efficient package delivery service by ensuring it can track the location and processing of every single package. They use a database system to store this information. In order to ship a package, customers drop off the package at a store location. The store must receive the packages and enter them into the system. The store can be described by store number, and location. The shipped packages are described by package number, delivery address, weight, dimensions, and delivery date. Once the packages have been entered, they will be transported to the delivery address, this can be through ground or air or a combination of both. To keep track of the packages during transportation, each transportation event is given a type (ground or air), route number and schedule number. | 1
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these algorithms questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
The mass of the crane?s boom is 9000 kg. Its weight acts at?G. The sum of the moments about?P?due to the boom?s weight, the force exerted at?B?by the cable?AB,?and the force exerted at?C?by the...
-
1: Is there a natural bias to neglect the long run and concentrate too much on the short run in decision-making? Why is this so, or is it not so? 2: Comment on the difficulty of calculating...
-
An electromagnet produces a magnetic field of 0.550 T in a cylindrical region of radius 2.50 cm between its poles. A straight wire carrying a current of 10.8 A passes through the center of this...
-
Imagine you are the legal adviser to a country that has just gained independence after years of colonization. What are the advantages and disadvantages of continuing to utilize the legal system...
-
The 2014 accounting records of Blocker Transport reveal these transactions and events. Instructions Prepare the cash flows from operating activities section using the direct method. Payment of...
-
7. The full symbol of an ion of an element is 39X+? Which one of the following is the number of electrons in the ion? A. 18 B. 19 C. 20 D. 39 8. The atomic numbers of elements W, X, Y and Z are 9,...
-
1. Clearly, if Fitz-Simmons clientele have good supplier relationships, they have worked at supplier development. If they want to maintain those relationships with their suppliers, what are some...
-
Respond that the following statement is correct or incorrect? A person who gives money away to people on the street does not have preferences that can be represented by a utility function.
-
With more and more consumers and businesses using apps and online services to transfer money and conduct other financial transactions, people are naturally concerned about security. Your task: You...
-
As a way to give back to the communities in which it does business, your company supports the efforts of the United Way, a global organization that works to improve lives through education, income...
-
The following exercises help you improve your knowledge of and power over English grammar, mechanics, and usage. Turn to the Handbook of Grammar, Mechanics, and Usage at the end of this book and...
-
As a motivated, ambitious employee, you naturally care about your performance on the joband about making sure your performance is being fairly judged and rewarded. Unfortunately, the company has gone...
-
You work for a large, publicly owned organization that procures many services from organizations based both nationally and more locally to your offices. For many years your offices have been supplied...
-
Develop a resume for a specific job posting in your field. Attach the printout of the job posting (with no less than 100 words) to your resume. Start by highlighting the key words /phrases on the job...
-
A firm has the following balance sheet: Assets Cash Accounts receivable Inventory Plant and equipment $ 15,000 150,000 92,000 170,000 $427,000 Liabilities and Equity Accounts payable Long-term debt...
-
Professor Patricia (Patty) Pate is retired from the PalmSprings Culinary Arts Academy (PSCAA). She is a single taxpayer and is 68 years old. Patty lives at 98 Colander Street, Henderson, NV 89052....
-
Mallory Corporation has a calendar year-end. The corporation has paid estimated payments of $10,000 during 2012 but still owes an additional $5,000 for its 2012 tax year. a. When is the 2012 tax...
-
Deborah purchases a new $30,000 car in 2012 to use exclusively in her business. If Deborah does not elect to expense or take bonus depreciation in 2012 and holds the car until it is fully...
-
Assume the following information about Johnson & Johnson (ticker: JNJ). JNJs equity beta is 0.60. The yield on 10-year treasuries is 3%, and you estimate the market risk premium to be 6%....
-
You work in Walt Disney Companys corporate finance and treasury department and have been assigned to the team estimating Disneys WACC. You must estimate this WACC in preparation for a team meeting...
-
Suppose Starbucks is considering introducing a new low-calorie blended coffee drink called FrapZero. The firm believes that the drinks flavor and appeal to calorie-conscious drinkers will make it a...
Study smarter with the SolutionInn App