Sunday, January 26, 2020
Entity relationship diagram model of george’s garage
Entity relationship diagram model of georgeà ¢Ã¢â€š ¬Ã¢â€ž ¢s garage Introduction Relationship between one or more then one entity of tables by pripary key and foreign key is called as Entity Relationship diagram model. This documentation will be on Entity Relationship diagram model of Georges Garage. Database Information Tables of the Garage Database Garage Database gives information of the table Name with Primary key and Foreign Key. 1)Ncar_sale Pk: Ncar_id 2).ShCar_Sale Pk:- ShCar_id 3).VehicleSale Pk: Sale_id Fk:- Ncar_id , ShCar_id, Dept_id 4) Car_auction Pk : au_id Fk:- SHCar_id 5) Car_Workshop Pk: Workshop_id Fk : dept_id, Car_servise_id 6) Car_servise Pk : Car_servise_id FK :- Payment_id , Parts_id 7) Servise_payment Pk : Payment_id Fk : Staff_id 8) Car_Parts Pk : Parts_id 9) Customer Pk : cust_id 10) Parts_Sale_Stock Pk : Parts_sale_id Fk : parts_id, cust_id 11) Parts_order Pk : Order_id FK : parts_id 12) Suplier Pk :- Suplier_id Fk :- Order_id 13) Department Pk :- Dept_id 14) staff Pk : Staff_id FK : dept_id 15) Vehicle_Booking Pk :- Booki_id Fk :- Cust_id 16) Vehicle_Hire Pk : Hire_id Fk : Booki_id, Dept_id 17) Valeting_Servise Pk : Valeting_servise_id FK : booki_id, 18) Car_Hire Pk : Car_Hire_id 19) Vehicle Pk :- Vehicle_id Fk : booki_id, Car_Hire_id 20) Sp_Car_Hire Pk :- Sp_Car_id Fk :- Vehicle_id 21) Rolls_Roys Pk : Rr_Car_id Fk : Sp_Car_id 22) Limousines Pk : Li_Car_id Fk : Sp_Car_id 23) Minibus Pk : Mb_Car_id Fk : Sp_Car_id Entity Relationship Diagram Concepts Keys * Primary Key :- Primary Key is a key that uniquely identify value of the table Example:- In payment table, Payment_id is a primary key. Create table Servise_payment ( payment_id varchar(5) NOT NULL CONSTRAINT carser_pk PRIMARY KEY, ) * Foreign Key :- Foreign Key is a key thats indicates the primary Key of the another table Create table Car_servise ( Payment_id varchar(5) NOT NULL CONSTRAINT spayme_fk FOREIGN KEY REFERENCES Servise_payment(payment_id) ) * Example :- In Car_Service table, Payment_id is a foreign Key which point out another Payment_id of the Payment table Entity Collection of Attributes is known as Entity. In sql, parson table is a entity and Person_id, Person_name, person_Address and Person_BOD is a attributes of person. Assume Genaral This database on the George garage therefore it contains all information of the garage.there are twenty three tables which are connected with each other.. a. Some of the employee have same amount of salary because they may work in same department and same position. b. Some Cars Hire date are similar because different car might hire in same date. c. Some tables have Integer data type or float data type due to Price of part and seat of car respectively. Spacial 1)Ncar_sale This Ncar tables contains detail of sales of the new cars 2).ShCar_Sale This table store information about second hand car. 3).VehicleSale This table keeps records of the New car and Second hand car sale. This table acts as sale department 4) Car_auction Car auction table keeps record of car auction information. Second hand car used in car auction 5) Car_Workshop This is Workshop department table. This table store data of car services in the workshop. 6) Car_servise This table gives information about service of the one car. Its also gives information about parts which are used in service, Payment and type of service. 7) Service_payment This payment table store payment information of each Service. 8) Car_Parts Car parts table contain details of each Parts of the car. Some car parts also order from the supplier. 9) Customer This table store customers information. 10) Parts_Sale_Stock This table is use for store information of parts sale 11) Parts_order Parts order table contains parts order data. 12) Suplier This table used to store information about Supplier 13) Department Department table contain all department information 14) staff this table gives information of the all staff of the departsment 15) Vehicle_Hire This table is a Hire department table which store booking information. 16) Vehicle_Booking This table used to book hire vehicle information as well as valeting Service information. 17) Valeting_Servise This table keeps records of the valeting service. 18) Car_Hire Car hire tables contains information about only cars and Vans 19) Vehicle This Vehicle table store detail of the hire vehicles such as Car and special vehicle. 20) Sp_Car_Hire Car hire tables contains information about only special vehicle such as Minibus, Rolls Roys and Limousines. 21) Rolls_Roys Rolls Roys table contain information about rolls roys special vehicle.Rolls Roys is used for occation 22) Limousines Limousines table contain information about rolls roys special vehicle. Limousines used for wedding and night outs 23) Minibus Minibus table contain information about Minibus special vehicle. This table keeps records of Airport pickup 5 Syntaxes. Create Syntax Create Syntax is used in sql which is for create table. Create Syntax is used in the data Definition language(DDL). For Example :- This syntax for create Vehicle_sale table. Create table Vehicle_Sale ( Sale_id int(3), New_car_sale_id varchar(5), Secondhandcar_sale_id varchar(5), Staff_id varchar(5) ) Insert Syntax Insert Syntax is used in sql which is for Insert value in the table. Insert Syntax is used in the data Manipulation language(DML). For Example : This syntax for insert value in the Vehicle_sale Insert into Vehicle_Sale values(S01,Car01,sh01,em01); Index Systax Index used for make search process easily and fast For example : In employee table, each employ has their own phone number and it is unique
Saturday, January 18, 2020
Biological Psychology Essay
Abstract Psychology has its own biological boundaries. This is in the form of biological psychology or behavioral neuroscience. The main aim of this branch in psychology is to have a clearer picture of the relationship of the mind and body, and mind and brain. It tries to link the brain functions to the different mental processes and behaviors. This type of psychology investigates man’s physiological phenomena such as memory and emotions. Biological Psychology Human beings are more then a collection of systems, more than a collection of organs and more than a collection of cells. The human body is complex. It is an operating organism which functions as a whole. The human body involves a great deal of variety of processes. By examining the parts, it does not mean that one can understand the whole organism (Arnold, 1999). Biological psychology is the field of psychology which main endeavor was to link the different brain functions to different mental processes and behaviors. Psychologists in this subdiscipline of psychology are often interested in relating biological variables to psychological or behavioral variables. It deals with biological processes and behaviors that are shared with mammalian animals. This is because biological psychologists utilize animals in their experiments. Some of these processes are sensation, perception, motivation, learning memory and control of motor movements (â€Å"Biological Psychology†).            The history of Biological psychology emerged from various philosophical views in the 18th and 19th century. However, its study started much earlier. It dates back to Avicenna, a Persian psychologist and physician. He recognized physiological psychology in the treatment of illnesses involving emotions. Avicenna also gave some psychological explanations on somatic illnesses. He believed that humidity inside the brain can cause mood disorders. Humidity is brought by the change with the amount of breath. Another is that happiness increases the breath so it contributes to the brain’s moisture. But then, too much moisture can make the brain loss control thus having mental disorders (â€Å"The Mind-Brain Problem†).            The philosophical history of Biological Psychology surfaced from philosophers like Rene Descartes. He believed that the pineal gland was the point of contact between the mind and body. He also proposed a theory that pneumatics or fluid power of bodily fluids is connected to reflexes and motor behavior (â€Å"The Mind- Brain Problem†).            Another philosopher who contributed to Biological psychology is William James.  He is the one who argued that in the study of psychology there should also be consideration to the understanding of Biology. He also stressed that the functions of the brain must be included in the study of psychology. The connection between mind and brain became progressively clearer in the nineteenth century. In this century, the doctors started observing patients who suffered from head injuries. The patients usually exhibited alterations in language and memory and some variation in their personalities. One patient is a refined businessman and a loving father became a vulgar person who lacks in affection for his loved ones after a sever blow in the head. These observations is lead researchers to experiment by producing surgical lesions in animals in different regions of the brain to observe what effects these lesions have on behavior (Westen, 1999). Since its origin, one of the major issues faced by biological psychologists was localization of functions. This entails knowing which different parts of the brain control different aspects of functioning. In 1836, a physician named Marc Dax, noted that lesions on the left side of the brain were associated with aphasia or language disorder. Because of this discovery, many other discoveries linking the left hemisphere of the brain with language function appeared (Westen, 1999). These other discoveries led to the finding of Broca’s and Wernicke’s areas. Broca’s aphasia involves difficulty in production of speech, whereas Wernicke’s aphasia involves difficulty in comprehending language (Westen, 1999).            The clinical assumption of Biological psychology is that organisms share similar biological processes and behaviors. Some of the other disciplines in psychology greatly related with biological psychology are comparative psychology, evolutionary psychology, neuropsychology, clinical psychology, cognitive psychology and experimental psychology (Westen, 1999).            Comparative psychology is the study of behavior and mental processes of animals other than human beings (Westen, 1999). Biological psychologists use animals in their experiments. They compare the results done on these animals to human processes and behaviors. Evolutionary psychology, on the other hand, deals with the explanation of mental and psychological traits and how they evolved to adapt to different stimuli. Neuropsychology is an interdisciplinary field of psychology and neuroscience that aims to explain how the structure and function of the brain relate to certain psychological behaviors (â€Å"Evolutionary Psychology†).            Other fields of psychology related with biological psychology such as clinical psychology, cognitive psychology, and experimental psychology are connected with biological psychology because these fields aim to link the physiological processes with different mental processes. Clinical psychology focuses on the nature and treatment of physiological processes that lead to emotional distress. Cognitive psychology examines the nature of thought, memory and language. And, experimental psychology examines mental processes in human and other animals (Westen, 1999). Some of the noted modern biological psychologists are Nikolaas Tinbergen, Karl von Frisch, Eric Kandel and Arvid Carlsson. Nikolaas Tinbergen is a Dutch ornithologist who won the Nobel Prize for Physiology in 1973. His contribution is the organization and elicitation of individual and social behaviour patterns in animals. Karl von Frisch is an Austrian ethologist who won the same award with Tinbergen. He studied the senses of bees and identified they methods of communication(â€Å"Nobel Prize in Physiology/ Medicine 1973†)..Eric Kandel is a neuroscientist whose contribution is the analysis of biochemical changes in neurons assiciated with learning and memory storage. Arvid Carlsson is a neuroscientist most noted for his on the neurotransmitter dopmaine and Parkinson’s disease (â€Å"The Nobel Prize in Physiology/ Medicine 2000†).  Reference Arnold, T. (1999). Mind and Brian Relationship. Retrieved February 8, 2008, from            http://www.hyponoesis.org/html/essays/e022.html Biological Psychology. Retrieved February 11, 2008, from            http://www.psypress.com/common/supplementary/184169360X/part1.pdf Evolutionary Psychology. Retrieved February 11, 2008, from            http://www.psychnet-uk.com/evolutionary_psychology/evolutionary_psychology.htm The Mind- Brain problem. Retrieved February 11, 2008, from            http://moebius.psy.ed.ac.uk/~dualism/papers/brains.html The Nobel Prize in Physiology/ Medicine 1973. Nobelprize.org. Retrieved February 11, 2008,            from http://nobelprize.org/nobel_prizes/medicine/laureates/1973/index.html The Nobel Prize in Physiology/ Medicine 2000. Nobelprize.org. Retrieved February 11, 2008,            from http://nobelprize.org/nobel_prizes/medicine/laureates/2000/index.html Westen, D. (2nd Ed.). (1999). Psychology: Mind, Brain and Culture. U.S.A.: John Wiley            & Sons, Inc.
Friday, January 10, 2020
Jerry Maguire-Case Study
LED 605 Negotiations*, Bargaining and Conflict Resolution*: Jerry Maguire Case Study by Hana Jurcovicova For our case study assignment we watched a short part from Jerry Maguire movie. In this movie Jerry Maguire is a sport agent. This kind of job was always his dream. But he is not happy in his job. He hates himself and what he became. He hates the company that was all about money. He learned when he first started, that the job of a sports agent is mostly about personal relationship, caring for people doing business with and meeting their needs. He writes a new mission statement for his company, for the future of it. He wants to make it a company he would like to work for. He thinks that the most important thing is to have fewer clients, which they can take better care of. Fewer clients mean less money for the company which is oriented mostly in making a lot of money. He writes a little book about this mission statement about what we think but never say loud and put it in every mailbox of every employee. The next day when everybody reads it or is still reading, people are clapping to Jerry Maguire even though they know almost for sure he was going to be fired for that. Jerry Maguire is fired later on in the movie. He is fired for sharing his personal opinion and writing about it. It looks like he wants to set people against the company and the way it operates right now. Moreover he did not discuss this mission statement change with any of the members of the board or CEO. Nobody gave him the permission to release his new mission statement to public.
Thursday, January 2, 2020
The Case Of Margaret. Margaret - 788 Words
The Case of Margaret Margaret is a forty-year-old woman, whose husband left her for a younger woman. Margaret has experienced symptoms of shock, rage, and weeping spells. She has been isolating herself in bed because she doesn’t want to deal with anyone or anything. Along with her depressed mood, she has been consuming alcohol in a considerable amount. Margaret’s business has been suffering and she feels like a â€Å"total failure†. Family members concerned grew, which pushed Margaret to meet with a clinical psychologist (Butcher, Hooley, Mineka, 2013). I will form an appropriate diagnosis, rule out disorders, address the potential risks for suicide and homicide, and form recommendations. Forming A Diagnosis After careful consideration, I believe Margaret is suffering from F32.2 Major Depressive Disorder (MDD), severe, single episode, with melancholic features. The Diagnostic criteria for MDD fits with the information given in the case of Margaret. Margaret has a depressed mood most of the day, nearly everyday by subjective report or by observation of others. Margaret has a diminished interest or pleasure in all or almost all activities most of the day, nearly everyday. She experiences psychomotor retardation nearly everyday. It is clear Margaret is suffering from fatigue and loss of energy. She experiences feelings of worthlessness and excessive inappropriate guilt everyday. She reports having diminished ability to think and concentrate nearly everyday. The symptomsShow MoreRelatedA Slave Mothers Fury1148 Words  | 5 PagesA Slave Mother’s Fury: The Story of Margaret Garner In 1793, The United States government issued The Fugitive Slave Act which mandated the return of runaway slaves back to their original slave owners if they were caught. Modified in 1850 with even stricter punishments and consequences even for those who hid runaways, these laws shined a light on an ambiguous plan that the government devised to keep African Americans enslaved without any mere hope of ever becoming free. While in effect, a multitudeRead MoreFaust: Tragedy of the Innocence Essay1299 Words  | 6 Pagesvon Goethe, depicts human tragedy through the character of Margaret. The protagonist, Faust, loves and then later destroys Margarets life, with the help of Mephistopheles. Mephistopheles is one the seven archangels cast out of heaven. Margaret, who is also known as Gretchen in the play, is a small-town girl with realistic characteristics. She is a simple and modest girl who lives with her mother, and is from the lower class. Margaret has simple religious faith and is shown to know right fromRead MoreFinding Balance: Howards End Argumentative Essay1495 Words  | 6 Pagesattitudes of three essential characters; Helen Schlegel, Margaret Wilcox nee Schlegel, and Henry Wilcox. Helen is a character who is the epitome of immaturity and passion. Throughout the novel, she is described as a flighty, unrealistic, young woman. She is quick to find trouble, but is even quicker in running away from those troubles. From the very beginning, Helen’s passion and immaturity is prevalent in the letter she sends to Margaret stating â€Å"I do not know what you will say: Paul and IRead MoreEssay on Case Study1146 Words  | 5 Pagessetting always see whom your audience is. Some common areas of intercultural misinterpretations are female-male interaction, respectfulness, attire, and language. Keywords: interview, respect, Japan, persuasion, taboos In scenario number two, Margaret Owens is getting ready to conduct interviews in order to find Japanese representatives to help her company market a line of pharmaceuticals in Japan. After having her interview with the Japanese representative she was pretty much flabbergasted withRead MoreBirth Control Is A Powerful Tool1475 Words  | 6 Pageshad no control over childbearing due to many restrictions. With Margaret Sanger’s efforts, birth-control awareness became accepted by the people and the legal system, changing the lives of countless women in their fight towards equal opportunity. She changed the way that childbearing was viewed in America and paved a road that led to gender equality. Limited knowledge of contraceptives caused great suffering for women during Margaret Sanger’s childhood. Starting from 1873, a law called the ComstockRead MoreMargaret Sanger s The First Birth Control Movement1288 Words  | 6 PagesMargaret Sanger revolutionized the world in a important way. Margaret Sanger was known for leading the birth control movement. She financed the research needed to develop â€Å"the pill†, an easy form of birth control that women could take themselves. She also founded the Planned Parenthood Federation Of America continuing her legacy of authoritative work to allow parenthood and birth control to be much easier. Margaret Sanger left a legacy of leading the birth control movement. Margaret Sanger was bornRead MoreWives Of The Dead Analysis1475 Words  | 6 Pagestruly understand and have empathy, are each other. The short story is about two women, Margaret and Mary who were married to brothers. Margaret’s husband was reported dead through â€Å"Canadian warfare,†Mary’s through the â€Å"tempestuous Atlantic.†Both widows were newlywed and are devastated by the tragedies. The â€Å"sisters†only find comfort through each other even though they respond differently to the situation. Margaret and Mary are described to have different characteristics, temperaments, timing of eventsRead MoreBirth Control And The Pregnancy Prevention1284 Words  | 6 Pageswomen have the rights to control their lives as they wish. However, as close as the early 1900’s, women still did not have the basic right to control their fertility. Working as a nurse, Margaret Sanger believed that women should maintain the right to protect themse lves against unwanted pregnancies. Margaret Sanger is The Woman Rebel who, despite overwhelming opposition, pioneered the way for modern family planning and, more importantly, the female sexual revolution. The subject of birth controlRead MoreEmm A Short Story1211 Words  | 5 PagesYork; research a case, make a plan, research some more, and catch the bail jumper. Simple and easy, just how she liked it. Walking up to the Nolan house, the only word Emma could think of was, â€Å"Wow.†This was the first time Emma had seen their house, and she had to admit, it was a hell of a house. It was like every other stereotypical house any middle-aged couple would settle into. The grass was neatly trimmed. Flower beds were placed in front of the porch. David and Mary Margaret must spend a lotRead MoreThe Election Of The Conservative Party Leadership1635 Words  | 7 PagesWhat, if anything, was new about Thatcherism? The ballot for the Conservative Party Leadership on February 1975 was a turning point for the History of late 20th century politics in England. The figure of Margaret Thatcher had emerged surprisingly as the new Party leader against the incumbent Edward Heath. Thatcher’s importance does not only lies on she being the first woman to lead the Conservative Party, but on the ideas and statecraft that later gave life to a new concept –Thatcherism- that
Subscribe to:
Comments (Atom)