Free Essay

Lesson 3

In:

Submitted By manifestk78
Words 1035
Pages 5
ITCS215: Lesson Three Worksheet |

Student Name:

Instructions:

This worksheet will assist you in completing your assignments for this week. Save this worksheet as lastname_Lesson3.docx and submit.

You are required to complete all sections indicated by red brackets. You will replace the red brackets and text with the indicated material. For example, for the “Student Name” section above, a completed response would look like this:

Student Name:

When responding with text, please leave the text red so that your instructor will be able to find your responses easily. When pasting an image, please replace the red text with the image.

Total Points: 37

Assignments:

Review Questions - Short Answer Short Answer - Review Questions, Chapter 6: Questions 1, 5, 7, and 15. Student is to complete in Short Answer format:

a) Define the term user view as it applies to database design.
Saved queries created with SQL. User views specify which users are permitted access to what data in a database.

5. Describe the function of each of the following types of keys: primary, alternate, secondary, and foreign.
Primary Key: The primary key is a attribute or a set of attributes that uniquely identify specific instance of an entity. Every entity in the data model must have a primary key whose values uniquely identify instance of the entity. Sometimes a record may contain more than one key field.
Primary key is selected from one of the candidate key and the remaining keys are called alternate keys.
Alternate Key: The alternate keys of any table are simply those candidate keys, which are not currently selected as a primary key.

Secondary key
A field or combination of fields that is basis for retrieval is known as secondary key. Secondary key is a non-unique field. One secondary key value may refer to many records. Foreign Key: A foreign key is an attribute or combination of attribute in a relation whose value match a primary key in another relation. The table in which foreign key is created is called as dependent table. The table to which foreign key is refers is known as parent table.

7. A database at a college is required to support the following requirements. Complete the information-level design for this set of requirements. Use your own experience to determine any constraints you need that are not stated in the problem. Represent the answer in DBDL.

a) For a department, store its number and name.
DEPARTMENT (DEPT_NUMBER, DEPT_NAME) b) For an advisor, store his or her number and name and the number of the department to which he or she is assigned.
ADVISOR (ADVISOR_NUMBER, DEPT_NUMBER)
DEPARTMENT (DEPT_NUMBER, DEPT_NAME)
c) For a course, store its code and description (i.e., MTH110, ALGEBRA).
COURSE (COURSE_CODE, COURSE_DESCRIPTION)
d) For a student, store his or her number and name. For each course the student has taken, store the course code, the course description, and the grade received. Also, store the number and name of the student’s advisor. Assume that an advisor may advise any number of students but that each student has just one advisor.
STUDENT (STUDENT_NUMBER, STUDENT_LAST, STUDENT_FIRST, ADVISOR_NUMBER)
ADVISOR (ADVISOR_NUMBER, ADVISOR_NAME)
COURSE (COURSE_NUMBER, COURSE_DESCRIPTION)
GRADE (STUDENT_NUMBER, COURSE_NUMBER, COURSE_CODE, GRADE)
AK SOC_SEC_NUMBER
SK STUDENT_LAST
FK STUDENT_NUMBER --> GRADE
FK COURSE_NUMBER --> GRADE STUDENTSTUDENT_NUMBERSTUDENT_LASTSTUDENT_FIRST | COURSECOURSE_CODECOURSE_DESCRIPTIONGRADE | ADVISORADVISOR_NUMBERADVISOR_LASTADVISOR_FIRST STUDENT_NUMBER |

15. For each of the following collections of relations, give the assumptions concerning the relationship between students, courses, and faculty members that are implied by the collection. In each relation, only the primary keys are shown. a. Student ( StudentNum, CourseNum, FacultyNum)
In the first row StudentNum we can see the CoursesNum and we see the FacultyNum who gives the class. Such a relationship is called a many-to-many relationship.

b. Student ( StudentNum, CourseNum)
In these rows Student has also a many-to-many relationship.
Faculty ( CourseNum, FacultyNum)
In these rows Faculty has one-to-one relationship by including the primary key (FacultyNum) of one of the tables as foreign key in the other table.

c. Student ( StudentNum, CourseNum)
Faculty ( CourseNum, FacultyNum)
StudentFaculty ( StudentNum, FacultyNum)
There are separate many-to-many relationships between students and courses; courses and faculty members; and students and faculty members.

d. Student ( StudentNum, CourseNum, FacultyNum)
There is a many-to-many relationship between students and courses. A given student number-course number combination uniquely determines a faculty number. That is, when a student takes a course, a single faculty member teaches the course.

e. Student ( StudentNum, CourseNum)
Faculty ( CourseNum, FacultyNum)
StudentFaculty ( StudentNum, FacultyNum)
All of them from c to e have many-to-many relationship

Premier Products Exercises-Short Answer Complete Premier Products Exercises, Chapter 6: Questions 1 and 4. Student is to complete in Short Answer format below:

1. Indicated the changes you need to make to the design of the Premiere Products database to support the following situation. A customer is not necessarily represented by a single sales rep but can be represented by several sales reps. When a customer places an order, the sales rep who gets the commission on the order must be one of the collection of sales reps who represents the customer.

Remove the RepNum column from the Customer table. Add a new table:
CustomerRep (CustoermNum, RepNum)
FK CustomerNum  Customer
FK RepNum  Rep

Change the Orders table to:
Orders (OrderNum, OrderDate, CustomerNum, RepNum)
FK CustomerNum, RepNum CustomerRep

4. Indicate the changes you need to make to the Premiere Products database design to support the following situation. The region where customers are located is divided into territories. For each territory, store the territory number ( a unique identifier) and territory name. Each sales rep is assigned to single territory. Each customer is also assigned to a single territory, which may not be the same as the territory to which the customer’s sales rep is assigned.

Add the following table:
Territory (TerritoryNum, TerritoryName)
Add the TerritoryNum column to the Rep table as a foreign key:
FK TerritoryNum  Territory

Henry Books Case Study Complete Henry Books Case, Chapter 6: Question 1. Student is to complete in Short Answer format below:

1.Design a database for Ray. He is interested in movie DVDs and wants to keep information on movies, actors, and directors in a database. The only user is Ray, and he needs to produce the following reports:

Similar Documents

Premium Essay

Lesson 3 Essay

...Lesson 3 Essay Questions: 1- Compare and contrast directional selection and disruptive selection, and provide an example of each. Directional selection occurs when one extreme of a trait is favored and the distribution curve shifts in that direction. An example of this is the human struggle with malaria. The mosquito Anopheles transmits the disease. A new drug for the disease and a insecticide for the mosquito was created. But over the years they became resistant to it and multiplied, shifting the distribution curve toward the resistant type of parasite. Disruptive selection is where any two extremes of a trait are favored over any intermediate phenotype. For example, British land snails are found in low vegetation areas. The thrushes feed on snails with dark shells and in the forest they feed on snails with light banded shells. So each phenotype adapted to their environment. (Mader & Windelspecht, 2012) 2- Many pathogenic bacteria species are becoming resistant to antibiotics. Explain how such adaptations can develop through the process of natural selection. (Hint: Relate this example to the conditions that are necessary for natural selection to occur.) Natural selection is the process that results in adaptation of a population to the environment. This is what happens with antibiotic resistant bacteria. When antibiotic is administered, some bacteria may survive because they are genetically resistant. This bacteria will pass on their genes to the next generation. As...

Words: 635 - Pages: 3

Premium Essay

Multicultural Lesson Plan

...Lesson Plans Lesson plans will be filled out on how to use Dolch words to help improve reading. 1. Are the objectives aligned with academic standards? Yes State how the lesson objectives support the academic standards. The lesson will help students in grades Pre-K, K and 1st to understand how to read. 2. Are the assessments aligned with the objectives? Yes Is it explicitly clear what the students should know and be able to do by the end of the lesson? Yes, the students should know a certain number of dolch words by a certain date. What is the evidence demonstrating mastery of knowledge and/or skills that will support the lesson objectives? Documentation of the words correct on paper. 3. Are the learning experiences relevant to the objectives? Yes 4. Is instruction differentiated? Yes, EEL and Special Education students will have flash cards, I-pads to help pronounce the words, memory match. How will ELL or special needs students benefit from these lessons? To help them build up their vocabulary by learning the basic and more frequent words. Name the activities that support learning modalities, gender, or cultural groups. 5. Are there frequent and multiple ways to check for understanding during instruction? List the strategies to check for understanding. Include other strategies not in the lessons that could be utilized to further check for student understanding. • Spelling test • Memory test • Flash card • Reading probes • Printable worksheets ...

Words: 469 - Pages: 2

Premium Essay

Vietnam Legacy Lesson Plan

...DEMO LESSON Lesson Plan in Language in Literature II Afro-Asian Literature I. Subject Matter: Vietnam Legacy Reference: Language in Literature Afro-Asian Literature (p. 156) Materials: illustration boards, Multimedia materials Time Frame: 2 Meetings II. Objectives A. Generate responses to a question the poem asks about giving tributes to fallen soldiers B. Identify imageries in the poem C. Demonstrate comprehension on the poem by giving accurate answers to questions D. Enumerate ways how they can promote peace in their own little ways as students. III. Lesson Proper A. Introduction 1. Through a DLP, show pictures of soldiers. Let students verbalize their ideas about the pictures. 2. Inform them that they are about to read a poem about soldiers. 3. Post the following question to be answered towards the end of the lesson: What is the best way to remember those who fought in a war for freedom? B. Interaction 4. Let students read the poem silently, then let them read it aloud in chorus with the poem projected through DLP. 5. Instruct them to locate the following unfamiliar words on the poem, then give their definitions: * Granite- a very hard rock used in building * Engraved- carved into a block or surface * Relive- To undergo or experience again, especially in the imagination. * Laureate- a person who has been honored for achieving distinction in a particular field or with a particular award...

Words: 585 - Pages: 3

Free Essay

Classroom Observation Check

...TLA Self-Assessment: To What Extent Do My Lessons Show… OLTA Code | Area of Teaching, Learning and Assessment - “To what extent do I, my students or my lesson show…” | Strength | AFI | 1 | QUALITY OF LEARNING | | | 1a | Punctuality (and attendance) * do my students arrive on time; are they ready and prepared for work; * do I address lateness properly and effectively; have I evidence of strategies I have used to prevent lateness; * do I support late-comers and integrate them into the lesson; * am I aware of any background issues that might prevent my students arriving on time; * do my students demonstrate a commitment to learning through consistently high records of attendance (90% +)… | | | 1b | Learner Engagement * are my students attentive and focused; * are they responding to my questioning and are ALL my students engaged in the tasks during the lesson; * are my students enthusiastic and do I nurture this with my tasks; * am I aware of which students need more of a challenge and do I include this in my tasks… | | | 1c | Standard of Work * if someone was to look at my students’ work on the tables or in their folders does it meet or exceed the expectations of typical students at this level; * are their folders neat, tidy and have they brought the appropriate resources with them; * am I helping my students develop along Blooms’ taxonomy from developmental to higher order skills… | | | 1d | Individual & Independent Learning (outside)...

Words: 2434 - Pages: 10

Premium Essay

Cross Curricular Learning

...Introduction Cross Curricular teaching involves a conscious effort to encourage students to apply skills or knowledge acquired through learning at school to more than one subject on their curriculum. A central topic or theme can interlink subjects with each other, and students as a result should be able to learn an aspect of a central topic and apply information learned in one subject to others(Householder & Boulin 1992). As mentioned in Component 1 there are huge advantages to Cross Curricular teaching and learning. However, many students do not or cannot apply the knowledge that they have acquired in one subject to others (www.fromtinyacorns.wordpress.com/2009/10/28/about-transdisciplinary-thematic-learning) Learning beyond subject boundaries provides a student with the opportunity to experience not only learning that is relevant to one subject’s requirements, but also learning information that they will apply to other subjects. This type of learning some students may find to be challenging as they will be studying one topic from many different perspectives. However, with a deeper understanding of a topic, others will find it more interesting and may be encouraged to study the topic even further. Rensick (1989) confirms this stating that in contrast to learning topics in isolation students become more actively engaged in their studies when they participate in cross curricular learning. Cross curricular learning that is based on linking learning experiences and...

Words: 3118 - Pages: 13

Free Essay

Lesson from Geese

...Lessons from Geese 'Individual empowerment results from quality honking' Lessons from Geese provides a perfect example of the importance of team work and how it can have a profound and powerful effect on any form of personal or business endeavor. When we use these five principles in our personal and business life it will help us to foster and encourage a level of passion and energy in ourselves, as well as those who are our friends, associates or team members. It is essential to remember that teamwork happens inside and outside of business life when it is continually nurtured and encouraged. Lesson 1 - The Importance of Achieving Goals as each goose flaps its wings it creates an UPLIFT for the birds that follow. By flying in a 'V' formation the whole flock adds 71 percent extra to the flying range. Outcome When we have a sense of community and focus, we create trust and can help each other to achieve our goals. Lesson 2 - The Importance of Team Work When a goose falls out of formation it suddenly feels the drag and resistance of flying alone. It quickly moves back to take advantage of the lifting power of the birds in front. Outcome if we had as much sense as geese we would stay in formation with those headed where we want to go. We are willing to accept their help and give our help to others. Lesson 3 - The Importance of Sharing when a goose tires of flying up front it drops back into formation and another goose flies to the point position. Outcome It pays to...

Words: 397 - Pages: 2

Free Essay

Fnt1

...Lessons from Geese 'Individual empowerment results from quality honking' Lessons from Geese provides a perfect example of the importance of team work and how it can have a profound and powerful effect on any form of personal or business endeavor. When we use these five principles in our personal and business life it will help us to foster and encourage a level of passion and energy in ourselves, as well as those who are our friends, associates or team members. It is essential to remember that teamwork happens inside and outside of business life when it is continually nurtured and encouraged. Lesson 1 - The Importance of Achieving Goals as each goose flaps its wings it creates an UPLIFT for the birds that follow. By flying in a 'V' formation the whole flock adds 71 percent extra to the flying range. Outcome When we have a sense of community and focus, we create trust and can help each other to achieve our goals. Lesson 2 - The Importance of Team Work When a goose falls out of formation it suddenly feels the drag and resistance of flying alone. It quickly moves back to take advantage of the lifting power of the birds in front. Outcome if we had as much sense as geese we would stay in formation with those headed where we want to go. We are willing to accept their help and give our help to others. Lesson 3 - The Importance of Sharing when a goose tires of flying up front it drops back into formation and another goose flies to the point position. Outcome It pays to...

Words: 397 - Pages: 2

Free Essay

Ubd Lesson Plan

...|Name: Gail Faulkner |Date:4-22-2012 | |Unit Title: the study of Water | |Grade Level: PRE-K | |Subject: Science | |Unit Length: 10 minutes | |Brief Summary of Unit | |(Describe the context for this unit within the curriculum, and the curricular aims of the unit.) | | | |What understandings or goals will be assessed through this task? (Students will…) | | | |Will understand how water is a way of life for people. They will also gain recognition of various types of things we use water for.| |The students will develop...

Words: 1904 - Pages: 8

Free Essay

Lesson Plan

...LESSON PLAN Activity:Volleyball Grade: High School Date: 1/31/14 Name. Objectives: Number of Students:30 1. (Psychomotor) Students will demonstrate proper form of a Forearm Pass through repetition. Equipment Needed: balls, net Play Space Needed: court 2. (Cognitive) Students will show proper understanding of a Forearm Pass through peer teaching. Special Markings: front court, back court CALIFORNIA SKILL AREAS: 1. Sensorimotor and perceptual motor 2. Locomotor 3. Non-locomotor 4. Balance 5. Eye-hand coordination 6. Eye-foot coordination 7. General coordination 8. Creative movement NASPE CONTENT STANDARDS IN PHYSICAL EDUCATION – a physically educated person: 1. Demonstrates competency in motor skills and movement patterns needed to perform a variety of physical activities 2. Demonstrates understanding of movement concepts, principles, strategies, and tactics as they apply to the learning and performance of physical activities 3. Participates regularly in physical activity 4. Achieves and maintains a health-enhancing level of physical fitness 5. Exhibits responsible personal and social behavior that respects self and others in physical activity 6. Values physical activity for health, enjoyment, challenge, self-expression, and/or social interaction Time Description of Skills and Activities Student Teacher Organization Formations Teaching Cues...

Words: 463 - Pages: 2

Free Essay

Spring 2013

...find headlines for each of the following lessons. Make sure that the headline is school appropriate, relevant to each lesson, and cited using MLA format. Lesson 1: Introduce the environment. Lesson 2: Identify the problem. Lesson 3: Identify the solutions. (What tools are available to perform the project?) Lesson 4: Evaluate the solutions. (If there are assumptions, what are they?) Lesson 5: Evaluate the ethical and social issues. (What ideas are compatible or incompatible with the problem and solutions?) Lesson 6: Propose the best solution. Lesson 7: Conclude your project experience. B. Write one paragraph for each of the above lessons. The lessons are directed to someone who has no experience in the field. Each lesson should be completed by the assigned due date. One Time Development: (This is a combination of the ongoing task.) A. In a term paper format (two+ pages), provide a formal proposal for the project analyzing the following (bring together all the lessons you worked on throughout the course): 1. The Problem 2. The Solutions Identified 3. The Solutions Evaluated 4. The Ethical and Social Issues 5. The Best Solution B. This paper will be traded with one assigned group member after receiving my feedback for editing improvements. Each student will read the assigned proposal, name 3 positive comments, ask 3 questions, and give 3 recommendations for their classmate. C...

Words: 293 - Pages: 2

Free Essay

Approaches to Teaching Gcse Maths

...lot of learners learn by doing. Realistic Mathematics Education (RME)  The course has introduced me to Hodder Education’s range of books called ‘Making Sense of Maths’ for KS3 and KS4 (http://www.hoddereducation.co.uk/makingsenseofmaths). Mr Gough, a maths teacher and one of the authors of the aforementioned book(s) states the following: “My experience of teaching GCSE Foundation Tier is that by the time they get to KS4 they’ve already covered most of the content and they’re having the same content repeated in the same way that they found difficult in the first place so my experience of using this approach is that it seemed very different to them and it reinvigorated their interest in maths and they were very positive about maths lessons again. We’ve also taken these materials to various exam boards around the country; all of them confirm that its approach can be given credit for in terms of method marks whether the question is answered correctly or not. Indeed one chief examiner was saying that anything that promoted the students drawing things in the exam was definitely a good thing. He...

Words: 3459 - Pages: 14

Free Essay

Child Development

...Professional Resource File. You will complete the first paragraph of your statement within the following guidelines and rubric requirements: CSI Competency Statement I (To establish and maintain a safe, healthy learning environment): Begin your Reflective Statement about this Competency Standard with a paragraph describing how your teaching practices meet this Standard. Once you have completed this paragraph, you will put it in your CDA Professional Resource File with paragraphs a, b, and c following. (these will be assigned separately) (SLO 1) 2. Choose and complete a lesson plan for an activity that can be implemented with children and families to promote knowledge of nutrition. May include, but not limited to the following: * Eating Healthy Foods * Identifying nutritious foods * Meal Planning * Healthy Meal practices (Use the given Activity Template) (SLO 2) 3. RC I-2: A copy of one weekly menu. In order to complete your related Reflective Competency Statement on the topic, the menu would ideally be one that you have participated in serving to and/or designing for children. If this is not possible, or if you work in a program that does not serve meals, you may...

Words: 1305 - Pages: 6

Free Essay

Unit 12

...|Date of preparing: 07/03/2015 |ENGLISH LESSON PLAN – GRADE 11 | |Unit 12: Period 78 |UNIT12.THE ASIAN GAMES | | |LISTENING LESSON | I. Aims/Objectives 1. Educational aim Monologue - Extensive listening: multiple choice questions - Comprehension questions 2. Knowledge and skills: * General language knowledge: - New words: coming live (adj) freestyle (adj) gymnasium (n) Lee Bong-ju land (n) bar (n) gymnast (n) Vichai * Skills: - Extensive listening: multiple choice questions - Comprehension questions II. Preparation: - Teacher: lesson plan, tape. - Ss: revise old lessons and skim the lesson at home. III. Anticipated problems - The Ss may not understand some requirements so the T should explain in Vietnamese IV. Procedure |Teacher’s / Students’ activities |Content | |A. WARM UP (5ms) | |* Methods/techniques of teaching and learning: individually ...

Words: 434 - Pages: 2

Premium Essay

Lesson Plan

...Story Element Lesson Plan 1 Story Element Lesson Plan Heather Sines ECE335: Childrens Literature Instructor: Karen Foster April 21, 2015 Story Element Lesson Plan 2 Story Element Lesson Plan Grade: Preschool Ordinary Mary’s Extraordinary Deed By Emily Pearson Lesson Plan: Monday Subject: Beginning, Middle, and End Story Element Grade: Preschool, ages 3-5 (covering Kindergarten Common Core ELA Standards) Topic: Being Nice Duration: 1 School day (Monday) Story Element Lesson Plan 3 Goals/Objectives: | We will Identify the parts of a story using the beginning, middle and end of a “being nice” themed multicultural book. The children will be able to divide a story into the beginning, middle and end, and be able to identify the settings in each. Within identifying the settings and the sections of the story, they will be identifying how one person’s kindness can affect another’s. | Standards Covered: | Reading Standards for Literature K-5 Kindergarten-With prompting and support, ask and answer questions about key details in the text.-Identify characters, setting and major events in a story.-Ask and answer questions about unknown words in...

Words: 1101 - Pages: 5

Premium Essay

Lesson Plan- English 8

...Members: Pham Thị Diu Tran Hong Nga Tran Thi Hong Ngoc * : AT HOME Period 13 Lesson 2 SPEAK-P.28,29 B. 1. Aims: Talking about the position of furniture in the kitchen and in the living room. 2. Class details/class description 35 students of class 8A 3 .Objective: By the end of the lesson, Ss will be able to describe the position of things in the house using prepositions of place 4. Materials: * Course book : English 8, unit 3(p.28,29) … * Teaching aids: Textbooks, Pictures, Blackboard . 5. Ways of working: Individuals, pairs , groups. 6. Anticipated problems and solutions * Problem 1: Lack of time * Solution : + Asking advices from others + Depending on student’s interest + Rehearsing * Problem 2: Having no idea for plan * Solution: + Reading inference book + Searching on the Internet (www.busyteachers.org) 7. Stages of the lesson Pre – speaking While – speaking Post – speaking 8. Procedures Timing | Stages | T’s activities | S’s activities | | Warm up | | | | Pre- speaking | Exercise 1: * T’s explains the example.* If most Ss have difficulty, ask them to answer these questions:- Where's the calendar? - Where's the cupboard?- Where's the bowl of fruit? - Where's the stove? -Where are the knives? (on the wall, under the cupboard) - Where are the flowers...

Words: 384 - Pages: 2