Mind/Body Problem Essay

The psyche/body issue is the issue of determining the connection between the brain and body. Prior to facilitate clarification of this issue, it is essential to completely see each term as it is being utilized all through this paper. The brain, as I will call it, is authentic of the awareness of a person. This is to state that the piece of an individual which decides will and decision, the encounters and sensations are all things considered alluded to as brain. The body, on occasion more explicitly, the mind, indicates the physical parts of an individual. This is comprehensive of the physical mass, neurons responsiveness to boosts, and physical area. Presently, with an increasingly complete comprehension of brain and body, one can come back to the issue of the relationship concerning the two. One approach to see this subject is to consider it characterizing the relationship of mental states and mind (neural) states. While thinkers have not arrived at a conclusive clarification to this issue, the years possess gave plentiful energy to a couple of noticeable hypotheses to create. It might be felt that science could give a solution to our concern, however this isn't the situation. While science may give us understanding to various elements of mind expresses that correspond to mental procedures, it doesn't demonstrate how they are connected or why. This can be clarified through the perspective discernment. Science can give an away from of how the mind capacities; it can portray the sources of info and yields. Science may likewise be able to clarify what sentiments and feelings are. For instance, it might have the option to clarify gnawing into a late spring peach and depict the taste. Be that as it may, science can't encounter the manner in which a late spring peach tastes to me, as a person. It can't feel the manner in which I do at whatever point I consider my mom. This is the distinction as an outsider looking in context (the one in particular that science is genuinely ready to offer) and the primary individual point of view of the individual really encountering the circumstance. While it appears as if there is a causal connection between the brain and body, implying that the psyche influences the body and the body affects the psyche, the inquiry despite everything stays with respect to how this collaboration capacities and why. It is now that logicians give various answers for these inquiries. The dualist point of view offers that the psyche and body are two totally particular ontological substances, regardless of whether in sythesis, capacity, or cooperation. Alternately, the physicalist contends that the psyche and body are both logical in physical terms in light of the fact that there is nothing more to this world than the physical viewpoints. This is to state that the brain is of a similar stuff as the body in light of the fact that indeed, they are the equivalent. The psyche is just a procedure of the physical cerebrum. Straightforward Jackson uses a psyche test in his composition, What Mary Didn’t Know to challenge this idea of physicalism. Jackson requests that his perusers envision a lady named Mary who is restricted to a high contrast room. She is educated through a highly contrasting screen everything that there is to think about the physical idea of the world. As indicated by physicalism, she knows everything to know. In any case, one day Mary is taken outside of the high contrast room. As of now, she will realize what it resembles to see and experience the shading red. As indicated by Jackson, Mary discovers some new information; something well beyond every last bit of her physical information on the world. If so, that would bring about the way that there are a few things on the planet that are not physical things. Jackson’s contention might be organized in a manner that unmistakably characterizes his point. Mary knows everything physical there is to think about others. Mary doesn't have a universal knowledge of others. It follows that there are certainties about others that escape the physicalist’s story. Using the information contention, Jackson affirms that since Mary realized what encountering the shading red resembles, that she discovered some new information and picked up information about something outside the physicalist’s contention. This, in Jackson’s point of view, ruins physicalism supposing that while operating at a profit and white room Mary knows each physical reality, at that point she should know it all. In any case, by increasing another experience and picking up something outside of the room, at that point there are things that can't be clarified truly. Jackson contends that learning on a highly contrasting screen isn’t enough to find out about mental life. It isn't sufficient to find out about the qualia of encounters. These qualia allude to the individual subjective sentiments of an encounter. For instance, what tasting a ready summer peach is really similar to encounter. In this manner there must be something more to the story. Taking an alternate view, Colin McGinn offers his point of view on the psyche/body issue in his composition, Can we Solve the Mindâ€Body Problem? McGinn recommends that no, we can't unravel the psyche/body issue and in that lies our answer that we ought not be stressed over this issue since we will always be unable to illuminate it. McGinn maps out a few motivations to help his decision. He starts by clarifying why past endeavors of clarification have neglected to explain the psyche/body issue. McGinn states that past contentions utilize one of two strategies. The first is to fall back on the utilization of extraordinary methods. McGinn says this is similarly as â€Å"extreme as the problem†, implying that demonstrating this reason is similarly as troublesome as the end it is intended to help. Besides, he says that different contentions utilize the utilization of clarifying mental states through physical properties of the mind. This demonstrates hazardous also. McGinn offers an alternate road, it is the thing that he calls, psychological conclusion. He accepts that there is a characteristic clarification for the manner by which the psyche and body collaborate with one another yet that we, as people, are shut to its clarification. He proposes his contention along these lines: Human personalities are like natural bodies in which that they have various degrees of limit and psychological ability. Despite the fact that a psyche may not have the intellectual capacity to comprehend an idea, this would not suggest that the idea is false. He utilizes the case of the light range. While people can just view a little segment of the light range, it doesn't limit different levels. A similar guideline might be applied here. Besides, a thought might be totally intellectually shut if there is no chance of any psyche having the option to get it. Be that as it may, a similar standard of its fact esteem remains. McGinn contends that the brain/body issue is an issue that is totally subjectively shut to people. In this way, regardless of what headways in science or innovation that may happen, it will in any case never be sufficient to comprehend the psyche/body issue. This should give people some genuine feelings of serenity. McGinn says that there ought to be not have to stress over explaining an issue that can never be comprehended. Remembering McGinn’s worldview of thought, by and by consider Jackson’s article, What Mary didn’t know. While Jackson appears to offer a solid contention, McGinn may protest it based on his first reason. On the off chance that the human brain is psychologically shut to specific degrees of information, at that point it is outlandish for Mary to get the hang of everything there is to know in her highly contrasting room. Truth be told, it doesn't make a difference where Mary gets her learning, she will never increase total information. Her cutoff would arrive at the degree of information wherein her mind is subjectively open to her. While the facts confirm that Mary would have the information on everything that people might comprehend; she despite everything isn't all-knowing. By denying Jackson’s first reason, it renders his contention invalid.

Christian Thought, Greek Philosophical Thought, Hindu Tradition Research Paper

Christian Thought, Greek Philosophical Thought, Hindu Tradition - Research Paper Example Subsequently finding new roads of folklore and knowing impossible to miss yet astounding realities about the accepts of Hindus. On the morning of November first 2011, I gathered my packs and was out for an excursion to New York, presumably the most occupied and populated urban areas of USA. My excursion principally planned for visiting the different Hindu sanctuaries in the city and writing my encounters as this was my field work. I got a rundown of the Hindu sanctuaries as a piece of my task that I needed to cover. My first visit on second November, 2011 was to the Ganesha Temple, situated in 45-57 Bowne road, New York. It was little casing sanctuary, was finished in the underlying long stretches of 1977. I at that point came to become familiar with the divinity revered was that of the elephant god, who is known as Ganesha. The symbol of the god is perfectly dressed. According to the customary Hindu conviction, Lord Ganesha's endowments are essential for accomplishment in every sing le everyday issue. So Ganesha puja should be a fundamental part, before any Hindu strict action. Usually did be it a marriage or some other custom. According to Hindu Mythology, Lord Ganesha is the primary child of Lord Shiva and Universal Mother Goddess Parvati and is an epitome of information. According to customary conviction, Lord Ganesha was decapitated during the hour of his introduction to the world, anyway rather than a human head his head was supplanted by that of an elephant. In spite of the way this is a fanciful tale, what truly flabbergasts me is the means by which the story is blending with such huge numbers of Hindus slants and how it has a significant impact in transit of life of a faithful Hindu. The every day customs of Pujas are performed with most extreme earnestness and full dedication, both in the sanctuary, and as additionally I came to learn, as a day by day lifestyle of numerous Hindus here in New York, despite the fact that they are miles from their natio n of origin. Notwithstanding the day by day customs, the end of the week administrations are led by volunteer clerics. Basically, the sanctuary follows the direction set down in the Hindu sacred texts for sanctuary building, otherwise called the Agama Shastra in Sanskrit. Agama Shastra additionally gives a takeoff from the customarily acknowledged methods of strict direct and love that has been set down in the principle assemblage of Hindu sacred texts of Vedas, Upanishads, Epics and Puranas. My following visit was to the Om Sai Mandir, situated in the core of the city at 45-11 Smart Street. c. The sanctuary is open from early morning till late night, and contains the icon Sri Sai Baba. All guests were free to visit the sanctuary and look for the Baba's favors, regardless of whether they were ardent supporters of the Guru or not. Sai Baba is a genuine figure, who lectured his confidence to his supporters during authentic occasions. This is rather than Lord Ganesha, whose starts from Hindu folklore. He was a profound holy person, a fakir (homeless person). His supporters accept that he helped his counterparts and pupils with his supernatural occurrences. The Baba is a Hindu Guru, a spiritualist altruist just as instructor of strict ideals. In the strict lessons of the Baba, one observers a mix of Hindu and Muslim convictions and lifestyles. Along these lines, similar to the Sufi Movement, the proclaiming of the Baba proclaims the conjunction of the two Hindus and Muslims strict musings. Shockingly this is the spot one can say, this sanctuary possesses a place of significance for individuals of both the beliefs who live here in New York, be their inception in India or in different nations of the sub-landmass like Bangladesh and Pakistan. Seeing the characters and beliefs of strict pioneers

Dietitian Resume Examples, Template, and Resume Tips

Dietitian Resume Examples, Template, and Resume Tips Dietitians, also commonly spelled as dieticians, are people whose job description is to analyze people’s eating habits and help them improve.In the world where people are getting more and more obese, and where we suffer from more health issues that directly come from the food that we eat and how we eat it, the need for dietitians is dire.We need them to teach us about things that we probably didn’t even know were bad for us, and to help us become healthier and happier by changing our diets and the way that we feel about food.Of course, as with most other jobs, finding a position in this field that satisfies you is going to be tough.But the one thing that we can without a doubt say is the key to your success is an excellent resume.It needs to show all the right skills and descriptions about you that will help you get the job of your dreams, and we’re going to help you write it, whether you’re a clinical dietitian or any other one.First things first, let’s look at some exampl es.Community Dietitian Resume Example Right Clinical Dietitian Resume Example Right Create your own resumeThe two examples that we have here for you are how you should aim for your dietitian resume to be like.Don’t be fooled, they look simple enough when you first glance at them, but there’s more to every word written on that paper.And, as we said before, we’re going to help you figure it out.Follow the guide that we prepared for you in the rest of this article while you’re writing your resume to maximize your chances of success.Also, use our resume templates to create easy and unique resumes that will certainly make you stand out from the rest.HAVE YOU BEEN MAKING MISTAKES WHILE WRITING THE PERSONAL INFO SECTION OF YOUR DIETITIAN RESUME THAT YOU WEREN’T EVEN AWARE OF?This section of your resume is the least stressful one, but there are still things that you might have been doing wrong all along and we have some tips for you.This is the section that the recruiters are going to use to get in touch with you and it should only contain some of the most basic information about you.Firstly, your name. It should be written on your resume like it’s the title of it â€" which it is.Use big bolded letters, but don’t make your name so big that it draws too much attention away from the more important stuff, like your experience and skills.It’s enough to only write your first and last name on your dietitian resume. Your middle name is not the type of information that the company that you’re applying to work for needs.Also, don’t write any nicknames, just your full first and last name. Writing your nickname would make you seem unprofessional.Michael Johnson RightMike Johnson WrongAn important thing that you should know is that while adding a photo to your resume is optional it’s usually not advised. This is because the recruiters might make assumptions about you based on the photo that you submit.The way that you look doesn’t determine your qualities as a dietitian, but if you do want to add a photo on your resume make sure that it’s high-quality, that you’re the only person in, that you look professional and that you’re smiling.The next item is your phone number, which you have to write correctly. This is, along with your email address, the most likely way that you’re going to be contacted for a job interview.However, stay safe and remove your phone number and home address from any examples of your resume that you keep online, but don’t forget to add them to the versions that you’re sending out.Also, your full address isn’t a must, if you want to you can just write the name of the city and state that you live in.Your email address should show that you’re a professional and not a child, so any address that doesn’t have your name in it is a definite no.michaeljohnson@gmail.com Rightsikeitsmike@gmail.com WrongWhen it comes to social media that you add to your resume, there’s no need to submit any other of your profiles except for LinkedIn. It really is the only platform that is crea ted for professional people, and you should keep it looking like that.But, you should still clean up all your other profiles even if you didn’t submit them on your resume because companies have a way of finding them and it could possibly ruin your chances.If you have a blog where you write about diets and nutrition, or a link to research or articles that you did, if you ever wrote any, you can also add a link to them in the social media subsection of your dietitian resume.HOW TO PUT ALL THE RIGHT INFORMATION IN THE SUMMARY OF YOUR DIETITIAN RESUMENow we get to the more complicated things.From now on you have to fully commit to making your resume the best possible, because there’s no way to know what part of it the recruiters are going to find to be most interesting.Especially if they spend only six seconds reading it.This means that they don’t thoroughly read it, but look for things that stand out or that they know they’ll need.The summary part of your resume is the place wh ere you put all the most important information about you that you can see on the other parts of your resume, but so that it fits in three to six sentences.This also means that you should leave the writing of this section for the end since it’s easier to write a review when you have all the info written in front of you.Regardless, there are some things that you must mention in the summary:The number of years of experience that you have as a dietitianThe exact name of your job titleYour certifications, which you have if you want to work as a dietitianSome of the most extraordinary things that you accomplishedThe things that you’re an expert inThe job position that you’re looking forBelieve it or not, all of this can fit into three to six sentences.You should also follow this list in order, more or less. You can start with the years of experience, job title, certifications and the things that you have the most expertise in.SummaryA determined and effective registered dietitian wi th over 6 years of experience in assessing, diagnosing, and treating nutritional problems. RightAfter that, add some accomplishments that you think make you stand out from the rest.Are you an expert in some areas? How many meal plans have you created? Were your patients satisfied with the results?Use some hard numbers as proof of your skill. You can also add some job-specific terms to it.Summary (cont.)Expert in creating nutritional plant-based diets that still fill out all the criteria needed to help patients with their problems. Created over 400 detailed meal plans with a success rate of 95%. RightThe last sentence should be more personalized. You should describe the position that you’re looking for and mention the name of the company that you’re applying to work for. Needless to say, this part should be different on every resume that you send out.Summary (cont.)Used to working in fast-paced hospital environments, Michael is seeking the position of a clinical dietitian. Rig htWHAT KIND OF EXPERIENCE IS IMPORTANT TO THE RECRUITERS?This is arguably the most important part of your resume.Every employer wants to hire somebody who has more experience than the average candidate, but we’re going to teach you how to write this section even if you have no experience in the field.Before you start, let’s set some ground rules. The only jobs that you should mention in this section are the ones that have something to do with the job of a dietitian or that have skills that can be transferred to it.This means that the fact that you were a lifeguard in high school is great for you, but will just be unimportant information on your resume that will just take up space.Now let’s talk about the format. The best one that you can choose if you’re an experienced dietitian is the reverse chronological order. This way your most recent and probably most relevant experience is listed at the top of the list, and so on.However, if you don’t have experience or have some ga p years it would be better if you used the classical format where you just list your most important accomplishments and duties first.Always mention the years that you spent at the company, the name of the company and your position in it when writing your resume.After that, you should add the duties that you had, but turn them into accomplishments.Write the things that will make you stand out from the rest and add hard numbers to back up your skills. If you had an amazing success rate or customer satisfaction, or if you wrote a book or conducted research you can out it in this part of the section.Hard numbers are proven to maximize your chances of success when it comes to getting to the next stage.If you don’t have any experience, mention your internship and any volunteer practices that you were a part of. Only list the things relevant to the job of a dietitian.Don’t shy away from using professional language on your resume to show that you know your stuff. Get into more detail if you want to. Right WrongAlong with your professional work experience, you should also add some information about your internship and your duties there.Every dietitian has to go through an internship in a health facility or a similar place before they’re even allowed to do their job.So, write the name of the facility where you did your internship and when you did it, and add some duties that you had while you were working there.And you’re good to go to the next section!DOES THE EDUCATION SECTION OF YOUR DIETITIAN RESUME HAS ALL THE INFORMATION THAT YOU NEED?Every dietitian has to go through a lengthy and hard process of getting a bachelor’s diploma in college that’s related to food, diet, and nutrition.You can’t apply for a job without the diploma. The job of a dietitian is an important one and should be left to the actual professionals because the health of people isn’t something that can be taken lightly.When listing your degree in your resume start with the highest-ranking one.That mean s that if you have a master’s degree there’s no need to also list your bachelor’s unless it was in another field or you got it at another university.Also, because you have to have some sort of college degree to be a dietitian, you can leave out your high school diploma from this section, unless you had some outstanding accomplishments that have something to do with being a dietitian even in that period of your life.The things that you should write about your degree are: the years of schooling, the level of your degree, the name of the university that you attended, and any special accomplishments.Like this: RightIf you’re a student who still hasn’t finished schooling and you’re applying for an internship, you can list your college degree like this: RightThe most important things in this section are the certifications. Write the name of the certification, and where and when you took the test and got it.Every dietitian has to be at least an RD, and you can list them like this:Licensed Dietitian Nutritionist (LDN) â€" Board of Dietetics/Nutrition, 2010Registered Dietitian (RD) â€" Commission on Dietetic Registration, 2010 RightTHE MOST IMPORTANT SKILLS TO MENTION ON YOUR DIETITIAN RESUMEThis is the part of your summary that takes up the least space but still has some important information.The skills that you have mostly determine whether you get the job or not. They are the most valuable asset that someone can bring to the company, so they’re always looking for skilled people to improve their work.You should write this section in bullet-point format. Keep it short and simple, and pick only the most important skills that you can use as a dietitian.Also, know the difference between soft skills and hard skills.Soft skills are sk ills that aren’t specific to any job, but they’re still valuable.The examples of soft skills that you should have as a dietitian are communication skills, problem-solving, honesty, teamwork.The hard skills that you’re going to need as if you want to get a job as a dietitian are more specific, like for example the knowledge of nutritional values of different foods, creating plant-based diets, analyzing data, and so on.Hard skills outweigh soft skills, so make sure to put more of them on the list.This is how your skills section is supposed to look like:SkillsNutrition EducationProblem-solvingExtensive knowledge of nutritional valuesExperience in creating adequate meal plansPlant-based dietTeamworkAnalyzing Data RightSkillsTeamworkMeal plansPhotoshopMS Office WrongTIPS TRICK FOR CREATING THE BEST DIETITIAN RESUMEUse a template â€" We have a bunch of templates on our resume builder that is going to make your life easier and make your resume stand out from the rest.Don’t be di shonest â€" Don’t go into this thinking that white lies are going to get you the job of your dreams and that you won’t get in some sort of trouble sooner or later. Working with patients is a serious business.Adaptability â€" Change up your resume for every different company or position that you apply to. Don’t be too lazy to do it, it will pay off in the long run.Length â€" Ideally, your resume should be one page long. The length of the resume doesn’t determine its quality.Choose the font carefully â€" We’re all drawn to fonts that look special but the truth is that they’re hard to read. Pick something that’s not going to make recruiters dump your dietitian resume in the trash just because their eyes hurt from treading it.Word or PDF? â€" If it isn’t specified in the ad send the PDF file, but keep all the other options ready just in case.The heading of your resume is NOT Curriculum Vitae â€" The recruiters know that it’s a resume and putting your name as the headin g is the much better option.Don’t get too personal â€" The only information about you that you need in the personal section of your dietitian resume is the most basic things. Anything more than that could get your employer to make assumptions about you and isn’t needed.Certifications â€" You have to have them as a dietitian and don’t forget to list all of them in the education section of your resume.Internships and volunteering â€" List these things if they had anything to do with the job of a dietitian, especially if you have no work experience.Check your grammar â€" This is a must! You can’t let some unprofessional mistakes slip up.Review â€" Take some time to step back from your resume and then look at it again to see something that you might have missed before. Or, give your resume to someone else that has a lot of experience with them, maybe they can tell you what you can improve.CONCLUSIONThis is the end of our step by step guide that will help you create the perfect d ietitian resume.Following these steps while writing your resume is guaranteed to help you maximize your chances of getting the job that you were always dreaming about.The most important things to remember are to be professional, only mention the skills and accomplishments that have something to do with the job of a dietitian, and don’t be dishonest.Good luck! Create your own resume

My Twelfth Summer By Sarah Gervais - 1525 Words

My Thirteenth Summer Sarah Gervais Reflecting on this event many times in my past, I have called it an innapropriate romance, I have called it â€Å"an unprofessional relationship†. However, most frequently, I have called it â€Å"the thing that happened that summer.† As in — remember the thing that happened that summer? What I never called it, for reasons similar to that of why I never made a fuss about it when it happened, was sexual abuse. To me, it was because it felt like an overly dramatic Dr.Phil-ization of what happened. The word â€Å"abuse† seems to imply that a victim was involved, and I have never considered myself much of one. Until now, I have been far too socially-conscious to confess the main reason I have never called it sexual abuse in spite of the fact that it was, in every sense of the word and from every clinical and psychological perspective. The real reason, is because I believed I might have asked for it. The summer camp season I turned 13, I went to a stay over camp for religious Jewish adolescents. I shaved my legs and wore a bra for the first time, still used tangle-free L oreal green apple spray in my hair, and shopped at the nearest La senza. I had my first summer romance a few weeks prior — a disheveled, freckly, brutish boy a year younger who took me for two kayak rides and then broke up with me, calling me a tease and, I was sure, ruining my romantic prospects until eternity. I turned from real life to fantasy life, and decided to brush off the

William Shakespeare s The Tempest - 1267 Words

Government legislation has always been a social topic throughout the years. Thus, the bond in which a government creates with its people is vital in order to create a functioning society. This has led many scholars to provide social commentary on government legislature, allowing complex issues to be portrayed in different mediums, generating a greater audience. During the Enlightenment Era, William Shakespeare’s writing were a form of social commentary on the English Government. Endorsed by the king, Shakespeare’s works told tales of tragedy and whimsy, incorporating both fiction and nonfiction elements. One trademark of Shakespeare s plays were the subtle allusions to the concurrent events in the English government. This is evident in†¦show more content†¦The purpose of revealing its metaphorical nature is to display the true purpose and meaning of Shakespeare’s famous final play. The play attributes supernatural powers to the Prospero, the protagonist, allowing him to be able to convey his actions and regain his lost dukedom. In The Tempest, there are various tricks and illusions that unravel on the island. In context to the era, magic and witchcraft were slowly displacing itself from the mainstream practices. Nonetheless, Shakespeare attributes this characteristic to Prospero. These conjurations all stem back to Prospero and his goal to returning things back to the natural order. In his time on the island, Prospero uses magic to bully the island and its inhabitants. These actions are abusive to nature. Prospero’s character contrasts that of other Shakespearean roles because his actions and intentions are selfish and controlling in nature. This is because his character is modeled after a selfish monarch. As previously stated, Prospero uses his power to manipulate people and events on the island. These acts of magic could relate those powers given to governmental legislation. Governments have always possessed the ability t o prevent social disorder through surveying and policing the public. Social commentary around the abuse of these powers root back to their origin. Similarly, Prospero appears as a king ruling over the island. Although merely illusions, these actions creates an unstable relationship with

Vignette †Creative Writing Free Essays

Standing there all alone wondering what to do and what I could see. Looking down at all the branches not even being able to see the soft green grass below me. I looked out into the distance thinking to myself I wish I was in a plane flying every day then suddenly my paranoid mother interrupted my marvellous thoughts. We will write a custom essay sample on Vignette – Creative Writing or any similar topic only for you Order Now Then I thought to what is it now, what could you possibly want now, â€Å"Get out of that bloody tree Michael what have I told you about climbing that tree you’ll fall out and crack your head open one day† oh that rant and rave again, I better climb down then before she bites my head off. I started to climb down the near tower of a tree, another plane flew past, so I looked up at the wonderful war bird an f-111 the thoughts were weighing up in my head wow I thought, oh shit as I cracked a branch and fell’ is this what it feels like to fly as the sharp and course edges ripped the skin of my legs. My thoughts were stoped with a hard and rather reliving thud as I hit ground, I then got up and thought stupid mother as ravines amounts of tears were relinquished from my eyes, that’s why you don’t climb trees said my mum as I slowly crawl up the hill. The long hair of my mother becomes more visible every step I take but to my surprise my mother’s face was not red with puffs of smoke but a sympathetic look was slapped over her face as she says are u ok Michael, I didn’t know what to do so I just walked inside with my caring mother behind me holding my shoulder. As I went to go to my room my mother suddenly told me to go have a bath and my mind was thinking no water, no not on my cuts, no that will cause more rivers of tears to come gushing from my face, no I said no then my mum came over with some green looking liquid I said to my mum what is that, as the soft words of my mother said this will make the cuts get better. I thought yes a success no more pain for me to endure, so I quite graciously swung out my legs for my caring mother to attend to my wounds like a nurse attending to a patient. What the hell are you doing, cutting off my foot for as I realised my mother was pouring the liquid over my cuts, she said it might sting a bit, oh by god it was stinging it just felt like she had dropped a cinder block on my leg. Finally the tears stoped and the pain stoped and I looked down at my leg and my mother was still pouring the acidic liquid over my leg and I thought yes the pains gone as I finally stopped balling my eyes out from my skull I asked my mum what was that thinking it was some magical liquid that could make any kid cry. She then replied to me that is alcohol it makes your leg better, yea right I thought as I jumped into the bath as quick as I could to wash it off before my leg was all burned off. Then as I emerged from the bath I stuck on some old clothes and thought to myself lets go clime that tree again then I thought no I never want my mother to use that furious concrete burning acid on my body ever again. Pondering what else can I do, then in the corner of my eye I spotted the piano in the corner of my eye, yes what a perfect idea as the sun started to retreat over the leg amputating trees, so I skipped onto the piano stool ad started tho produce my master piece. I didn’t really like the long black keys I only hit the white ones on the edge of the piano so I stared to hack at the keys in some sort of order pleasing myself but that became pretty boring so I pondered what I could do next I started rocking on my stool back and forth back and forth but suddenly there was no forth as I fell backwards into that flying feeling again. No no no I thought, smack as my mum hit me across the head then I thought here comes another lecture not to rock on the stool but then this pulse of pain stuck my thought out of my head ripping through the back of my head. I looked around at the floor red hmmm as I realised oh no mums going to put that liquid on my head and burn my head off the thoughts came rushing out of my head in streams of water again. How to cite Vignette – Creative Writing, Papers

Study Sheet Carmax Analysis free essay sample

They reconcile conflicting performance goalsThey combine low cost, high quality(because of checks and 125 points system), etc. xi. They reconfigured value chainSell used cars differently than any other past used car dealer f. What are their competitive advantages xii. Ability to provide high degree of customer satisfaction with the car buying experience xiii. Competitively low prices xiv. Breadth of selection of the most popular makes and models xv. Quality of vehicles xvi. Exclusive information systems xvii. Locations of retail stores 3. Cost Advantage g. Drivers xviii. Economies of scale xix. Economies of learning xx. Production technique xxi. Product design xxii. Input costs xxiii. Capacity utilization xxiv. Residual(other) efficiency 1. All of these are described in the powerpoint, study notes and lecture notes h. Analyzing Costs(SHOW ON SLIDE 15 OF PPT#9) xxv. Determine value chain(done below) xxvi. Establish their relative importance in total cost of product xxvii. Compare costs by activity xxviii. We will write a custom essay sample on Study Sheet Carmax Analysis or any similar topic specifically for you Do Not WasteYour Time HIRE WRITER Only 13.90 / page Identify cost drivers xxix. Identify linkages xxx. Identify opportunities for reducing cost 2. Potential ideas on slide 18 of 18 a. Corporate Re-structuring . Plant closures ii. Outsourcing iii. Delayering and cuts in administrative staff b. Business Process Re-engineering iv. Combining several jobs into one v. Steps of a process combined in natural order vi. Minimizing steps, controls, and reconciliation vii. Use case managers as single points of contact viii. Hybrid centralization/decentralization i. Value Chain of CarMax xxxi. Even though the used car industry is extremely competitive and price sensitive, CarMax does well because it has huge economies of scale. With large inventory, the company can spread its operating costs consistently across individual dealerships. CarMax adds value in five categories. xxxii. Acquiring Cars  Ã‚  Most of the cars are acquired through trade ins. This creates a high-quality inventory. CarMax offers a while you wait appraisal and gives you an offer that is valid for seven days. They also acquire cars through dealership relationships such as with auction houses. xxxiii. Managing Inventory  Ã‚  This is the companys real competitive advantage. All inventory goes through a standardized internal inspection process. Cars are separated into CarMax and Valumax categories and sold through channels focusing on different categories of quality and price. xxxiv. Operating Stores  Ã‚  Management policies guarantee a consistent customer experience across the company and inventory is shared nationwide. xxxv. Marketing and Selling  Ã‚  Website searching, no haggle price policy, and inspection guarantee are the key components of the companies value added strategy. xxxvi. Services  Ã‚  The company differentiates itself from smaller dealers by offering financing, appraising, repairs, guarantees and warranties for every sale. xxvii. The process of inspecting and guaranteeing the quality of the cars CarMax re? sells adds considerable value to the companys brand. This type of service is not likely to be found in other dealerships. The amount of resources that go into the value? chain activity of managing and sorting CarMaxs inventory is difficult to implement, and hard to imitate. While CARFAX Reports offer the same assurances of quality, they cannot offer the other benefits such as auto service and repairs, warranties and financing. j. Segmentation xxxviii. Middle and upper middle class xxxix. Fullnest(2), Fullnest(3) l. Fulfiller, strivers and makers 4. Differentiation k. Differentiation of CarMax xli. Car Max wants to differentiate themselves through exceptional customer service xlii. Car Max also wants to create superior efficiencies through use of standardized operating procedures l. Differentiators xliii. No haggle policy xliv. 125 point inspection system xlv. Easy financing xlvi. Repair and reconditioning of vehicles xlvii. Guaranteed quality xlviii. Carmax. com m. CARMAX nature of differentiation- Mostly intangible (unobservable but relating to image, status, exclusivity, etc. Like most dealerships n. Demand Side Differentiation Potential: Look over slide 10 of 19 on PPT#10 o. Supply Side Product Attributes and Positioning: Look over slide 11 of 19 on PPT#10 p. ANALYZING THE VALUE CHAIN xlix. Construct the value chain for the firm(above) and the customer(create) 3. FIRM(ABOVE) 4. CUSTOMER(BELOW) c. A customer  value chain  is a business concept that represents the creation of value for a customer. It is similar to the supply chain, which charts the various stages of production and supply from raw materials to the sale of the final good to the end user. The big difference is that while a supply chain often measures costs, the customer value chain is based on the increase in value to the end user. Another interpretation of a customer value chain puts the emphasis on steps taken to retain existing customers. d. One example of the difference between simple  supply chain analysis  and a customer value chain is delivery of a bed. From a purely supply chain perspective, the delivery is a relatively small factor: it doesnt make any tangible change to the bed itself, and for a large company with its own delivery network, the costs are relatively low. From the customers view, however, the value of the delivery is high. Most customers dont have the facility to transport a bed and without a delivery service; they would be left to choose between the bed being useless to them, spending the time money to hire a self-drive van, or paying a high cost to have a third-party company pick up and transport the bed. l. Identify drivers of uniqueness in each activity li. Select the most promising differentiation variables for the firm lii. Locate linkages between the value chain of the firm and that of the buyer

Marvel Case Study free essay sample

Selling their bonds straight away; 2. Voting in favor of the Perelman’s reorganization plan; 3. Voting against the Perelman’s reorganization plan and ? enforcing Carl Icahn’s initial reorganization plan from December 10, 1996; ? Chapter 7 – liquidation. As soon as Marvel’s management files a petition for relief with a bankruptcy court an automatic stay goes into effect. Marvel’s management then continues running the company and has the exclusive right to propose a reorganization plan within 120 days. This plan will be voted on by all the claimants and if at least ? f them vote in favour of the reorganisation plan, it is accepted. If the plan is not accepted within 180days, creditors can propose their own reorganization plan or choose to liquidate the company as seen in the last option mentioned above. In case of the first option being realised, public debt holders sell their bonds at then (31/1/1997) prevailing prices (Exhibit 6). Face value ($ millions) Marvel Holdings Marvel Parent Holdings Marvel III Holdings 517. We will write a custom essay sample on Marvel Case Study or any similar topic specifically for you Do Not WasteYour Time HIRE WRITER Only 13.90 / page 4 251. 7 125. 0 Market Market price on value 1/31/97 ($) ($ millions) 0. 75 90. 545 0. 14 0. 139 35. 238 17. 375 Collateral shares (millions) 48. 0 20. 0 9. 3 Value per collateral share ($) 1. 886 1. 762 1. 868 Table 1. Payoffs in case of selling bonds. The value per collateral share can be calculated by dividing the market value of the share by the number of collateral shares. In this case Marvel Holding public debt holders receive $1. 886 per collateral share, Marvel Parent Holdings debt holders receive $1. 762 per share and Marvel III Holding debt holders receive $1. 868 per collateral share. In case ? f the claimants vote for the restructuring plan proposed by Perelman, there will be 427 new shared issued (in addition to the 101. 8 shares already outstanding), for which there will be a cash investment of $365mln made into the company. $326. 8mln of these $365mln will be then paid for acquisition of Toy Biz, which leaves the company with a number of shares of 511. 8mln and cash holdings of $38. 2mln ($365mnl-$326. 8mln). The price of the old shares at the time was $2; the new share price would therefore be $1. 11 (365+2*101. 8)/511. , which is less than what debt holders would receive in case of immediate sale of their bonds. In case, the claimants vote against the Perelman’s plan, they will be offered to vote for the Icahn’s plan, in which case the new share price, depending on the rights offering price (p r), would be p=(101. 8*2+350)/(101. 8+350/ pr ), where pr should be smaller than 2. In case p is more than the price the debt holder would get from the sale of the bond, they will vote for Icahn’s plan, otherwise, they will opt for selling the bonds right away. 1- The last option, which is liquidation (Chapter 7), should go into effect when all the abovementioned options have failed. According to Bear Stearns analysis, Marvel is worth more as a going concern then in case of liquidation. Based on the liquidation scenario, Exhibit 8, private debt holders, mainly banks, recover 69 cents on the dollar face value, whereas public debt holders, who hold unsecured claims, and equity holders, who according to the absolute priority rule are junior to all other creditors, get nothing. That is why, from a perspective of a public debt holder it is more profitable to vote in favour of the reorganization plan proposed by Carl Icahn (or sell the bonds, depending on p). However, secured claimants may have an incentive to vote against because in case of liquidation they recover approximately 70% of their claims and one should keep in mind that the longer the restructuring process lasts, the less valuable the enterprise and its assets become. -2-

Led Zeppelin essays

Led Zeppelin essays Led Zeppelin was one of the greatest rock bands ever. Their biggest hit Stairway to Heaven, is one of the best rock songs of all time, also. There were four members in the band: John Bonham, John Baldwin, Jimmy Page, and Robert Plant. Jimmy Page was born on January 9, 1944 in Heston, Middlesex U.K. His mother was a doctor's secretary and his father was an industrial personnel officer. In his early life he live on his uncles farm in Northamptionshire, then later his family moved to Epsom, Surrey when his was eight. His life was basically normal, then at twelve he heard Elvis Baby Lets Play House and it change his life forever. He picked up a guitar and some lessons and he was set. He continued to play and in 1965 in was asked to join the Yardbirds (later renamed Led Zeppelin), he first declined and then later joined. In 1968 the Yardbirds broke up and Jimmy had it put together a new band and thats how Led Zeppelin was formed. After Led Zeppelin broke up Jimmy Page continue in playing guitar for many years and still today. (led-zeppelin.org) John Bonham was born on May 31, 1948 in Redditch, Worcestershire UK. His parents were Jack and Joan. He also had two other siblings Michael and Debbie. When he was young he would beat on his moms pots and pans. At the age of ten he got his first snare drum and then at fifteen he got his own drum kit. When he was seventeen he married Pat, who he met at a dance. John played in several bands, and then in August of 1968 Jimmy Page and Peter Grant went to see him play and he accepted the position as drummer for Led Zeppelin. After being with Led Zeppelin for twelve years he died on September 25, 1980 in Windsor, England after a night of heavy drinking. (led-zeppelin.org) John Baldwin was born on January 3, 1946 in Sidcup, Kent U.K. Both of his parents were musicians, his dad being a pianist and arranger for big bands and his mothe ...

Effective communication in organization Article Example | Topics and Well Written Essays - 250 words

Effective communication in organization - Article Example ional) communication is important to enhance good working relations in the organization which in turn translate to the achievement of the goals and objectives set. Organization capabilities are only achieved in an environment where healthy communication and relationship between individuals is enhanced. In the articles, the SMCR model is emphasized. The SMCR means that there should be a good channel (C) for the message (M) to move from the source (S) to the receiver (R). In an organization therefore, there will be all forms of communication which range from formal to informal. In formal communication, the leaders in the organization design/develop strategies to be used in achieving the objectives. They then construct relevant messages and then using correct channels, they relay it to the members in the organization. Communication will therefore play a significant role in this process. Employees on the other hand mainly communicate informally with each other enhancing their ties in the organization. Both forms are equally important. The evolution of communication is also highlighted in the article especially with the developments in technology playing a significant role in the progress. Organizational communication is significant in developing its culture which plays a major role in achievement of goals

Emerging New HR Concepts Essay Example | Topics and Well Written Essays - 2500 words

Emerging New HR Concepts - Essay Example The structure of an industry has a major role in defining a company's competitive advantage in this global scenario. An industry is conceived as a group of companies that market products which substitute each other. The structure of an industry has a direct relation to its profitability. Service industry can be considered as a classic example in this regard. In the post liberalization and globalization era, the concept of outsourcing has gained more attention. Cost is playing a major role deciding the competitive advantage of an organization. Companies are thinking of different options to reduce cost and increase its competitiveness. Outsourcing of production and service has been considered as an effective way to reduce competitiveness. Companies in the western world have been outsourcing jobs and production facilities from their land to low cost areas such as India, Brazil, China and East Asian countries. With the industrialization process of the 20th century, salary levels and capital cost of Western countries had shoot up substantially and this had been eating up a major pie from companies' profit. There was no sign of reduction of cost and salaries. This has compelled corporates to think of other options. During 1980's companies had find East Asian and Latin American countries as a good destination for moving production and services. While companies in Western countries have good technology, better expertise, capital strength and understanding of the market, these countries provide low cost land, human resource and raw materials. Synergising both these strengths has given companies more competitive advantage in their domestic market. Their production cost has come down sharply with this move. It is considered that high skilled labour, highly professional management team, low cost work environment, best management and HR practices, innovation, understanding of the industry and secu rity measures are the major strengths of the organization in the globalised world. Most of these strengths are adopted by companies do to the particular character of the outsourcing industry. In the early 1990's the industrial scenario in developing countries was quite different from that of western countries. Here companies were least bothered of good corporate governance practices, HR management, cost, profitability, security and customer satisfaction. The state protective measures made the industry inefficient. Companies got huge subsidies for every thing and any thing. But with the entry of multi national companies to these markets, situation has changed drastically and a new corporate governance practice has been established. In the labour relation also there has been a paradigm shift in the past one and half decade. Technology has played a major role in changing labour outlook and mindset. Also the process of Globalisation, Liberalisation and Privatisation has played a major role in redefining the perception on labor. Today corporates and industry are keener on optimum use of labor and they are always thinking of new ways to improve efficiency and output. The increasing global competition has demanded new approach to the labor. There has been an increasing demand for skilled labor forces. The skill level of the workforce in developing countries was a major challenge for companies moving from western market to emerging

Database Management System for Car Company

Database Management System for Car Company STRATEGY ANALYSIS DESCRIPTION OF CURRENT BUSINESS ACTIVITIES INTRODUCTION DMC is a Dedicated cars company that is specialized in Car sales business, and it was established Four years ago in 7th May 2005, and its main name stands for Dedicated Motor Cars and its main division is in Tripoli Libya, it is a company with many high workers and skilled employees working on it as they are sharing the same ambition, and always aiming for the best in their business, in both to improve their employees skills and also to provide the best services to their dear customer. DMC is really working hard to achieve a new improvement in their business every year, also to get the most popular and successful cars to get them, and for the best prices to its customers, as they are also filling their case show with a good collection in each month. As for this month they got a very promising collection of new cars that just released this year, and old ones but got well comments from millions of people who tried them, this collection will be for this year as in this time its the companys season time for the business. Current System The current system of my company is going like this, each day we are improving, and as I can see now we are well known as 1 of the top 20 Private companies in Libya, and we are also known in the other continents as well. We are also not restrict with only 1 nationality as we are offering jobs, because our company contains employees from different nationality as we have some of them in the main division and some other are in our different offices around the globe. DMC has a good budget as overall, and it is improving, also the customers are so pleased with our services in general, and our economical prices. That includes that we are always taking care of our employees in terms of payment and to keep them improving by sending them to take courses in different kind of fields. Although we are doing a pretty good job in this business field and improving by a good rate percentage every year, but we are really facing some of the major problems in our business, the main problem is that we are facing a new changes and new challenges in our business, also we have other competitors companies in the countries we are doing this business and selling our cars and making our different services. Problem Background Effects of it So our main problem actually includes semi problems that we should take care of them so we can solve the main problem, which is we really need to move on with our services with the technology we are facing these days in doing those kind of business to make it better, faster, and easier. And 1st of all is our own system in the company, because it is still not well organized as an strong infrastructure and we also need a well studied design model for this infrastructure for our company. Thats where I planned to made a Special database system to our company, which will be including our employees, our daily customers for each season, and our sales of cars on this season on as well covered by the invoice section of the company, and some specific information about our shipment idea and its fee and coverage services. The good thing is that with this new system we will be able to make a clear and direct relational between all the sections mentioned above and make a really strong infrastructure for the company plus to be able to store information and data more sufficiently. In this segment I would like to give you an idea about the goals and aims that we are aiming to achieve and they are: Improve the business even much further, to reach a new level of development. Reduce the paper work as we had a lost of some data from time to time. To always keep up with the other contenders companies so we wont lose our customers. Secure our data in a sufficient way. Provide a system where it is easy to get data for any of our customers. Improvement of production to satisfy the customers needs. Easy access to database and information used by employees. Remove barriers to widen its production by improving sales procedure and reducing costs. Hardware and Software Necessity These are all the hardware requirements needed Minimum Requirements Processor 2 Gigahertz (GHz) Pentium IV-Intel processor or Higher. Memory 512 MB of RAM or Higher. Hard Disk 900 MB of available space required on the system drive, 4 gigabytes (GB) of available space capacity on the installation drive. Drive DVD-ROM or CD-ROM drive and Floppy drive Display Super VGA (1024 x 768) or higher resolution. These are all the software requirements needed Minimum Requirements Operating Systems Windows XP Service Pack Final, Windows Vista, or Windows 7 any edition with MS-Office. H I S T O R Y DMC Companys history is not that much as the company only established two years ago, but in those two years we can say that the company earned its name and make various successful that led it to earn a respectful history archive in the day it starts doing business till our day now. Specification for New System The main purpose from making this new application in my company is 1st to achieve the objectives that DMC is aiming to achieve, 2nd to make the business much easier for the customer and the employee as each of them will have the advantage of these kind of applications in our business. Also the cars sales section (which is the Cars Details) will be much more attractive this way, and as it shows all the possible information that needed at the same time. That goes for the employee and customers tables as well; they are helping the company over all by making it progressing even much faster and also to reduce the paper work. About Us table shows the company in a really short cut way, and its true words shows on this section, also for the producer of this application to have his word on that section. Also the shipment tables is an important section and it is one of the reasons to determine whether a certain car sales company is really know about its business and can keep up, or sadly but have no idea about this field of business as it helps a lot in showing exactly the steps taking to ship your car and to not need to discuss any of the employee about it because it is very clear. On the other hand, last one but not last, is Plate Info table, which holds all the plate number for the cars that have been purchased from our company, and also saving the numbers from the other cars for the customers that are ding services for their own car. BUISNESS ACTIVITIES OPERATIONS DESCRIPTION OF OPERATIONS Þ Assign an Employee to handle a certain invoice. Þ Check the Country of the Customer to make the delivery shipment service for his/her order. Þ Adding an Employee to the company. Þ Assign a Unique ID to a Customer. Þ Adding a new Car to the showcase. Operation Name: Assign an Employee to handle a certain invoice. Description: This operation handles the fact that when we are having a new invoice table, we hand it over to a certain employee, and a (certain) employee means that he/she is not busy with another invoice or another operation in the moment. Input: The assigned Employee must appear his/her unique ID number, along with his name, and should be clear to read. Output: The Employee will be responsible for that invoice, and handle its full data. ============================ Operation Name: Check the Country of the Customer to make a delivery shipment service for his/her order. Description: This operation handles the action when the Customer wants to make a shipment service for his current order and to make it to a certain country. Input: The Customer must give information about the destination (Country) area where he/she wants to deliver the order. Output: The Customer will be given an information about the shipment service such as the fee that known for that country. ============================ Operation Name: Adding an Employee to the company. Description: As DMC expanding greatly in the past years, we are making this issue more than usual lately, and it is about recruiting a new employee to the company, further adding his information to the database. Input: For this operation we need to have the new Employee Name, Age, Nationality, and his/her Date of Birth to be able to add him/her to our database. Output: The new Employee will be added to our database, and will be given a Unique ID number to be known as one of DMC employees. ============================ Operation Name: Assign a Unique ID to a Customer. Description: This operation deals with having a new customer and need to be having his/her information in our database to be given an ID number for easily checking the customer status when he/she makes more orders in the future. Input: To make this operation successful, we need to have basic information yet helpful for us such as Name, Age, and Contact number. Output: The Customer has been given a unique ID number. BUSINESS ACTIVITIES This section describes the operations of DMC Company which is as I mentioned before but in more specific it deals with car sales that the company get from other retailers which recently built up a really strong relationship with DMC and are getting the best deals to expand our business. So mainly DMC deals with customers with services, and we do car sale business, also we are very restrict with our system and the invoice we made are very clear for every car, further our employees are doing their best in every deal been made for each car. And more to mention here for our upcoming Database building is that we are going to build a new design system model that contains Cars, Employee, Invoice, Shipment, and Customer. Those Five elements that I mentioned above will be our main focus on this database design, as it is in general what DMC is is all about. For that matter here we are going to explain in details every Element we have for our Design Model, been explained by including its Attributes and a brief description about its main purpose. And every element will be known later on in the database description as Entity. Invoice Entity This entitys main purpose is to keep track of the sales, and for every deal that have been sold by whom as an employee and for whom as a customer, also it will display all the data necessary about the product (Car) AND ITS Unique ID, plus other major information such as total price and the invoice reset number, whats more is this entity acts as the main entity related to all the other entities as it is also related to the (Shipment) entity as it also saves the shipment number in the invoice paper. The Attributes that have been made for this Entity are: Invoice_Number, Customer_ID, Employee_ID, Shipment_Nmber, Total_Price, and Car_ID, and we will be talking about all the attributes for every entity in more details later on. Cars Entity This entity deals with all the cars that the company DMC stores, and contains all its details such as the car brand name, its color and the car ID, and the shipment number for every specific shipment that been made, along with the most important attribute for all the customers which is: the cars price. Employee Entity This entity here will be busy of containing the Employee_ID, Name, Age, Nationality, and Date of Birth, it will be also including two separated types of employees and they are: Part Time, and Full Time. Customer Entity This Entity is busy with giving the full information needed about the customers we are dealing with such as their Customer_ID, Name, Age, Contact_Number, and these information will be helpful in many facts in our company such as in making our invoices and assigning a specific car for a certain customer. Shipment Entity Shipment entity is one of the services that made our company earn its name in such a short time, as this service allow a full shipment service for as much as needed for cars for our customers viewed with its price, and a unique Shipment_Number, also the Country attributes as it tells the destination for each shipment services and the Fee attribute to tells the price for each country shown on the list. BUSINESS RULES In this section we will be listing DMC companys main rules in its business, as for our customers for an example they are able to buy as much cars as they can with no any problems but for our cars in the stock we cannot offer to sell the car for more than one and only one customer, also with our employees as any 1 of our employees can deal with more than just one car, but for the cars they should be dealt with only one employee to make the sell process. And as for these examples here we will be listing all the business rules for our company to make sure to be followed as it is: For every Shipment service that been made, it has to be assigned into an invoice that is related to it and that is a MUST. Every Car in stock can have one invoice specialize for it; same goes for the invoice as we made only one car can fit in each invoice rather than more than just one to make the business more flexible. Every Car can have a shipment service depends on the customers need, and as for this shipment service, it can be done for more than just one car as well, but it should be made for at least one car for this service to be available. For every single customer, he/she can belong to more than just one invoice depends on the orders he/she made and how many cars been bought, and in the other hand for the invoice it can only belong to one and only one customer, means we cannot include two customers buying the same car model in one invoice because they sold the same car model. Every employee can handle more than just one invoice when making the selling process, he/she can serve more than just one invoice, but for the invoices, every invoice should be handled by only one employee. Also we have to make sure that we wont start the buying process for our customers unless we have their personal data in our database system. For our new employees, we cannot let them start working in active business unless the process of having their personal information inside our database is done. INITIAL E.R DESIGN SPECIFICATION TABLE SPECIFICATION Inside DMC database I would like to create few modules and show the way to create them, and the purpose of making them, plus the reason of every column, so they can help me on the objectives Im aiming to achieve which they are: Database Description My database consists of five tables (And two sub-type tables that will be mentioned later on) and they are: Cars Invoice Customer Employee Shipment Table Specification Table Name: Invoice Table Description: To be used as a reference of all the sales of the company. Attribute of the Table: Invoice_Number, Customer_ID, Car_ID, Employee_ID, Shipment_Number, Total_Price. Table Type: Independent. Primary Key: Invoice_Number. ============================ Table Name: Customer Table Description: To be shown the customer basic information, along with his/her unique ID number. Attribute of the Table: Customer_ID, Name, Age, Contact_Number. Table Type: Independent Primary Key: Customer_ID ============================ Table Name: Employee Table Description: To be shown the Employee private data inside the database. Attribute of the Table: Employee_ID, Name, Nationality, Date of Birth. Table Type: Independent (Supertype) Primary Key: Employee_ID ============================ Table Name: Cars Table Description: To be shown the Car basic data, along with the cars price and its shipment number. Attribute of the Table: Brand_Name, Color, Car_ID, Shipment_Number, Price. Table Type: Independent Primary Key: Car_ID ============================ Table Name: Shipment Table Description: To be shown more specific information about the shipment service, such as the countries that are available for the service, plus the fee. Attribute of the Table: Shipment_Number, Country, Fee Table Type: Independent Primary Key: Shipment_Number ============================ Table Name: Full Time Table Description: To be shown more specific information about the Full Time employees, such as the Salary for the Full Time employees section, and the administration section which shows each full time employee and hi/her related administration division, along with the Employee ID. Attribute of the Table: Employee_ID, Salary, and Administration. Table Type: Independent (Subtype) Primary Key: Employee_ID ================================ Table Name: Part Time Table Description: To be shown more specific information about the Part Time employees, such as their Salary as well, and the Part time employees time shifting for their work time, and for sure their employee ID.. Attribute of the Table: Employee_ID, Salary, and Time Shifting. Table Type: Independent (Subtype) Primary Key: Employee_ID ATTRIBUTE SPECEFICATION 1. Invoice Entity Name: Invoice Primary Key: Invoice_Number Name Datatype Length Classification Allow Null Constraints Description Invoice_Number Int Simple No Unique A certain unique numbers to keep track of each invoice Customer_ID Varchar (10) Simple No Unique The ID for a customer Employee_ID INT (10) Simple No Unique The unique ID for an employee Car_ID Varchar (10) Simple No Unique The ID for a car Total_Price Double Simple No Unique Total price of a certain invoice Shipment_Number Int (10) Simple No Unique Unique number made for a certain shipment made 2. Cars Entity Name: Cars Primary Key: Car_ID Name Datatype Length Classification Allow Null Constraints Description Brand_Name VarChar (20) Simple No Unique Model name of the car Color VarChar (10) Simple No Unique Color of the car Car_ID Varchar (10) Simple No Unique The ID for a car Shipment_Number Int (20) Simple No Unique Unique number made for a certain shipment made Price Double Simple No Unique Actual Price of a car 3. Employee Entity Name: Employee Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Name VarChar (20) Simple No Unique The first name of employee Nationality Varchar (20) Simple No Unique The employees nationality Date of Birth Date Simple No Unique The employees date of birth 4. Customer Entity Name: Customer Primary Key: Customer_ID Name Datatype Length Classification Allow Null Constraints Description Customer_ID Varchar (10) Simple No Unique The ID for a customer Name VarChar (10) Simple No Unique The first name of a customer Age Int (2) Simple No Unique The customer age Contact_Number Int (10) Simple No Unique Customer Contact number 5. Shipment Entity Name: Shipment Primary Key: Shipment_Number Name Datatype Length Classification Allow Null Constraints Description Shipment_Number Int (20) Simple No Unique Unique number made for a certain shipment made Country VarChar (10) Simple No Unique The country where the shipment destination Fee Int (5) Simple No Unique The price of the shipment 6. Full Time (Sub-Type Entity) Entity Name: Full Time Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Salary Currency Simple No Unique The salary of a particular employee Administration VarChar (20) Simple No Unique The certain task that the employee is responsible for 7. Part Time (Sub-Type Entity) Entity Name: Part Time Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Salary VarChar (10) Simple No Unique The salary of a particular employee Time Shifting Date/Time Simple No Unique The certain day that the employee have his/her work shifts on CODING CREATING OF TABLES CREATING OF TABLES As for my companys project for our database I used Microsoft Office Access 2007, and I started creating tables on it. [1] Cars Table Script Name Create Cars Table CREATE TABLE Cars ( Car_ID VARCHAR PRIMARY KEY NOT NULL, Brand_Name VARCHAR(20) NOT NULL, Color VARCHAR(10) , Shipment_Number INTEGER(20) NOT NULL, Price Double NOT NULL, ); [2] Invoice table Script Name Create Invoice Table CREATE TABLE Invoice ( Invoice_Number INTEGER PRIMARY KEY NOT NULL, Customer_ID VARCHAR(10) NOT NULL, Car_ID VARCHAR(10) NOT NULL, Shipment_Number INTEGER(10) NOT NULL, Price Double NOT NULL, ); [3] Customer table Script Name Create Customer Table CREATE TABLE Customer ( Customer_ID VARCHAR PRIMARY KEY NOT NULL, Name VARCHAR(10) NOT NULL, Age INTEGER(2) NOT NULL, Contact_Number INTEGER(10) NOT NULL, ); [4] Employee table Script Name Create Employee Table CREATE TABLE Employee ( Employee_ID VARCHAR PRIMARY KEY NOT NULL, Name VARCHAR(20) NOT NULL, Nationality VARCHAR(20) NOT NULL, Date of Birth Date NOT NULL, ); [5] Shipment table Script Name Create Shipment Table CREATE TABLE Shipment ( Shipment_Number INTEGER PRIMARY KEY NOT NULL, Country VARCHAR(10) NOT NULL, Fee INTEGER(10) NOT NULL, ); CONSTRAINTS SPECIFICATION Generalization hierarchy on an Employee. Description: This hierarchy assigns the Employee entity as Supertype, and Full Time, Part Time as Subtypes, and since the both subtypes have many similarities, the Supertype have the attributes in common to the subtypes and they are: Employee_ID, Name, Nationality, Date of Birth. . The subtypes cannot be one in another, means the Full Time employee cannot be a Part Time employee, and therefore this generalization hierarchy is of the type disjoint. Type: Disjoint Super type Entity: Employee Super type Primary Key: Employee_ID Common Attributes: Employee_ID, Name, Nationality, Date Of Birth. Constraints Full Time: This subtype entity shows certain data about the Full time employees in the company and their related information which is needed to our database. As for the attributes for this entity: Employee_ID, Salary, Administration. Part Time: This subtype entity shows the data the other type of employees which is the part time employee type. As for the attributes for this entity: Employe_ID, Salary, Time shifting, INITIAL POPULATING OF TABLES Cars Table Populating Table (Cars) INSERT INTO Cars (Brand_Name, Color, Car_ID, Shipment_Number, Price) VALUES (Mustang, Orange, 17111, 11333, 40000) ; Invoice Table Populating Table (Invoice) INSERT INTO Invoice (Invoice_Number, Customer_ID, Car_ID, Employee_ID, Shipment_Number, Total_Price) VALUES (11, 9844, 17633, 1432, 11771, 25) ; Customer Table Populating Table (Customer) INSERT INTO Customer (Customer_ID, Name, Age, Contact_Number) VALUES (9020, Avinash, 39, 2800131) ; Employee Table Populating Table (Employee) INSERT INTO Employee (Employee_ID, Name, Nationality, Date of Birth) VALUES (1422, Vadimas, Libyan, 2/21/1986) ; Shipment Table Populating Table (Shipment) INSERT INTO Shipment (Shipment_Number, Country, Fee) VALUES (11311, Germany, 130) ; Full Time Table Populating Table (Full Time) INSERT INTO Full Time (Employee_ID, Salary, Administration) VALUES (1433, 1300, Secretary) ; Part Time Table Populating Table (Part Time) INSERT INTO Part Time (Employee_ID, Salary, Time Shifting) VALUES (1441, 2000, 3/23/2009) ; USERS INPUT (INSERTION, DELETION, UPDATE) INSERTION: Add New Car (Cars Table) Query name: Insert (New Car in the cars showcase) INSERT INTO Cars (Brand_Name, Color, Car_ID, Shipment_Number, Price) VALUES ([Type the Cars Brand], [Type the Color of the Car ], [The Car ID], [The Shipment Number related to this Car], [The Price of this Car is); INSERTION 2 Here we are going to try to insert a new data into the Shipment form, as we will be using it through the Shipment form insertion button included in that form. Then here the database will ask you if your up for inserting new data into that form And here the data has been inserted successfully below UPDATE: Update New Customer (Customer Table) Query name Update (New Customer in the Customers Table) UPDATE Customer SET Contact_Number = [Enter Customers phone number] WHERE Customer_ID = [ID]; DELETION: Delete a Shipment Country (Shipment Table) DELETE * FROM Shipment WHERE Country = [Enter the Country that will be eliminated]; PERFORMING QUERIES, SUB-QUERIES QUERY [1] (Performing Alias technique into a Query) Description: To manage all the Employees names into one query QUERY [2] (Performing Function technique into a Query) Description: To display all the cars available at the moment QUERY [3] (Performing Concatenation technique into a Query) Description: To give a brief description about each car in the showcase QUERY [4] (Performing Sub-Query technique into a Query) Description: To Create a query from the employee data where it concern only employees who are British. QUERY [5] (Performing another Sub-Query technique into a Query) Description: To Create a query from the Cars data where it concern only the minimum prices of listed cars plus be grouped by the cars brand name. TESTING Test case : 1 Objectives : To use ALIAS in Employee Table Test Data : SELECT NAME AS FULLNAME FROM Employee; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 2 Objectives : To use ALIAS in Customer Table Test Data : SELECT Name AS CustomerName FROM Customer; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 3 Objectives : To use ARITHMETIC in Car Table Test Data :SELECT Car_ID, Brand_Name, (Price*2) AS [Price with Shipment] FROM Cars; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 4 Objectives : To Create Shipment Table Test Data : CREATE Table Shipment ( Shipment_Number int (5), Country varchar (10), Fee money (10) ) ; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 5 Objectives : To use COMPARISON in Cars Table Test Data : SELECT Car_ID, Brand_Name FROM Cars WHERE Price>6000; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 6 Objectives : To use COMPARISON in Shipment Table Test Data : SELECT Shipment_Number, Country FROM Shipment WHERE Fee Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 7 Objectives : To Create Cars table Test Data : CREATE Table Cars ( Car_ID int (5), Shipment_Number int (5), Brand_Name varchar (10), Color varchar (10), Price (10) ) ; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test Database Management System for Car Company Database Management System for Car Company STRATEGY ANALYSIS DESCRIPTION OF CURRENT BUSINESS ACTIVITIES INTRODUCTION DMC is a Dedicated cars company that is specialized in Car sales business, and it was established Four years ago in 7th May 2005, and its main name stands for Dedicated Motor Cars and its main division is in Tripoli Libya, it is a company with many high workers and skilled employees working on it as they are sharing the same ambition, and always aiming for the best in their business, in both to improve their employees skills and also to provide the best services to their dear customer. DMC is really working hard to achieve a new improvement in their business every year, also to get the most popular and successful cars to get them, and for the best prices to its customers, as they are also filling their case show with a good collection in each month. As for this month they got a very promising collection of new cars that just released this year, and old ones but got well comments from millions of people who tried them, this collection will be for this year as in this time its the companys season time for the business. Current System The current system of my company is going like this, each day we are improving, and as I can see now we are well known as 1 of the top 20 Private companies in Libya, and we are also known in the other continents as well. We are also not restrict with only 1 nationality as we are offering jobs, because our company contains employees from different nationality as we have some of them in the main division and some other are in our different offices around the globe. DMC has a good budget as overall, and it is improving, also the customers are so pleased with our services in general, and our economical prices. That includes that we are always taking care of our employees in terms of payment and to keep them improving by sending them to take courses in different kind of fields. Although we are doing a pretty good job in this business field and improving by a good rate percentage every year, but we are really facing some of the major problems in our business, the main problem is that we are facing a new changes and new challenges in our business, also we have other competitors companies in the countries we are doing this business and selling our cars and making our different services. Problem Background Effects of it So our main problem actually includes semi problems that we should take care of them so we can solve the main problem, which is we really need to move on with our services with the technology we are facing these days in doing those kind of business to make it better, faster, and easier. And 1st of all is our own system in the company, because it is still not well organized as an strong infrastructure and we also need a well studied design model for this infrastructure for our company. Thats where I planned to made a Special database system to our company, which will be including our employees, our daily customers for each season, and our sales of cars on this season on as well covered by the invoice section of the company, and some specific information about our shipment idea and its fee and coverage services. The good thing is that with this new system we will be able to make a clear and direct relational between all the sections mentioned above and make a really strong infrastructure for the company plus to be able to store information and data more sufficiently. In this segment I would like to give you an idea about the goals and aims that we are aiming to achieve and they are: Improve the business even much further, to reach a new level of development. Reduce the paper work as we had a lost of some data from time to time. To always keep up with the other contenders companies so we wont lose our customers. Secure our data in a sufficient way. Provide a system where it is easy to get data for any of our customers. Improvement of production to satisfy the customers needs. Easy access to database and information used by employees. Remove barriers to widen its production by improving sales procedure and reducing costs. Hardware and Software Necessity These are all the hardware requirements needed Minimum Requirements Processor 2 Gigahertz (GHz) Pentium IV-Intel processor or Higher. Memory 512 MB of RAM or Higher. Hard Disk 900 MB of available space required on the system drive, 4 gigabytes (GB) of available space capacity on the installation drive. Drive DVD-ROM or CD-ROM drive and Floppy drive Display Super VGA (1024 x 768) or higher resolution. These are all the software requirements needed Minimum Requirements Operating Systems Windows XP Service Pack Final, Windows Vista, or Windows 7 any edition with MS-Office. H I S T O R Y DMC Companys history is not that much as the company only established two years ago, but in those two years we can say that the company earned its name and make various successful that led it to earn a respectful history archive in the day it starts doing business till our day now. Specification for New System The main purpose from making this new application in my company is 1st to achieve the objectives that DMC is aiming to achieve, 2nd to make the business much easier for the customer and the employee as each of them will have the advantage of these kind of applications in our business. Also the cars sales section (which is the Cars Details) will be much more attractive this way, and as it shows all the possible information that needed at the same time. That goes for the employee and customers tables as well; they are helping the company over all by making it progressing even much faster and also to reduce the paper work. About Us table shows the company in a really short cut way, and its true words shows on this section, also for the producer of this application to have his word on that section. Also the shipment tables is an important section and it is one of the reasons to determine whether a certain car sales company is really know about its business and can keep up, or sadly but have no idea about this field of business as it helps a lot in showing exactly the steps taking to ship your car and to not need to discuss any of the employee about it because it is very clear. On the other hand, last one but not last, is Plate Info table, which holds all the plate number for the cars that have been purchased from our company, and also saving the numbers from the other cars for the customers that are ding services for their own car. BUISNESS ACTIVITIES OPERATIONS DESCRIPTION OF OPERATIONS Þ Assign an Employee to handle a certain invoice. Þ Check the Country of the Customer to make the delivery shipment service for his/her order. Þ Adding an Employee to the company. Þ Assign a Unique ID to a Customer. Þ Adding a new Car to the showcase. Operation Name: Assign an Employee to handle a certain invoice. Description: This operation handles the fact that when we are having a new invoice table, we hand it over to a certain employee, and a (certain) employee means that he/she is not busy with another invoice or another operation in the moment. Input: The assigned Employee must appear his/her unique ID number, along with his name, and should be clear to read. Output: The Employee will be responsible for that invoice, and handle its full data. ============================ Operation Name: Check the Country of the Customer to make a delivery shipment service for his/her order. Description: This operation handles the action when the Customer wants to make a shipment service for his current order and to make it to a certain country. Input: The Customer must give information about the destination (Country) area where he/she wants to deliver the order. Output: The Customer will be given an information about the shipment service such as the fee that known for that country. ============================ Operation Name: Adding an Employee to the company. Description: As DMC expanding greatly in the past years, we are making this issue more than usual lately, and it is about recruiting a new employee to the company, further adding his information to the database. Input: For this operation we need to have the new Employee Name, Age, Nationality, and his/her Date of Birth to be able to add him/her to our database. Output: The new Employee will be added to our database, and will be given a Unique ID number to be known as one of DMC employees. ============================ Operation Name: Assign a Unique ID to a Customer. Description: This operation deals with having a new customer and need to be having his/her information in our database to be given an ID number for easily checking the customer status when he/she makes more orders in the future. Input: To make this operation successful, we need to have basic information yet helpful for us such as Name, Age, and Contact number. Output: The Customer has been given a unique ID number. BUSINESS ACTIVITIES This section describes the operations of DMC Company which is as I mentioned before but in more specific it deals with car sales that the company get from other retailers which recently built up a really strong relationship with DMC and are getting the best deals to expand our business. So mainly DMC deals with customers with services, and we do car sale business, also we are very restrict with our system and the invoice we made are very clear for every car, further our employees are doing their best in every deal been made for each car. And more to mention here for our upcoming Database building is that we are going to build a new design system model that contains Cars, Employee, Invoice, Shipment, and Customer. Those Five elements that I mentioned above will be our main focus on this database design, as it is in general what DMC is is all about. For that matter here we are going to explain in details every Element we have for our Design Model, been explained by including its Attributes and a brief description about its main purpose. And every element will be known later on in the database description as Entity. Invoice Entity This entitys main purpose is to keep track of the sales, and for every deal that have been sold by whom as an employee and for whom as a customer, also it will display all the data necessary about the product (Car) AND ITS Unique ID, plus other major information such as total price and the invoice reset number, whats more is this entity acts as the main entity related to all the other entities as it is also related to the (Shipment) entity as it also saves the shipment number in the invoice paper. The Attributes that have been made for this Entity are: Invoice_Number, Customer_ID, Employee_ID, Shipment_Nmber, Total_Price, and Car_ID, and we will be talking about all the attributes for every entity in more details later on. Cars Entity This entity deals with all the cars that the company DMC stores, and contains all its details such as the car brand name, its color and the car ID, and the shipment number for every specific shipment that been made, along with the most important attribute for all the customers which is: the cars price. Employee Entity This entity here will be busy of containing the Employee_ID, Name, Age, Nationality, and Date of Birth, it will be also including two separated types of employees and they are: Part Time, and Full Time. Customer Entity This Entity is busy with giving the full information needed about the customers we are dealing with such as their Customer_ID, Name, Age, Contact_Number, and these information will be helpful in many facts in our company such as in making our invoices and assigning a specific car for a certain customer. Shipment Entity Shipment entity is one of the services that made our company earn its name in such a short time, as this service allow a full shipment service for as much as needed for cars for our customers viewed with its price, and a unique Shipment_Number, also the Country attributes as it tells the destination for each shipment services and the Fee attribute to tells the price for each country shown on the list. BUSINESS RULES In this section we will be listing DMC companys main rules in its business, as for our customers for an example they are able to buy as much cars as they can with no any problems but for our cars in the stock we cannot offer to sell the car for more than one and only one customer, also with our employees as any 1 of our employees can deal with more than just one car, but for the cars they should be dealt with only one employee to make the sell process. And as for these examples here we will be listing all the business rules for our company to make sure to be followed as it is: For every Shipment service that been made, it has to be assigned into an invoice that is related to it and that is a MUST. Every Car in stock can have one invoice specialize for it; same goes for the invoice as we made only one car can fit in each invoice rather than more than just one to make the business more flexible. Every Car can have a shipment service depends on the customers need, and as for this shipment service, it can be done for more than just one car as well, but it should be made for at least one car for this service to be available. For every single customer, he/she can belong to more than just one invoice depends on the orders he/she made and how many cars been bought, and in the other hand for the invoice it can only belong to one and only one customer, means we cannot include two customers buying the same car model in one invoice because they sold the same car model. Every employee can handle more than just one invoice when making the selling process, he/she can serve more than just one invoice, but for the invoices, every invoice should be handled by only one employee. Also we have to make sure that we wont start the buying process for our customers unless we have their personal data in our database system. For our new employees, we cannot let them start working in active business unless the process of having their personal information inside our database is done. INITIAL E.R DESIGN SPECIFICATION TABLE SPECIFICATION Inside DMC database I would like to create few modules and show the way to create them, and the purpose of making them, plus the reason of every column, so they can help me on the objectives Im aiming to achieve which they are: Database Description My database consists of five tables (And two sub-type tables that will be mentioned later on) and they are: Cars Invoice Customer Employee Shipment Table Specification Table Name: Invoice Table Description: To be used as a reference of all the sales of the company. Attribute of the Table: Invoice_Number, Customer_ID, Car_ID, Employee_ID, Shipment_Number, Total_Price. Table Type: Independent. Primary Key: Invoice_Number. ============================ Table Name: Customer Table Description: To be shown the customer basic information, along with his/her unique ID number. Attribute of the Table: Customer_ID, Name, Age, Contact_Number. Table Type: Independent Primary Key: Customer_ID ============================ Table Name: Employee Table Description: To be shown the Employee private data inside the database. Attribute of the Table: Employee_ID, Name, Nationality, Date of Birth. Table Type: Independent (Supertype) Primary Key: Employee_ID ============================ Table Name: Cars Table Description: To be shown the Car basic data, along with the cars price and its shipment number. Attribute of the Table: Brand_Name, Color, Car_ID, Shipment_Number, Price. Table Type: Independent Primary Key: Car_ID ============================ Table Name: Shipment Table Description: To be shown more specific information about the shipment service, such as the countries that are available for the service, plus the fee. Attribute of the Table: Shipment_Number, Country, Fee Table Type: Independent Primary Key: Shipment_Number ============================ Table Name: Full Time Table Description: To be shown more specific information about the Full Time employees, such as the Salary for the Full Time employees section, and the administration section which shows each full time employee and hi/her related administration division, along with the Employee ID. Attribute of the Table: Employee_ID, Salary, and Administration. Table Type: Independent (Subtype) Primary Key: Employee_ID ================================ Table Name: Part Time Table Description: To be shown more specific information about the Part Time employees, such as their Salary as well, and the Part time employees time shifting for their work time, and for sure their employee ID.. Attribute of the Table: Employee_ID, Salary, and Time Shifting. Table Type: Independent (Subtype) Primary Key: Employee_ID ATTRIBUTE SPECEFICATION 1. Invoice Entity Name: Invoice Primary Key: Invoice_Number Name Datatype Length Classification Allow Null Constraints Description Invoice_Number Int Simple No Unique A certain unique numbers to keep track of each invoice Customer_ID Varchar (10) Simple No Unique The ID for a customer Employee_ID INT (10) Simple No Unique The unique ID for an employee Car_ID Varchar (10) Simple No Unique The ID for a car Total_Price Double Simple No Unique Total price of a certain invoice Shipment_Number Int (10) Simple No Unique Unique number made for a certain shipment made 2. Cars Entity Name: Cars Primary Key: Car_ID Name Datatype Length Classification Allow Null Constraints Description Brand_Name VarChar (20) Simple No Unique Model name of the car Color VarChar (10) Simple No Unique Color of the car Car_ID Varchar (10) Simple No Unique The ID for a car Shipment_Number Int (20) Simple No Unique Unique number made for a certain shipment made Price Double Simple No Unique Actual Price of a car 3. Employee Entity Name: Employee Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Name VarChar (20) Simple No Unique The first name of employee Nationality Varchar (20) Simple No Unique The employees nationality Date of Birth Date Simple No Unique The employees date of birth 4. Customer Entity Name: Customer Primary Key: Customer_ID Name Datatype Length Classification Allow Null Constraints Description Customer_ID Varchar (10) Simple No Unique The ID for a customer Name VarChar (10) Simple No Unique The first name of a customer Age Int (2) Simple No Unique The customer age Contact_Number Int (10) Simple No Unique Customer Contact number 5. Shipment Entity Name: Shipment Primary Key: Shipment_Number Name Datatype Length Classification Allow Null Constraints Description Shipment_Number Int (20) Simple No Unique Unique number made for a certain shipment made Country VarChar (10) Simple No Unique The country where the shipment destination Fee Int (5) Simple No Unique The price of the shipment 6. Full Time (Sub-Type Entity) Entity Name: Full Time Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Salary Currency Simple No Unique The salary of a particular employee Administration VarChar (20) Simple No Unique The certain task that the employee is responsible for 7. Part Time (Sub-Type Entity) Entity Name: Part Time Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Salary VarChar (10) Simple No Unique The salary of a particular employee Time Shifting Date/Time Simple No Unique The certain day that the employee have his/her work shifts on CODING CREATING OF TABLES CREATING OF TABLES As for my companys project for our database I used Microsoft Office Access 2007, and I started creating tables on it. [1] Cars Table Script Name Create Cars Table CREATE TABLE Cars ( Car_ID VARCHAR PRIMARY KEY NOT NULL, Brand_Name VARCHAR(20) NOT NULL, Color VARCHAR(10) , Shipment_Number INTEGER(20) NOT NULL, Price Double NOT NULL, ); [2] Invoice table Script Name Create Invoice Table CREATE TABLE Invoice ( Invoice_Number INTEGER PRIMARY KEY NOT NULL, Customer_ID VARCHAR(10) NOT NULL, Car_ID VARCHAR(10) NOT NULL, Shipment_Number INTEGER(10) NOT NULL, Price Double NOT NULL, ); [3] Customer table Script Name Create Customer Table CREATE TABLE Customer ( Customer_ID VARCHAR PRIMARY KEY NOT NULL, Name VARCHAR(10) NOT NULL, Age INTEGER(2) NOT NULL, Contact_Number INTEGER(10) NOT NULL, ); [4] Employee table Script Name Create Employee Table CREATE TABLE Employee ( Employee_ID VARCHAR PRIMARY KEY NOT NULL, Name VARCHAR(20) NOT NULL, Nationality VARCHAR(20) NOT NULL, Date of Birth Date NOT NULL, ); [5] Shipment table Script Name Create Shipment Table CREATE TABLE Shipment ( Shipment_Number INTEGER PRIMARY KEY NOT NULL, Country VARCHAR(10) NOT NULL, Fee INTEGER(10) NOT NULL, ); CONSTRAINTS SPECIFICATION Generalization hierarchy on an Employee. Description: This hierarchy assigns the Employee entity as Supertype, and Full Time, Part Time as Subtypes, and since the both subtypes have many similarities, the Supertype have the attributes in common to the subtypes and they are: Employee_ID, Name, Nationality, Date of Birth. . The subtypes cannot be one in another, means the Full Time employee cannot be a Part Time employee, and therefore this generalization hierarchy is of the type disjoint. Type: Disjoint Super type Entity: Employee Super type Primary Key: Employee_ID Common Attributes: Employee_ID, Name, Nationality, Date Of Birth. Constraints Full Time: This subtype entity shows certain data about the Full time employees in the company and their related information which is needed to our database. As for the attributes for this entity: Employee_ID, Salary, Administration. Part Time: This subtype entity shows the data the other type of employees which is the part time employee type. As for the attributes for this entity: Employe_ID, Salary, Time shifting, INITIAL POPULATING OF TABLES Cars Table Populating Table (Cars) INSERT INTO Cars (Brand_Name, Color, Car_ID, Shipment_Number, Price) VALUES (Mustang, Orange, 17111, 11333, 40000) ; Invoice Table Populating Table (Invoice) INSERT INTO Invoice (Invoice_Number, Customer_ID, Car_ID, Employee_ID, Shipment_Number, Total_Price) VALUES (11, 9844, 17633, 1432, 11771, 25) ; Customer Table Populating Table (Customer) INSERT INTO Customer (Customer_ID, Name, Age, Contact_Number) VALUES (9020, Avinash, 39, 2800131) ; Employee Table Populating Table (Employee) INSERT INTO Employee (Employee_ID, Name, Nationality, Date of Birth) VALUES (1422, Vadimas, Libyan, 2/21/1986) ; Shipment Table Populating Table (Shipment) INSERT INTO Shipment (Shipment_Number, Country, Fee) VALUES (11311, Germany, 130) ; Full Time Table Populating Table (Full Time) INSERT INTO Full Time (Employee_ID, Salary, Administration) VALUES (1433, 1300, Secretary) ; Part Time Table Populating Table (Part Time) INSERT INTO Part Time (Employee_ID, Salary, Time Shifting) VALUES (1441, 2000, 3/23/2009) ; USERS INPUT (INSERTION, DELETION, UPDATE) INSERTION: Add New Car (Cars Table) Query name: Insert (New Car in the cars showcase) INSERT INTO Cars (Brand_Name, Color, Car_ID, Shipment_Number, Price) VALUES ([Type the Cars Brand], [Type the Color of the Car ], [The Car ID], [The Shipment Number related to this Car], [The Price of this Car is); INSERTION 2 Here we are going to try to insert a new data into the Shipment form, as we will be using it through the Shipment form insertion button included in that form. Then here the database will ask you if your up for inserting new data into that form And here the data has been inserted successfully below UPDATE: Update New Customer (Customer Table) Query name Update (New Customer in the Customers Table) UPDATE Customer SET Contact_Number = [Enter Customers phone number] WHERE Customer_ID = [ID]; DELETION: Delete a Shipment Country (Shipment Table) DELETE * FROM Shipment WHERE Country = [Enter the Country that will be eliminated]; PERFORMING QUERIES, SUB-QUERIES QUERY [1] (Performing Alias technique into a Query) Description: To manage all the Employees names into one query QUERY [2] (Performing Function technique into a Query) Description: To display all the cars available at the moment QUERY [3] (Performing Concatenation technique into a Query) Description: To give a brief description about each car in the showcase QUERY [4] (Performing Sub-Query technique into a Query) Description: To Create a query from the employee data where it concern only employees who are British. QUERY [5] (Performing another Sub-Query technique into a Query) Description: To Create a query from the Cars data where it concern only the minimum prices of listed cars plus be grouped by the cars brand name. TESTING Test case : 1 Objectives : To use ALIAS in Employee Table Test Data : SELECT NAME AS FULLNAME FROM Employee; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 2 Objectives : To use ALIAS in Customer Table Test Data : SELECT Name AS CustomerName FROM Customer; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 3 Objectives : To use ARITHMETIC in Car Table Test Data :SELECT Car_ID, Brand_Name, (Price*2) AS [Price with Shipment] FROM Cars; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 4 Objectives : To Create Shipment Table Test Data : CREATE Table Shipment ( Shipment_Number int (5), Country varchar (10), Fee money (10) ) ; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 5 Objectives : To use COMPARISON in Cars Table Test Data : SELECT Car_ID, Brand_Name FROM Cars WHERE Price>6000; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 6 Objectives : To use COMPARISON in Shipment Table Test Data : SELECT Shipment_Number, Country FROM Shipment WHERE Fee Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 7 Objectives : To Create Cars table Test Data : CREATE Table Cars ( Car_ID int (5), Shipment_Number int (5), Brand_Name varchar (10), Color varchar (10), Price (10) ) ; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test