E-R modeling & Normalization

 

Your task is to construct an E-R diagram and the resulting normalized tables to solve the scenario below. You
should present your results beginning with a Conceptual ERD (your initial impression of the scenario) and the
corresponding Dependency Diagrams. From this continue to normalize until you have a complete set of related
tables.
Your task is to develop the database design for a business that has multiple stores. They would like to be able
to track the sale of products to customers, as well as inventory level per store.
Data must be captured to identify customers (name, address, phone number, email), products (price, type,
manufacturer), and store (name, address).
They also need to report on things like:
Sales per store
Sales per product
Stock levels
HINTS:
Begin by looking at the customer.
Customer …….. Products (1:M)
Take a top-down approach; start with E-R and move to attribute definition
Look for partial and transitive dependencies
Remember to make attributes as atomic as possible
Feel free to add any attributes you think are necessary
Requirements:
In this assignment, you are responsible for the following:
E-R diagram based on your initial view of the database Dependency diagram(s) showing your entity definition
Entity definition; list all fields, primary key, and foreign keys
E-R diagram based upon your final (“‘normalized view”) of the database

 

 

 

 

 

Sample Solution

 

 

 

 

On Lying in Bed

GuidesorSubmit my paper for examination

chestertonLying in bed would be a by and large great and incomparable experience if just one had a hued pencil sufficiently long to draw on the roof. This, in any case, isn’t commonly a piece of the household mechanical assembly. I figure the thing may be made do with a few buckets of Aspinall and a sweeper. Just on the off chance that one worked in a general and skillful manner, and laid on the shading in incredible washes, it may dribble down again all over in surges of rich and blended shading like some weird pixie downpour—and that would have its inconveniences. I am apprehensive it is important to adhere to high contrast right now masterful structure. To that reason, without a doubt, the white roof would be of the best conceivable use; truth be told, it is the main use I think about a white roof being put to.

Be that as it may, for the delightful investigation of lying in bed, I may never have found it. For quite a long time, I have been searching for some clear spaces in an advanced house to draw on. Paper is excessively little for any evident figurative plan; as Cyrano de Bergerac says, “Il me faut des géants” [“I need giants”]. Be that as it may, when I attempted to locate these fine clear spaces in present day rooms, for example, we as a whole live in, I was ceaselessly disillusioned. I found an unending example and confusion of little items balanced like a window ornament of fine connections among me and my longing. I inspected the dividers; I saw them amazingly as effectively secured with backdrop, and I saw the backdrop as effectively secured with uninteresting pictures, all looking to some extent like one another. I was unable to comprehend why one subjective image (an image evidently totally without any strict or philosophical essentialness) should in this way be sprinkled all over my dividers like a kind of little pox. The Bible must allude backdrops, I think, when it says, “Utilize not vain reiterations, as the Gentiles do.” I found the Turkey cover a mass of unmeaning hues, rather like the Turkish Empire, or like the sweetmeat called Turkish Delight. I don’t actually have the foggiest idea what Turkish Delight truly is, yet I guess it is Macedonian Massacres. Wherever that I went pitifully, with my pencil or my paint brush, I found that others had untouchably been before me, ruining the dividers, the drapes, and the furniture with their adolescent and uncouth plans.

No place did I discover a genuinely clear space for drawing until this event when I delayed, past as far as possible, the way toward lying on my back in bed. At that point the light of that white paradise broke upon my vision, that broadness of insignificant white which is in reality nearly the meaning of heaven, since it implies virtue and furthermore implies opportunity. Yet, oh, similar to all sky, since it is seen, it is seen as unattainable; it looks more severe and more far off than the blue sky outside the window. For my proposition to paint on it with the bristly finish of a floor brush has been debilitated—don’t worry about it by whom; by an individual suspended from every political right—and even my minor proposition to place the opposite finish of the sweeper into the kitchen fire and go it to charcoal has not been surrendered. However I am sure that it was from people in my position that all the first motivation wanted covering the roofs of royal residences and churches with an uproar of fallen blessed messengers or successful divine beings. I am certain that it was simply because Michael Angelo was occupied with the old and decent control of lying in bed that he at any point acknowledged how the top of the Sistine Chapel may be made into a terrible impersonation of a celestial dramatization that must be acted in the sky.

The tone presently regularly taken toward the act of lying in bed is double-dealing and undesirable. Of the considerable number of signs of advancement that appear to mean a sort of debauchery, there is none more threatening and hazardous than the celebration of incredibly little and optional issues of lead to the detriment of extremely extraordinary and essential ones, to the detriment of unceasing ties and awful human ethical quality. In the event that there is one thing more regrettable than the cutting edge debilitating of significant ethics, it is the advanced fortifying of minor ethics. Hence, it is viewed as all the more shrinking to blame an individual for awful taste than of terrible morals. Tidiness isn’t beside purity these days, for neatness is made fundamental and authenticity is viewed as an offense. A writer can assault the establishment of marriage inasmuch as the person doesn’t distort the habits of society, and I have met Ibsenite cynics who thought it wrong to take lager, however option to take prussic corrosive. Particularly this is so in issues of cleanliness—prominently such issues as lying in bed. Rather than being respected, as it should be, as an issue of individual accommodation and alteration, it has come to be viewed by numerous individuals as though it were a piece of basic ethics to find a good pace the morning. It is upon the entire piece of handy insight—however there is no positive aspect regarding it or awful about its inverse.

Grumpy persons find a good pace the morning—and thieves, I am educated, find a workable pace previously. It is the extraordinary hazard of our general public that every one of its systems may develop increasingly fixed while its soul develops progressively flighty. An individual’s minor activities and courses of action should be free, adaptable, imaginative; the things that ought to be unchangeable are their standards and goals. Yet, with us, the switch is valid; our perspectives change continually—yet our lunch doesn’t change. Presently, I should like individuals to have solid and established originations, however with respect to their lunch, let them have it in some cases in the nursery, once in a while in bed, some of the time on the rooftop, in some cases in the highest point of a tree. Let them contend from a similar first standards, however let them do it in a bed, or a pontoon, or an inflatable. This disturbing development of good propensities implies a too extraordinary accentuation on those ethics that unimportant custom can guarantee, it implies too little accentuation on those excellencies that custom can never fully guarantee, unexpected and astonishing temperances of propelled feel sorry for or of motivated sincerity. If at any time that unexpected intrigue is made to us, we may come up short. An individual can become acclimated to finding a good pace AM. An individual can’t become acclimated to being singed for their assessments; the principal explore is regularly deadly. Let us give somewhat more consideration to these potential outcomes of the gallant and surprising. I dare say that when I escape this bed, I will carry out something of a practically horrible uprightness.

For the individuals who study the extraordinary craft of lying in bed, there is one decided alert to be included. In any event, for the individuals who can accomplish their work in bed (like writers), still more for those whose work is impossible in bed (as, the expert harpooners of whales), clearly the guilty pleasure must be exceptionally periodic. In any case, that isn’t the alert I mean. The alert is this: on the off chance that you do lie in bed, be certain you do it with no explanation or avocation by any stretch of the imagination. I don’t talk, obviously, of the truly debilitated. Be that as it may, if a solid individual lies in bed, let the person in question do it without a cloth of reason—at that point the individual will find a good pace individual.

craftsmanship exposition, instruction paper, article about existence

 

This question has been answered.

Get Answer