Premium Essay

Homework

In:

Submitted By Kadala1293
Words 424
Pages 2
CHAPTER 3
Hands-On Assignments
1. Create a new table containing the category code and description for the categories of books sold by JustLee Books. The table should be called CATEGORY, and the columns should be CatCode and CatDesc. The CatCode column should store a maximum of 2 characters, and the CatDesc column should store a maximum of 10 characters. create table category
(CatCode varchar2(2), CatDesc varchar2(10));,
2. Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The table name should be EMPLOYEES. The Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldn’t be padded if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five-digit number. Use column sizes you consider suitable for the Firstname and Lastname columns. create table EMPLOYEES
(Emp# number(5,0), Lastname varchar2(12), Firstname varchar2(12), Job_Class char(4));
3. Add two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment for each employee, and its default value should be the system date. The second column, named EndDate, contains employees’ date of termination.
Alter Table EMPLOYEES
Add (Empdate Date Default System, EndDate Date);
4. Modify the Job_class column of the EMPLOYEES table so that it allows storing a maximum width of two characters.
Alter Table EMPLOYEES modify (Job_Class char(2));
5. Delete the EndDate column from the EMPLOYEES table.
Alter Table EMPLOYEES drop column EndDate;
6. Rename the EMPLOYEES table as JL_EMPS.
Rename Employees To JL_EMPS;
7. Create a new table containing these four columns from the existing BOOKS table: ISBN, Cost, Retail, and Category. The name of the ISBN column should be ID, and the other col- umns should keep their original names.

Similar Documents

Free Essay

Homework Lance Online Homework Help

...http://homeworklance.com/downloads/acc-202-entire-course/ http://homeworklance.com/downloads/acc-206-entire-course/ http://homeworklance.com/downloads/acc-310-entire-course-week-1-5-latest/ http://homeworklance.com/downloads/acc-340-complete-course-material-wk-1-5-a/ http://homeworklance.com/downloads/acc-400-entire-course-final-exam-guide/ http://homeworklance.com/downloads/acc-407-entire-course-advance-accounting/ http://homeworklance.com/downloads/acc-423-entire-course/ http://homeworklance.com/downloads/acc-455-entire-course-asolution/ http://homeworklance.com/downloads/acc-556-entire-course-forensic-accounting/ http://homeworklance.com/downloads/acc-556-entire-course-forensic-accounting-2/ http://homeworklance.com/downloads/acc-557-complete-course-material/ http://homeworklance.com/downloads/acc-557-full-course-new-updated-2014/ http://homeworklance.com/downloads/acc-561-complete-course-material/ http://homeworklance.com/downloads/acct-212-financial-accounting-complete-course/ http://homeworklance.com/downloads/acct-504-accounting-finance-managerial-use-analysis/ http://homeworklance.com/downloads/acct-505-managerial-accounting-entire-course/ http://homeworklance.com/downloads/ajs-532-entire-course-week-1-6-complete-course/ http://homeworklance.com/downloads/ajs-582-entire-course/ http://homeworklance.com/downloads/bcom-275-complete-course-material/ http://homeworklance.com/downloads/beh-225-entire-course-weeks-dqs-assignments/ http://homeworklance.com/downloads/bis-155-complete-course-material/ ...

Words: 1331 - Pages: 6

Premium Essay

French Homework

...Present tense introduction to Holiday Coursework. You will need to write at least 50 – 70 words to talk about what you normally do during your summer holidays. You will need to include where you usually go/ stay/ travel/ what you do and give lots of opinion. Use the table below to help you with timewords and extra information Use www.languagesonline.org.uk to revise weather/ sports and present tense to help you with your work. |Timewords |Weather phrases |Extra’s | |Normalement - normally |Il fait beau/ chaud/ froid/ |Dans ma chambre –In my room | |D’ahbitude = usually |It is nice/ hot/ cold |Il ya - there is | |Chaque année – every year |Il y a du soleil/ vent – it is sunny/ windy |Une salle de jeux – a games room | |Les matins – in the mornings | |Un vue sur la mer – a view of...

Words: 263 - Pages: 2

Free Essay

Homework Should Be Banned

...Trouville English CP III 15 December 2015 Should Schools Be Done with Homework? Have you ever enjoyed a day of relaxation? Have you ever experienced the thrill of having a day just to goof off? Has homework kept you away from that? Kids hate homework. Some kids say that homework is just what they learned in class the same day and they are just repeating it. Why do students need to repeat what we did in class that day? Is it necessary? Some reasons why homework is not effective is that many teachers give too much homework, and often teachers do not coordinate the quantity given. Secondly, unnecessary assignments raise the stress level of the students. However, the main argument against homework is that most of it is just boring practice. Teachers give too much homework to kids and it’s not necessary. In an article written by Lance J. Falk it states that “kids have lives beyond school and schoolwork. About 65 percent of kids, ages of 6-13, play competitive sports. But, unfortunately, some of those kids quit playing the sport they love due to the fact that they have too much schoolwork to tackle during their evening” (Falk). If a student has three soccer practices a week, which consumes 2.5 hours of his Monday, Wednesday, and Thursday afternoons, how do you think he or she feels? He or she would obviously feel very tired, right? But now if that same student had two hours of homework three of the five days that he or she has school he or she would feel exhausted...

Words: 805 - Pages: 4

Premium Essay

Too Much Homework?

...Too Much Homework? It's all over the news: kids are spending a lot of time on homework. And, according to some, it's way too much. With the current emphasis on high-stakes testing, educators are trying to do more with less, which can result in an overabundance of schoolwork outside of school. Some critics say there is no evidence to suggest that homework is helpful to student achievement; on the contrary, too much of it can overwhelm students and cause them to disengage. Others, however, claim that homework is necessary and helpful, designed so students can practice the concepts taught in class, build good study habits, and reflect on their own learning. As an eleventh grade student who is in advanced and ap classes, I think that homework is the cause of my depleting grades. Now, you’re probably going to think that I’m like any other kid in high school that hates homework and that to even spend another second reading this will be a complete waste of time, right?Even so, just hear me out because I have several reasons that might just change your mind. I have thousands of assignments every week; most of them homework assignments. As a result, I’m cascaded with homework every day, causing me to stay up until 11 o’clock at night more often than not. Obviously, this is a threat to my health as a developing teenager. It could stunt my growth, and result in fatigue and stress because everyone knows that no good sleep leads to no good grades. Even if I were...

Words: 697 - Pages: 3

Premium Essay

Homework Assignment 1

...Homework Assignment 1 Natasha Dodson Allied American University Author Note This paper was prepared for [ENG 160], [HOMEWORK ASSIGNMENT 1] taught by [MARC THOMPSON]. Essay Writing: Part 1 PART I I. Introduction II. Body A. Traveling 1. Luggage 2. People 3. Airlines B. Vendors 1. Restaurants 2. Souvenir Shops 3. Massage and Relaxation C. Security Measures 1. Police 2. Transportation Security Administration and Homeland Security 3. Random baggage checks III. Conclusion PART II 1. What is the thesis of Johnson’s essay? If it is stated directly, locate the relevant sentence or sentences. If it is implied, state the thesis in your own words. In my opinion the thesis of Lou’s Place is implied. It does imply that Lou and his customers have an unspoken bond and fondness for one another, even though they belittle each other and the customer pays to pour their own coffee. Lou’s Place is not that place where the service is perfect or the conversation is polite. It is that place where you can be yourself; cook your own eggs and where service is not at all prompt. It is almost as if you are at home with family and friends. You will be criticized before you even find a complement. 2. Which statement would best serve as a topic sentence for paragraph 13? Explain why. I think the best topic sentence for paragraph 13 would be “Regular customers at Lou’s are used to...

Words: 870 - Pages: 4

Premium Essay

Homework Policy

...Homework is an issue that affects both students and teachers on a daily basis. As teachers we must expect great things from our students and for our students to achieve great things, we need them to study and do work at home to help emphasize new information and concepts being taught in the classroom. Teachers must teach self- motivation and actively engage their students to do homework and study on a nightly basis. For students as well as their families homework can often be seen as chore that they must find time for between afterschool activities, their parents work schedules, and just wanting to play. Teachers must find just the right balance of homework to help reinforce what is being taught in the classroom while allowing for family time as well as accommodating the busy schedules many American’s face. Ms. Zalogwe has a zero-tolerance homework policy due to problems with students and homework in the past. She clearly lays out the policy at the beginning of the year and sends parents a handout so that they are also informed of her policies. It is important as a teacher to clearly explain to students as well as their parents exactly what is expected from them. I do believe a teacher should allow for some flexibility in their homework policies, while at the same time teaching self-motivation. Homework should reinforce what is being taught in the classroom and allow for positive social interaction. Homework should accommodate the varying learning levels found in the classroom...

Words: 2317 - Pages: 10

Free Essay

Book Review: the Homework Myth

...Book Review The Homework Myth: Why Our Kids Get Too Much of a Bad Thing by Alfie Kohn University of Montevallo EDF561: Evaluations in Education Susan Scott Alfie Kohn’s (2006) book, The Homework Myth: Why Our Kids Get Too Much of a Bad Thing, gave me food for thought. Kohn opposes homework of any kind in any form for any grade level. He explores each commonly given, pro-homework argument in an attempt to persuade his readers, both parents and teachers, of the uselessness and possibly detrimental effects of the long-standing educational tradition. The first claim Kohn (2006) makes is that our children are “missing out on their childhoods” (p. 3). His opinion is that children spend seven hours in school everyday; that should be enough. He argues that kids need more time to be kids. Such time would include family time, friend time, time spent in extracurricular activities such as sports, music and art lessons, and play groups for younger kids. I agree. Kids do need time to enjoy their childhood. It is the most carefree time of their lives, relatively speaking. Does that mean they should have no homework at all? I am not yet ready to agree completely with that attitude. “Does homework improve learning?” Kohn (2006, p. 25) asks. The most significant issue he raises, in an attempt to answer that question, is regarding the kind of homework about which we are talking. Assignments can range from useless, fill-in-the-blank worksheets to extended projects that...

Words: 1079 - Pages: 5

Premium Essay

Harmful Homework

...Homework: Helpful or Harmful? Is homework harmful or helpful? In today’s education system, schools are preparing students for college by pressuring them to increase their test scores. Test scores seem to provide educators with a good standpoint of the student’s intelligence level. Therefore, educators have been ordering homework to be done since elementary school. A Countless number of students are being assigned a great amount of homework every day because educators think that it is essential and helpful. However, too much homework has seemed to negatively affect students in many ways. In recent studies, there has been a widespread call to realize the disadvantages of homework due to the strain it puts on students. Although homework may seem favorable because it seems to keep students busy and working, homework should not be considered the primary tool to improve students since homework medically affects students, is time consuming, and interferes with family life. Homework has medical affect on students since they are becoming sleep deprived as they struggle to complete a homework assignment that is due the next day. Studies show that students are now taking more risks due to excessive amounts of homework that cannot be completed efficiently in a given time. According to CNN Health’s Medical Assignment Manager Ann J. Curley, studies conducted show that more than two-thirds of American students report they are getting less than eight hours of sleep on school nights, which is...

Words: 1036 - Pages: 5

Free Essay

Netw 204 Homework Assignments Package Latest

...NETW 204 HOMEWORK ASSIGNMENTS PACKAGE LATEST To Purchase this tutorial visit following link http://wiseamerican.us/product/netw-204-homework-assignments-package-latest/ Contact us at: SUPPORT@WISEAMERICAN.US NETW 204 HOMEWORK ASSIGNMENTS PACKAGE LATEST NETW 204 Homework Assignments Package Latest NETW 204 WEEK 1 HOMEWORK ASSIGNMENT NETW 204 WEEK 2 HOMEWORK ASSIGNMENT NETW 204 WEEK 3 HOMEWORK ASSIGNMENT NETW 204 WEEK 4 HOMEWORK ASSIGNMENT NETW 204 WEEK 5 HOMEWORK ASSIGNMENT NETW 204 WEEK 6 HOMEWORK ASSIGNMENT NETW 204 HOMEWORK ASSIGNMENTS PACKAGE LATEST NETW 204 Homework Assignments Package Latest NETW 204 WEEK 1 HOMEWORK ASSIGNMENT NETW 204 WEEK 2 HOMEWORK ASSIGNMENT NETW 204 WEEK 3 HOMEWORK ASSIGNMENT NETW 204 WEEK 4 HOMEWORK ASSIGNMENT NETW 204 WEEK 5 HOMEWORK ASSIGNMENT NETW 204 WEEK 6 HOMEWORK ASSIGNMENT NETW 204 HOMEWORK ASSIGNMENTS PACKAGE LATEST NETW 204 Homework Assignments Package Latest NETW 204 WEEK 1 HOMEWORK ASSIGNMENT NETW 204 WEEK 2 HOMEWORK ASSIGNMENT NETW 204 WEEK 3 HOMEWORK ASSIGNMENT NETW 204 WEEK 4 HOMEWORK ASSIGNMENT NETW 204 WEEK 5 HOMEWORK ASSIGNMENT NETW 204 WEEK 6 HOMEWORK ASSIGNMENT NETW 204 HOMEWORK ASSIGNMENTS PACKAGE LATEST NETW 204 Homework Assignments Package Latest NETW 204 WEEK 1 HOMEWORK ASSIGNMENT NETW 204 WEEK 2 HOMEWORK ASSIGNMENT NETW 204 WEEK 3 HOMEWORK ASSIGNMENT NETW 204 WEEK 4 HOMEWORK ASSIGNMENT NETW 204 WEEK 5 HOMEWORK ASSIGNMENT NETW 204 WEEK 6 HOMEWORK ASSIGNMENT NETW 204 HOMEWORK ASSIGNMENTS PACKAGE...

Words: 413 - Pages: 2

Premium Essay

Homework Is an Effective Way to Supplement Classroom Learning

...dismayed upon hearing those words from the teacher? Homework has long been a way to supplement students’ learning outside the classroom. This has also kept students busy every night, staring at their computer screens studying or researching about their assigned school work. Homework, in a way, is a good way of maintaing the knowledge students gained from school, but is it really the most effective way of providing supplemental studies? Most studies have shown that homework may be more supplemental than being detrimental to a student’s learning. On one perspective, it has been proven that assigning homework is beneficial to a student’s performance in school. Evidence has been found that homework is an effective supplemental form of learning, and “can impact positively on the retention and understanding of knowledge and can improve study skills...and demonstrate that learning can take place outside of formal schooling,” (qtd. in Department of Education and the Arts 7). This shows that studying should not just be confined to the walls of the classroom, and that after-school learning is vital to reinforce what has been taught by the teacher to the students. Without this reinforcement, students might easily forget the concepts learned in the classroom. Thus, this would result to a poor evaluation performance. This is especially true to students who do not pay attention during Evaristo 2 class time. Because of homework, they would be forced to study the lesson, and soon enough...

Words: 1193 - Pages: 5

Premium Essay

College Homework Help

...COLLEGE HOMEWORK HELP Through college homework help, we aim to provide you with all necessary material and solution you require for the understanding of whole of your college’s curriculum. If you are searching for homework help from experts who are well-read in the subjects of mathematics, calculus, statistics and algebra you have come to right place. All scholars are verified degree holders who have years of experience helping students with their maths, accountancy and English problems. Here you can submit anything from simple queries to complex or lengthy assignments and receive expert guidance to help you develop fully-worked solutions. We can assist with any type of project - homework assignments, practice questions, laboratory write-ups, and more. Every subject has its own characteristics like English you need to learn writing skills and in maths you need to learn formulae but every subject demands a single similar thing that is dedication and if you are dedicated to actually learn a subject our experts are equally dedicated to teach you that. Generally, classroom lectures are not enough for the student to be able to cope up with the complexities of problems given for homework, and that is why additional homework help is so essential. College homework help provided by expert and qualified tutors has been always proved to be of immense help and has often been back bone support for students who do well in class. Having problems with your homework or feeling too lazy to figure...

Words: 404 - Pages: 2

Premium Essay

Why We Should Homework Be Required Essay

...Since Roberto Nevilis introduced it to the world as a punishment in 1905, there have been many arguments to whether or not homework should be required. What initially started as punishment for kids who messed around in class has become a mandatory task that all students are required to do daily. I’m here to end that, I intend to show you that students should not be required to complete homework for a grade. Homework consumes too much time and leaves no space for extracurricular activities and causes health problems. On top of that, many students don’t even have the resources required to complete the homework. Despite these things, homework is still a graded assignment that if failed to complete, can drastically bring down a student's grade. Consider the fact that the American standards for homework is much lower than anywhere else in the world. CNN conducted a study that showed that on average, in America students receive three times more homework than the recommended amount. 56% of students said that homework is a primary source of stress and frustration. Stress causes a vicious cycle. It can lead to heart diseases, depression, exhaustion, and pain, which in turn lead to more stress....

Words: 743 - Pages: 3

Premium Essay

Acct 301 Homework Assignments Week 1 to 7

...ACCT 301 HOMEWORK ASSIGNMENTS WEEK 1 TO 7 To purchase this visit following link: http://www.activitymode.com/product/acct-301-homework-assignments-week-1-to-7/ Contact us at: SUPPORT@ACTIVITYMODE.COM ACCT 301 HOMEWORK ASSIGNMENTS WEEK 1 TO 7 ACCT 301 Homework Assignments Week 1 To 7 ACCT 301 Week 1 Homework (Problems & Solutions) ACCT 301 Week 2 Homework (Problems & Solutions) ACCT 301 Week 3 Homework (Problems & Solutions) ACCT 301 Week 4 Homework (Problems & Solutions) ACCT 301 Week 5 Homework (Problems & Solutions) ACCT 301 Week 6 Homework (Problems & Solutions) ACCT 301 Week 7 Homework (Problems & Solutions) Activity mode aims to provide quality study notes and tutorials to the students of ACCT 301 Homework Assignments Week 1 To 7 in order to ace their studies. ACCT 301 HOMEWORK ASSIGNMENTS WEEK 1 TO 7 To purchase this visit following link: http://www.activitymode.com/product/acct-301-homework-assignments-week-1-to-7/ Contact us at: SUPPORT@ACTIVITYMODE.COM ACCT 301 HOMEWORK ASSIGNMENTS WEEK 1 TO 7 ACCT 301 Homework Assignments Week 1 To 7 ACCT 301 Week 1 Homework (Problems & Solutions) ACCT 301 Week 2 Homework (Problems & Solutions) ACCT 301 Week 3 Homework (Problems & Solutions) ACCT 301 Week 4 Homework (Problems & Solutions) ACCT 301 Week 5 Homework (Problems & Solutions) ACCT 301 Week 6 Homework (Problems & Solutions) ACCT 301 Week 7 Homework (Problems & Solutions) Activity mode aims to provide quality study notes and tutorials to the students...

Words: 631 - Pages: 3

Premium Essay

Limiting Homework

...a teacher who gives you something to take home to think about besides homework.” Actress Lily Tomlin is correct. When students get home after a six-hour school day they are often overwhelmed with outrageous amounts of homework. This extra and sometimes unnecessary burden adds only anxiety to the average student leaving them a slave to their homework. This is a problem that can be alleviated with time and patience. Students are not happy with their current homework loads. Sixty-one percent of students in a recent survey concluded that they had to drop out of an activity because of their school workload (Galloway et al 2013). Obviously, homework affects students’ lives more than it should. It is not just something that a student would just finish in five to ten minutes. It takes hard work and brain dedication to finish homework at the time that it is required. One of the reasons that homework should be banned is because it is...

Words: 943 - Pages: 4

Free Essay

Homework Psychology

...Homework Assignment Student: Guilherme Henrique Domingos de Franco LAB Section: 044 Access ID number: 004520890 Assignment 3a – Describe how the two-point discrimination experiment was conducted and the results What materials were used? One caliper, one ruler and notes sheet. How many participants (number of students who responded to the caliper touches)? 6 students. Explain what the experimenter did. The classroom was divided into 6 groups of 4 students in each group. Student number 1: responsible for feeling the sting of the caliper. Student number 2: responsible for sticking the student number 1. Student number 3: responsible for write down the results. Student number 4: moral support. Experiment: the student number 1 extended his arm to receive the nudge without seeing how many points the student number 2 was using. The student number 2 chooses the distances between the points and if he would poke finger or forearm randomly so that the student number 1 would not be influenced by the order of the distances. The student number 3 wrote if the student number 1 felt one point or two. State the percentage of participants who felt two points at each of the six distances on the finger. 0.0 cm - 0% 0.5 cm - 80% 1.0 cm - 100% 1.5 cm - 100% 3.0 cm - 100% 5.0 cm - 100% State the percentage of participants who felt two points at each of the six distances on the forearm. 0.0 cm - 0% 0.5 cm - 20% 1.0 cm - 20% 1.5 cm - 60% 3.0...

Words: 559 - Pages: 3