Selecting a Database for a Small Business Essay -- SQL Database

Jay-Star Incorporated is a small machine shop located in Lexington, Kentucky. There are only seven employees that actually work on the shop floor. Jay-Star produces metal core and distributes that core to various aerospace manufacturers. There are three different types of core that Jay-Star produces: Square Cell, Hexagonal Cell, and Beneflex Cell. Each of them can be produced using different materials from various shipping companies. The employees take these materials from the shipping company, produce the product, and then deliver the finished product to the aerospace manufacturer (customer). For a small company, Jay-Star keeps a very hectic schedule. Any miscalculation on shipping dates could be disastrous for the order flow of the company. This is why this database would prove to be beneficial in keeping a more precise schedule of events. This paper will explain the purpose and requirements of the database; describe, step-by-step, the process for creation of the comp lete database and explains the reason or rationale for each step and, for each step, the options available and choices made for execution; and explain how critical thinking and ethical reasoning were applied in the creation of the database design. The purpose of this database is to keep track of all of the events at Jay-Star Inc. The Customers table lists all of the companies that order products from Jay-Star. It also lists the companies’ contact information and where they are located. The Shippers table lists all of the shipping companies that deliver materials to Jay-Star. Just like the Customer table, the Shipper table lists contact information and location of the companies. The Employees table is a list of all of the employees that actually pr... ...o make schedule keeping easier and more effective. It can tell employees what product they can expect to produce next and let supervisors know when shipments will be delivered. This paper shows the step by step process used in creating the database with the use of primary keys, while also explaining the thought process that went into why tables were created and the order that they were placed using the relationships of each table. Overall this project as proven to be a great test in using all of the fundamentals for this SQL class. I look forward to continued success in using SQL in my future endeavors. Works Cited Data Analytics Software. http://www.1keydata.com/sql/sql-primary-key.html Pratt, Phillip J. Last, Mary Z. A Guide to SQL, Eighth Edition. P.26 Journal of the Association for Information Systems, Aug 1, 2010, Vol. 11, No. 8 (Aug 2010), p. 433-454

The Invincible Criminal Essay -- Crime & Punishment

Imagine losing your retirement funds or being a victim of a mortgage fraud because money from your bank account disappeared overnight! The 1996 report of the National Criminal Justice Commission estimated that the annual cost of white-collar crime is between $130 billion and $472 billion, seven to twenty-five times greater than the cost of conventional or street crime (Conklin, 2010, P. 71). White-collar crime in America is considered larceny committed by the wealthy, respected, and legitimate enterprise which is not set up or intended to go out of business like an ordinary fraud or con game. White-collar crime offenses may involve forgery, embezzlement, or fraud involving massive amounts of money. Offender’s commit fraudulent acts in the course of normal business practice, but is considered unethical and violates accepted accounting principles and mainly public trust. To help better understand the issue the essay will explain several incidents which are involved with white co llar crime and how it hurts many individuals from families to businesses. Even though white-collar crime offender’s gain an increase in salary and may go unnoticed, the criminal justice system should continue to take a stance on white collar crime. Because mainly white collar crime is a serious invincible crime, laws that regulate white collar crimes are necessary, and impacts society's way of life. Additionally, a proposed suggestion will be presented to counter the identified problems and conclude final thoughts on white-collar crime. At the end of the day the goal to continue law regulations against white collar crime while maintaining public protection will be the driving emphasis behind this essay. Defining White-Collar Crime First, the criminal just... .... N., Gilbert, J. A., & Konopaske, R. (2003). Deterring white-collar crime. Academy Of Management Executive, 17(2), 114-127. Retrieved April 20, 2012 from EBSCOhost. (doi:10.5465/AME.2003.10025206) Maddan, S., Hartley, R., Walker, J., & Miller, J.. (2012). Sympathy for the Devil: An Exploration of Federal Judicial Discretion in the Processing of White-Collar Offenders. American Journal of Criminal Justice : AJCJ, 37(1), 4-18. Retrieved April 19, 2012, from ProQuest Criminal Justice. (Document ID: 2586601701). Podgor, E.. (2007). The Challenge of White Collar Sentencing. Journal of Criminal Law & Criminology, 97(3), 731-759. Retrieved April 19, 2012, from ProQuest Criminal Justice. (Document ID: 1392880651). U.S. Department of Justice, Federal Bureau of Inves ¬tigation (1989). White Collar Crime: A Report to the Public. Washington, D.C.: Government Printing Office.

Stefan’s Diaries: Origins Chapter 4

I didn't call on the Cartwrights that day. Instead, after searching the path, I sprinted the two miles back to the estate, terrified that Katherine had somehow been dragged into the forest by some unseen hand–perhaps by the very creature that had been terrorizing the nearby plantations. When I arrived home, though, I found her on the porch swing, chatting with her maid, a sweating glass of lemonade beside her. Her skin was pale, her eyes languorous, as if she'd never run a day in her life. How had she gotten back to the carriage house so quickly? I wanted to stride up and ask, but I stopped myself. I'd sound like a madman, recounting the whirling thoughts in my head. At that moment, Katherine glanced up and shielded her eyes. â€Å"Back so soon?† she called, as if surprised to see me. I nodded dumbly as she slid off the porch swing and glided into the carriage house. The image of her smiling face kept floating back to me the next day, when I forced myself to make the call on Rosalyn. It was even worse than the first call. Mrs. Cartwright sat right beside me on the couch, and every time I shifted, her eyes gleamed, as if she was expecting me to take out the ring at any second. I'd choked out some questions about Penny, about the puppies she'd had last June, and about the progress Honoria Fells, the town dressmaker, had made on Rosalyn's pink gown. But no matter how much I tried, all I wanted was an excuse to leave so I could visit with Katherine. Finally, I muttered something about not wanting to be out past dark. According to Robert, there had been three more animal killings, including George Brower's horse right outside the apothecary. I almost felt guilty as Mrs. Cartwright ushered me out of the house and into my carriage, as if I were going off to battle rather than a two- mile ride home. When I got to the estate, my heart fell when I saw no sign of Katherine. I was about to double back to the stable to brush Mezzanotte when I heard angry voices emanating from the open windows of the kitchen of the main house. â€Å"No son of mine will ever disobey me! Y ou need to go back and take your place in the world.† It was Father's voice, tinged with the heavy Italian accent that became apparent only when he was extremely upset. â€Å"My place is here. The army is not for me. What is so wrong about following my own mind?† another voice yelled, confident, proud, and angry all at once. Damon. My heart quickened as I stepped into the kitchen and saw my brother. Damon was my closest friend, the person I looked up to most in the world–even more than Father, though I'd never admitted it out loud. I hadn't seen him since last year, when he joined General Groom's army. He looked taller, his hair somehow seemed darker, and the skin on his neck was sun- darkened and freckled. I threw my arms around him, thankful I had arrived home when I did. He and Father had never gotten along, and their fights occasionally escalated to blows. â€Å"Brother!† He slapped my back as he pulled out of the embrace. â€Å"We're not finished, Damon,† my father warned as he retreated to his study. Damon turned to me. â€Å"I see Father's the same as always.† â€Å"He's not so bad.† I always felt awkward speaking badly of Father, even as I chafed against my forced engagement to Rosalyn. â€Å"Did you just get back?† I asked, changing the subject. Damon smiled. There were slight lines around his eyes that no one would notice unless they knew him well. â€Å"An hour ago. I couldn't miss my younger brother's engagement announcement, could I?† he asked, a slight hint of sarcasm in his voice. â€Å"Father told me all about it. Seems that he's depending on you to carry on the Salvatore name. And just think, by the time of the Founders Ball, you'll be a husband!† I stiffened. I'd forgotten about the ball. It was the event of the year, and Father, Sheriff Forbes, and Mayor Lockwood had been planning it for months. Partly a war benefit, partly an opportunity for the town to enjoy the last gasp of summer, and mostly a chance for the town leaders to pat themselves on the backs, the Founders Ball had always been one of my favorite Mystic Falls traditions. Now I dreaded it. Damon must have sensed my discomfort, because he started digging through his canvas rucksack. It was filthy and had what looked like a bloodstain on the corner. Finally, he pulled out a large, misshapen leather ball, much larger and more oblong than a baseball. â€Å"Want to play?† he asked, palming the ball from hand to hand. â€Å"What is that?† I asked. â€Å"A football. Me and the boys play when we've got time away from the field. It'll be good for you. Get some color in your cheeks. We don't want you getting soft,† he said, imitating my father's voice so perfectly that I had to laugh. Damon walked out the door, and I followed, shrugging off my linen jacket. Suddenly the sunshine felt warmer, the grass felt softer, everything felt better than it had just minutes before. â€Å"Catch!† Damon yelled, finding me off guard. I lifted up my arms and caught the ball against my chest. â€Å"Can I play?† a female voice asked, breaking the moment. Katherine. She was wearing a simple, lilac summer shift dress, and her hair was pulled into a bun at the base of her neck. I noticed that her dark eyes perfectly complemented the brilliant blue cameo necklace that rested in the hollow of her throat. I imagined lacing my fingers through her delicate hands, then kissing her white neck. I forced myself to tear my gaze away from her. â€Å"Katherine, this is my brother, Damon. Damon, this is Katherine Pierce. She is staying with us,† I said stiffly, glancing back and forth between them to gauge Damon's reaction. Katherine's eyes danced, as if she found my formality incredibly amusing. So did Damon's. â€Å"Damon, I can tell you're just as sweet as your brother,† she said in an exaggerated Southern accent. Even though it was a phrase any of the girls in the county would use when talking to a man, it sounded vaguely mocking coming from her lips. â€Å"We'll see about that.† Damon smiled. â€Å"So, brother, shall we let Katherine play?† â€Å"I don't know,† I said, suddenly hesitant. â€Å"What are the rules?† â€Å"Who needs rules?† Katherine asked, flashing â€Å"Who needs rules?† Katherine asked, flashing a grin that revealed her perfectly straight, white teeth. I turned the ball in my hand. â€Å"My brother plays rough,† I warned. â€Å"Somehow I think I play rougher.† In one swoop, Katherine grabbed the ball from my grasp. As they had been the previous day, her hands were cold, like ice, despite the heat of the afternoon. Her touch sent a jolt of energy through my body and up to my brain. â€Å"Loser has to groom my horses!† she called as the wind whipped her hair behind her. Damon watched her run, then arched an eyebrow toward me. â€Å"That is a girl who wants to be chased.† With that, Damon dug his heels into the earth and ran, his powerful body hurtling down the hill toward the pond. After a second, I ran, too. I felt the wind whip around my ears. â€Å"I'll get you!† I yelled. It was a phrase I'd have yelled when I was eight and playing games with the girls my age, but I felt that the stakes of this game were higher than anything I'd ever played in my life.

Principles of Marketing: Individual Assignment Essay

‘Healthcare Marketing: What is Salient? ’ was written by Mary J. Kay from School of Business, Montclair State University, Montclair, New Jersey, USA. The purpose of the research is to develop a perspective on what is â€Å"salient† or critical to the discipline of healthcare marketing by analyzing and contrasting the consumer perspective with the organizational perspective. Based on the research report, in a complex institutional environment there is an existence of healthcare marketing. The difference of healthcare system in organizational and business structure significantly affect many priorities. In healthcare system, marketing significantly affect it. Thus, marketing are important and can play a role in the healthcare system – it provide the healthcare service and at the same time aiding the health information for consumer. The healthcare organizations usually will face many types of marketing problems due to organization and technology issues; and changes of health problem. So, this research discussed about the salient issues that are faced by healthcare marketing practitioner through contrasting it with consumer or patient perspective to the organizational perspective. From the consumer viewpoint, healthcare issues are important for them. The salient issues are framed in terms of cost and quality. The consumers are depending upon ‘trusted experts’ to evaluate the quality of the health services. The consumers need the quality of health services since they do not have any knowledge regarding the quality of health services. In their health decision, they are reluctant to accept lower quality of health services. Thus, critical or life-sustaining care should never be perceived by healthcare organizations because if they do, it will put a risk to organization’s reputation. For many critical treatment choices, consumer or patient always confront a lack of accessible of information to decide which brings the most benefits for them. In addition, there are many advanced technology that made new choices in testing that contribute to further decision dilemma. Also, choice is increasingly constrained by increasing in health insurance plans or national health programs. Thus, consumers need assistance to understand the critical components of medical care and regarding their decision. The pricing of the healthcare services is usually frustrating from the consumer perspective. High billings are especially troubling to the consumer or patients. Without a doubt, the quality, cost, and effectiveness of healthcare systems are complex interrelated matters that are difficult to understand. From the healthcare organization viewpoint which also involves doctors and staff, they are the ones who work harder to provide quality service, armed with medical knowledge and faced changing medical procedures. Quality is the main healthcare organizational priority but priority can be manifested differently in different healthcare organizations. The problems in fulfilling the demand of quality are difficult. There is some way that improving healthcare quality which is the doctor can be guided by good scientific practices which can be called as ‘evidence-based medicine’. But, there is a problem regarding this because of complexity of medical knowledge. Another way to improve the quality of healthcare services is by scientifically weighs the efficacy of differing treatment regimes. Through the system, the doctors are compulsory to utilize scientific databases that provide accurate information as to which treatments are working or not. Next, the quality priority shift due to technology advance. By advancing technology, the health priorities change as the root causes of health problems and new health threats come to light. Marketing for healthcare organizations is only managing the perception of quality by responding to customer satisfaction concerns. But, organizations also need to optimize real health outcomes. The quality of healthcare organizations needs to be understood in the scope of rising costs and changing treatment regimes. There are many issues related to medical industrial complex or can be describe as medical system. Firstly, issues according to positioning and resistance to change. ‘Affordable care’ is now the marketing buzzword used to justify any new ways in healthcare. This ‘affordable care’ is proposed by the government or politician. As the players in the medical system increased, it’s hard to change. The importance of strategies to develop a political consensus among the fragmented players in the healthcare system is apparent. As institutional processes and bureaucratic procedures become entrenched, healthcare systems are even more difficult to change. As a consequence, healthcare marketing, especially the type that would usefully improve health outcomes has become complicated by systemic problems due to the structure of the healthcare system. Next issues are about systemic problems. The systemic problems of healthcare can be examining through spending figure. Healthcare costs are higher due to the wage requirement. As an example in United State, the doctors are paid much more than their counterparts in other countries. Medical test and procedures are employed more frequently. USA is the major profit centre for pharmaceutical companies, who are able to price their products higher due to any lack of price controls. As medical costs are shifted to hospitals, the effect is to raise costs to other services as the burden is shifted to paying customers. As the cost is rising, it leads to many effects. The effects are health insurers and health management groups do not necessarily improve the overall the efficiency of the healthcare system. Market solutions are not apparent when it comes to healthcare. Thus, there is a dilemma in health reform. In the prospects for healthcare marketing, it has certain important contribution. There are two broad healthcare marketing problems which are relevant that would stand a chance of improving healthcare. The first is the important problem of consumer access to information that would improve patient healthcare decision-making. The second is the problem of the organizational diffusion of information which providing better access to â€Å"evidence-based medicine† to improve healthcare practice. Better publicizing treatment information and setting standards could improve healthcare and the role of marketing to positively affect health outcomes through promoting awareness of disease prevention measures is highly important. Some changing also may lead to the cost and organizational problems. Target marketing, specialization and fragmentation are important in maximizing health outcomes. The discipline of marketing provides tools and techniques for companies to profitably target consumer segments. Certain healthcare organizations have been able to profitably and effectively maximize the quality of outcomes for particular patient groups and in the process, have become increasingly specialized. However, as the healthcare system grows fragmented and specialized, issues of both cost and quality have been raised. Through DTC advertising and new marketing concerns, the educational quality of DTC can motivate discussions that enhance visit efficiency, patient/physician trust, patient satisfaction, or health outcomes. They found that while consumer attitudes are largely neutral, physician are usually negative, being distrustful of pharmaceutical promotions. There is new challenge in healthcare marketing. But, there are also ways to facing it. Public awareness of marketing campaigns can have an important impact. Given the behavioural aspects of many health problems, however, promotions alone can have limited effectiveness. Persuading people to change behaviours is a much more difficult problem than informing them about risks. Moreover, funding for better health awareness needs to be reconsidered as a public spending priority. Consumers (and their employers or insurers) make healthcare decisions within quasi-market system, and better access to salient healthcare information is clearly needed. Organizations clearly need to critically review treatment delivery systems to avoid mistakes and improve quality. Both consumers and healthcare organizations would benefit from more transparent systems to support healthcare decisions. The marketing challenge in healthcare is to develop and sustain better healthcare relationships for consumers. In my opinion, the marketing in healthcare systems is very significant due to its important role in providing the healthcare service also aiding the health information for consumer. In addition, healthcare organizations usually will face many types of marketing issues and problems as organizations, technologies health problem keep shifting and changing. The healthcare industry should engage in new thinking in understanding about their customers. They should find inspiration from other industries by scrutinizing the competition, health reform, consumer demands or the way they get to know their customers, moving beyond basic transactions and embracing their patients. Several service industries outside of healthcare are helping shape healthcare consumer experiences and expectations. Today’s technologically savvy consumers prefer to do their own research when selecting a doctor, investigating treatment options, and making major health care decisions. Targeted marketing also enables organizations to tailor communications to each stage of the member relationship. By identifying customer needs and be more prepared for the challenges and focused on raising the benefits of the healthcare services would markedly result in customer satisfaction and loyalty. Such situation can be illustrated by the recent big news when famous actress Angelina Jolie announced in a New York Times op-ed article on Tuesday 14 May 2013 that she underwent a preventive double mastectomy after learning that she carries a mutation of the BRCA1 gene, which sharply increases her risk of developing breast cancer and ovarian cancer. She signifies the empowered patient by deciding to be proactive in her health decision making!

Explain Child Protection Within the Wider Concept of Safeguarding Children and Young People

All those working with children have a professional responsibility to safeguard and protect children. Child Protection is a highly emotive subject, evoking strong feelings in most people. In order to provide the most effective support and help for vulnerable children and their families, all staff managing services and involved in working directly with children need to be able to acknowledge their feelings and examine their different values and beliefs. Every child can be hurt, put at risk of harm or abused, regardless of their age, gender, religion or ethnicity.Safeguarding legislation and government guidance says that safeguarding means protecting children from maltreatment, preventing impairment of children’s health or development, ensuring that children are growing up in circumstances consistent with the provision of safe and effective care.Child protection is a part of safeguarding and promoting welfare. This serves to protect specific children who are suffering or are at risk of suffering significant harm. Safeguarding the welfare is clearly important and involves quite a lot including promoting their interests, keeping them safe and protecting their interests.The ‘Staying Safe’ action plan published by the government in 2008 highlighted a number of key points which include:Road safety and safety on the streetsBullyingSafety while using the internet and other technologyYoung runaways and missing childrenSubstance misuse by young peopleGuidance for safeguarding disabled childrenIt is very important that everyone that works with children and young people be aware of the safeguarding procedures and know how to respond to any concerns about the children’s welfare and safety.All children and young people have the right to grow up in safety and adults have a duty to protect them from being harmed or abused in any way. Where parents fail to ensure a child’s safety and are unable to protect their children, the local authorities se e it fit to step in and provide protection for the child on the basis of the Children Act 1989. This act forms the legal framework for child protection and is the key legislative document for children and families.

Why the Quran was written in Arabic Research Proposal

Why the Quran was written in Arabic - Research Proposal Example If a person set a target of ten words to learn in a day, it would only take them7 months to learn the Quran. The Quran is believed to have been written in Arabic; the language that was first revealed to the prophet through the angels. As evident from the Holy Quran Chapter 14 verse 4 states â€Å"And we never sent a messenger save with the language of his nation, that he might make (our revealed message) clear for them†. 2Arabic was regarded as the language of the prophet and that of his people and thus the best way to convey a message to the chosen people would be through the language most used by the people. Arabic was the language of the last messenger of Allah, Muhammad. Some scholars see no religious inclination there as they felt it was only natural for an Arab to write exclusively in his native language.3 It would make no sense for the Holy Quran to be inscribed in any other language for the use by the Arabs. The Quran is not written by the Prophet nor was it his invention but was dictated to him by the spirit and angel of Allah. It is important for Muslim faithful’s to accept that it was through the miracle of Angel Gabriel revealing God’s word to the prophet that the Quran came to existence. This project is imperative in this day and age. It is important to iron out this issue once and for all to help improve cohesiveness and unity between practicing faithful’s of different religions. Many people who do not understand the Arabic language- those who cannot speak or read it feel left out from the teachings of the Quran, and thus the major significance of this project will be to help them understand the truth behind the choice of language. To remove all doubt that the Quran is the message from God Allah the most high and not the writings of his messenger prophet Muhammad will also help all skeptics; Muslims

Six Flags Magic Mountain Theme Park Essay Example | Topics and Well Written Essays - 750 words

Six Flags Magic Mountain Theme Park - Essay Example It is thus about how she manages to handle her life despite deciding to have the baby, and the kind of impact the situation has on her maturity and lifestyle. The movie has gained worldwide recognition due to it being able to address a large audience on a global scale that has been able to relate with every aspect of it. Juno has a very basic story line as well as concept attached to the tale; it is about a young girl trying to explore the nooks and crannies of intimacy and relationships without understanding the implications that might arise along with the same. The film has been directed in a very concise manner making use of pencil stylized ‘rotoscoped’ images right from the credits in the beginning, making use of animation in order to help the audience understand the maturity level of the girl and the kind of colourful life that she always wanted to live for herself. The film helps teenagers to explore the kind of curiosity that reigns within them, and how the same s hould be understood not by simply jumping in and trying things out with friends, but by reading about things and comprehending the facts about life from one’s parents first. It helps children and young adults to understand how friends might not be the best option when it comes to understanding such information about pregnancy and intercourse. These aspects of life are crucial to one’s existence and they must be understood well by every individual so that he is able to make his own decisions without falling into trouble or having unplanned circumstances crop up in his life. (Sciretta, Peter) Thus, the film achieved mass appeal because of the story telling as well as how the girl managed to learn her lesson without panicking much about the situation. The various characters within the movie have been portrayed in a very interesting manner. The director has taken his time to choose the main protagonists and provide them with a different twist. Juno is a young teenage girl who comes off a little strong on the first meeting with everyone. Full of sarcasm, she helps to put an indie spin on the movie and gives a very intense performance with her dominating nature and need to control everything that might not even be in her reach. However, she understands where she went wrong by getting pregnant but decides to bring about a change in a couple’s life with the help of her baby who she is willing to give up in order to make someone else happy. The film has been divided into various chapters, giving the film a very succinct outline. The one thing that sets this movie apart is the idea of Juno trying not to become a victim of the situation she was thrust into, and rather treat the predicament as a stepping stone and move ahead in life, having learned a lesson. Juno’s bedroom as well was a very cleverly designed set as it helped to appeal to the minds of most young teenagers, showing how most young people keep their rooms; messy as well as clean e nough to find things around. Posters helped to indicate the girl’s interests to the sub conscious mind of the audience as objects like her famous ‘hamburger phone’ helped to show hoe different and varied her interests were and that she was just another ‘random’ teenager trying to find her way through life. The rooms of Paulie as well as Juno’s friend Leah have also been designed well, depicting what other teenagers like; Leah’s room being covered with posters of older men trying to signify her level of maturity when it comes to accepting love and Paulie’s looked neat with his mother bumping in several scenes showing how she might be the reason behind his cleanliness, like most teenage boys these days. Most of the