List the data elements that are needed by the owner of Mobility Product Inc. to support the improved processes that you suggested in Assignment 1 for order processing, shipment and delivery tracking.If you did your own scenario in Assignment 1, then just read through the Mobility Inc. case and list the data items that are needed for efficient order processing, shipment tracking and customer service.You can use the form that is included in the case to get some ideas about the data elements that may be needed. Try to keep the list manageable (for example, do not try to list all possible features of the product, just a simple description, model number and color will be enough). (10 points)
Develop an ERD from the list of data elements identified above.Clearly show the entities, their attributes and the relationship between various entities along with the cardinalities and modalities.If you do your design correctly, then you should get have about 4-6 entities.(15 points)
Translate the ERD into complete database design.Make sure that you introduce/include the intermediate relations that may be needed to connect the many to many relationships in the design.Develop a database in MS-Access using your design and populate the tables with manufactured data.There is a site called fakenamegenerator.com that may be helpful in creating the ‘fake” data. (30 points)
Within the database you have created in Step 4, create the Queries necessary to support the information required by the company.Some examples of the queries are listed below. (30 points)
History of customer orders that will show customer details, products that they ordered along with order and delivery date and the sale price.
Shipping information for ordered products (product details, customer details along with the delivery address, date order was placed, date shipped, date to be delivered and the shipping company used).
The amount of revenue and profit generated by each customer and by each product model (two separate queries, one for the customer and another for the product).
A list of orders generated by each sales person for the last one month.This one should be interactive so that the information for each sales person can be easily found through a pop-up search box.
Discuss the business advantages for MPI in using the database and also resources needed by MPI to implement the database. (15 points)
Extension of the event of E. coli in the network As a human administrations director in the event of contamination, I will take all vital measures to speak with youngsters, guardians and clinical staff in an ideal and viable manner take. My first concern is to separate maladies however much as could be expected and to permit those effectively contaminated to get the treatment they need (Graham-Clay, 2005). On the off chance that infections, for example, Escherichia coli happen in a nearby secondary school, we will quickly illuminate the clinical staff. Escherichia coli diseases from food cause genuine ailment, which can prompt genuine ailment and some of the time demise. Since treatment is restricted, anticipation by overseeing food handling is critical to control the event of these sicknesses. Notwithstanding, E. coli is profoundly flexible, versatile, can convey and move DNA, makes new strains and is impervious to current preparing and control strategies. Further exploration is required here before unlimited oversight is acquired. Intestinal hemorrhagic E. coli is a perceived malady because of the event of a financially accessible cheap food burger. Indications of bacterial disease by E. coli incorporate extreme loose bowels, normally blood, stomach agony and retching. Youngsters younger than 4 are bound to build up this infection. Related nourishments incorporate uncooked hamburger, unsterilized milk, juice. Debased water can be brought about by fecal tainting of individuals who have microbes. Indeed, even disinfectants utilized in certain items will most likely be unable to viably crush microbes. In this way, it is suggested that individuals with inabilities in the safe framework and other high-hazard bunches abstain from eating sprouts. Chloride-treated fledglings are still connected with the improvement of E. coli and Salmonella (Taormina and Beuchat 1999). Treatment incorporates strong consideration and observing of renal capacity (CDC, 2001). By and large, antibodies are contraindicated. The final product of kidney disappointment might be deathThe thought that the network affects the development of character is the way to Pythia Peay's article "Soul Searching" and Winona LaDuke's meeting. "The two creators who keep up the network introduced comparative perspectives and alternate points of view by living in the network and turning out to be individuals from the network and influencing individuals in the network. I experienced a month to month or yearly get-together, and they accounted for themselves as networks: the Network Summit Community, the TEDx Community, the SxSW Community and the New York Tech Party Community. I have asked myself as an examination network and as a member in a significant number of these exercises: are these exercises really a network? What is the limit between normal social events/get-togethers/gatherings and the network? The greatest distinction is that the occasion is useful for individuals to assemble an individual 1: 1 relationship. There might be much more. Then again, the intensity of the network lies in aggregate character. We view ourselves as a gathering having a place with one gathering and we confide in one another over the normal level. Our exercises are little, however the network is large. As an augmentation of the occasion insight, I made a Slack people group. Emotionally supportive network consistently. Any female business visionary or financial specialist is welcome. In spite of the fact that the historical backdrop of this network is just three months, intrigue and cooperation was brilliant. As we study the necessities and requirements of this network, we will proceed to adjust and advance and keep on giving assets, data and availability on the web. How about we join our locale. Our message network has more than 7,500 individuals, and we have another Discord channel with in excess of 1,000 individuals. On the off chance that you need to enroll on Slack (12,000 clients and engineer network landing page), if it's not too much trouble use @ thisis to send email address to wire. The enrollment of the Public Slack is as yet shut. For more significant declarations on Enigma, follow this blog and our Twitter. At the point when we manufacture arrangements and stages to enable us to develop, our prosperity is firmly identified with our locale backing and awareness. We will effectively share the most recent data on the network and news and advancement consistently. You can assist us with publicizing our task and vision on your organization. MRSA disease was initially restricted to clinics and unique nursing home, particularly individuals who are powerless in the insusceptible framework. Since the 1980s, network type cases and scourges have likewise been accounted for. The cases acquired in the network are cases not identified with hospitalization or dialysis, medical procedure or catheterization in the previous year. These contaminations as a rule happen in other sound individuals and are probably going to be restricted to skin diseases. Notwithstanding, over the previous decade, the expanded pathogenicity of MRSA microbes has brought about more genuine, in some cases lethal network contaminations. As of late, MRSA has been found in consumable creatures, and a few episodes are "food prompted" or foodborne. In one such flare-up, contaminated individuals created common manifestations of foodborne illnesses, for example, regurgitating and stomach cramps.>GET ANSWER