Premium Essay

It 240 Set 2 Week 5 Dq 2

In:

Submitted By sinvevi
Words 390
Pages 2
This paperwork contains IT 240 Latest Version Set 2 Week 5 CheckPoint Domain Name Computer Science - General Computer Science iLab 3 : Database Construction Using Access (100 Points)

i L A B O V E R V I E W

Scenario and Summary

In this assignment, you will learn to create an Access database from a given ERD. To complete this assignment, you will need to be able to run Access 2010, either through Citrix or installed on your workstation or laptop.

Deliverables

Name your Access database file using Lab3_, your first initial, and your last name (e.g., Lab3_JSmith.accdb). Create and save your Access database file. When you are done, submit your database to the Course Project Dropbox.

i L A B S T E P S

STEP 1

Review the ERD below to understand the entities, attributes, primary keys, and relationships that you will create in your Access database.

ERD iLab Image

STEP 2

# Run Access 2010, either via Citrix or from Visio 2010 installed on your workstation.

# Select the blank database icon in the main window.

# Save the file with a name containing Lab3_, your first initial, and your last name (e.g., Lab3_JSmith.accdb). In Citrix, you will need to click the computer icon in the Save As window to see the different drives. Be sure to save the file to a local drive so it will be on your workstation.

See the tutorials above for instructions on how to perform the following steps in Access 2010.

STEP 3

Add tables to the Access database.

# Add a table for each entity listed in the provided ERD diagram.

# Add a column for each attribute listed in the provided ERD diagram.

# Select a primary key for each table as indicated in the provided ERD diagram.

STEP 4

For every column in every table, update the data type as needed to enforce the domain constraints of the data

Similar Documents

Premium Essay

Supply Chain Management Term Paper

...Supply Chain Management Final Paper Name: Student ID: Instructor: [Abstract] With the updates of music carriers, the market of headsets expanded quickly. Using the in-ear headsets as a sample product, this paper works on the requirements, souring, logistics, sustainability and costs of the product, and finally works out a supply chain for this product. [Keywords] Supply chain management, headsets Overview Product introduction I choose customized in-ear headsets (or earbuds) as my product. And my firm will be located in Shanghai, PRC. Several colors and different sound drivers are provided. The type of sound drivers used in the headsets, the appearance of the shells and the cable color are determined by customers. Background information As music players get smaller and smaller today, people found there’s no more space for the convenience promotion of music carriers. Thus, customers start to focus on the quality of music they hear. In the past years, the market of earbuds especially those in-ear headsets whose price is over $50 has expanded, and becomes a 10-billion trade. I’m quite interested in audio products and this idea came out when I was looking for a new earphone on some e-stores. That moment I was browsing the official site of Ultimate Ears, the very famous brand of professional ear monitors, and it’s also well known for its customized in-ear monitors for vocalists. I hope to figure out how this kind of customized-pattern works if it is applied...

Words: 4874 - Pages: 20

Premium Essay

Econ

...1. Determining changes in equilibrium price and quantity for a perfectly competitive industry given changes in demand and/or supply (Ch. 2, p. 60-65; Class Notes) A. Graphical analysis given demand and supply curves a) While there is increased awareness of Vitamin C available from orange juice, a hard, freezing winter occurs in most of the orange producing areas. Demand increases while supply decreases. b) While the technology used for tobacco production is improving, there is increased awareness of the health effects of smoking. Supply increases while demand decreases. c) While there is increased awareness of Vitamin C available from orange juice, highly favorable weather conditions occur in orange producing areas for most the crop season. Both demand and supply increase. d) While there is increased awareness of the health effects of smoking, severe drought occurs in tobacco producing areas for most of the crop season. Both demand and supply decrease. 2. Determining the cross-price elasticity of demand between two goods (Ch. 3; p. 85-88, Class Notes) A. Arc cross-price elasticity, given discrete changes in price and quantity demanded Exy = [(Qndx - Qodx)/{(Qndx + Qodx)/2}] / [(Pny - Poy)/{( Pny + Poy)/2}] = [(Qndx - Qodx)/(Qndx + Qodx)] / [(Pny - Poy)/( Pny + Poy)] where, Qndx and Qodx are new and original quantities of good X demanded, and Pny and Poy are...

Words: 1447 - Pages: 6

Premium Essay

Syllabus

...| Course Design Guide College of Social Sciences PSY/240 Version 6 The Brain, the Body, and the Mind | Copyright © 2011, 2010, 2009, 2006 by University of Phoenix. All rights reserved. Course Description This course provides an introduction to the investigation of physiological and neurological basis for human behavior. The student will be able to study and discuss various influences on personality development, such as pre-natal maternal behavior; gender; nature versus nurture; brain development; genetic composition; sensory motor interactions; learning disabilities; drug impacts; and neurological diseases. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality. Course Materials Pinel, J. P. J. (2009). Biopsychology. Boston, MA: Pearson. Associate Level Writing Style Handbook, available online at https://ecampus.phoenix.edu/secure/aapd/CWE/pdfs/Associate_level_writing_style_handbook.pdf All electronic...

Words: 2714 - Pages: 11

Free Essay

Cost Acounting

...environment. Managers make decisions on a day to day basis and it is necessary for them to be able to analyze the data so as to be able to make optimal decisions. This module has ten lesson which cover matrix algebra, markov analysis, Linear programming, differentiation, applications of differentiation to cost, revenue and profit functions, integral calculus, inventory models, sampling and estimation theory, hypothesis testing and chi-square tests. iii MODULE OBJECTIVES By the end of the course, the student should be able to:- 1. Perform various operations on matrices matrix algebra, 2. Apply the concept of matrices in solving simultaneous equations, input-output analysis and markov analysis, 3. Formulate and solve Linear programming using the graphical and simplex method 4. Differentiate various functions and apply to cost, revenue and profit functions 5. Apply...

Words: 36888 - Pages: 148

Premium Essay

Eco 550

...within the firm is: a.    macroeconomics b.    welfare economics c.    free-enterprise economics d.    microeconomics e.    none of the above     2.    If one defines incremental cost as the change in total cost resulting from a decision, and incremental revenue as the change in total revenue resulting from a decision, any business decision is profitable if: a.    it increases revenue more than costs or reduces costs more than revenue b.    it decreases some costs more than it increases others (assuming revenues remain constant) c.    it increases some revenues more than it decreases others (assuming costs remain constant) d.    all of the above e.    b and c only     3.    In the shareholder wealth maximization model, the value of a firm's stock is equal to the present value of all expected future ____ discounted at the stockholders' required rate of return. a.    profits (cash flows) b.    revenues c.    outlays d.    costs e.    investments     4.    Which of the following statements concerning the shareholder wealth maximization model is (are) true? a.    The timing of future profits is explicitly considered. b.    The model provides a conceptual basis for evaluating differential levels of risk. c.    The model is only valid for dividend-paying firms. d.    a and b e.    a, b, and c     5.    According to the profit-maximization goal, the firm should attempt to maximize short-run profits since there is too much uncertainty associated with...

Words: 28656 - Pages: 115

Premium Essay

Open Scource

...monopoly is the situation where there is a single seller of a good. Because of this, it has the power to set both the price and quantity of the good that will be sold. We begin our study of monopoly by considering the price that the monopolist should charge.1 9.1 Simple Monopoly Pricing The object of the firm is to maximize profit. However, the price that the monopolist charges affects the quantity it sells. The relationship between the quantity sold and the price charged is governed by the (aggregate) demand curve q (p). Note, in order to focus on the relationship between q and p, we suppress the wealth arguments in the aggregate demand function. We can thus state the monopolist’s problem as follows: max pq (p) − c (q (p)) . p Note, however, that there is a one-to-one correspondence between the price charged and the quantity the monopolist sells. Thus we can rewrite the problem in terms of quantity sold instead of the price charged. Let p (q) be the inverse demand function. That is, p (q (p)) = p. The firm’s profit maximization problem can then be written as max p (q) q − c (q) . q It turns out that it is usually easier to look at the problem in terms of setting quantity and letting price be determined by the market. For this reason, we will use the quantity-setting approach. 1 References: Tirole, Chapter 1; MWG, Chapter 12; Bulow, “Durable-Goods Monopolists,” JPE 90(2) 314-332. 233 Nolan Miller Notes on Microeconomic Theory: Chapter 9 P ver: Aug. 2006 ...

Words: 10505 - Pages: 43

Premium Essay

Gudie

...Introduction to Demand and Supply 1.1 Quiz . . . . . . . . . . . . . . . . . . 1.2 Group Exercise . . . . . . . . . . . . 1.3 Homework Questions . . . . . . . . . 1.4 Homework Solutions . . . . . . . . . 2 Elasticity 2.1 Quiz . . . . . . . . . 2.2 Group Exercise . . . 2.3 Homework Questions 2.4 Homework Solutions iii 1 1 3 4 5 9 9 11 12 13 15 15 17 18 19 25 25 27 28 29 33 33 35 36 37 39 39 41 42 43 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Applications of Demand and Supply 3.1 Quiz . . . . . . . . . . . . . . . . . . 3.2 Group Exercise . . . . . . . . . . . . 3.3 Homework Questions . . . . . . . . . 3.4 Homework Solutions . . . . . . . . . 4 International Trade 4.1 Quiz . . . . . . . . . 4.2 Group Exercise . . . 4.3 Homework Questions 4.4 Homework Solutions 5 Market Failure 5.1 Quiz . . . . . . . . . 5.2 Group...

Words: 15136 - Pages: 61

Premium Essay

Mkt Syllabus

...International American University Department of Business The University Catalog and Student Handbook supplement this syllabus and are available through IAU Online as a digital soft copy. Please make sure that you review the University Catalog and Student Handbook so that you can be successful in this course. 4201 Wilshire Blvd., Suite #610 ♦ Los Angeles, CA 90010, CA, U.S.A. ♦ T: (323) 938-4428 ♦ F: (323) 938-4-4429 ♦ E: www.iau.la MKT 500C Marketing Management Syllabus Instructor Name: Instructor Phone: Instructor Email: Campus / Room: Mode: COURSE DETAILS Christopher Lloyd, MBA (310) 594-1023 clloyd@iau.la Main Campus – B Hybrid Term/Year: Days: Time: Start: End: Fall S2, 2015 Wednesdays 6:00pm - 10:00pm October 26, 2015 December 18, 2015 Christopher Lloyd earned his MBA with a concentration in Information Systems from California State University Long Beach in 2012. Professor Lloyd teaches as an adjunct professor for courses in management, marketing, business, information systems management, and computer information systems for undergraduate and graduate level courses. His responsibilities include teaching and mentoring undergraduate and graduate students, and attending conferences and symposiums addressing strategic management, digital marketing, and search engine optimization. Professor Lloyd's "learning through application" approach earns him high praise from his students. His genuine interest in their career advancement ...

Words: 9115 - Pages: 37

Premium Essay

Internet Addiction

...an accessory to issues including extra-marital affairs, pornography, and gambling. There also appears to be a growing concern, especially in Asia, for what has been labeled “Internet addiction.” In particular, certain Asian countries report it as a serious public health issue. Liu Guiming, deputy secretary-general of the Chinese Society of Juvenile Delinquency Research, has been quoted as saying "the growing number of youth infatuated with unhealthy Web sites and campus violence has become an urgent social problem.” A leading Beijing judge, Shan Xiuyun, also declared that 90 per cent of juvenile crime in the city was Internet-related” (Sebag-Montefiore, 2005).As a result of these concerns, governments in South Korea, Japan and China have set up boot camps, which provide therapy to deal with Internet addiction (Ransom, 2007). China has also issued a ban on new Internet cafes to clamp down on Internet addiction (Watts, 2007). Yet, there are those who doubt whether this outcry is justified or even valid. An article in the American Psychological Association newsletter suggests that there is little empirical evidence to support the existence of Internet addiction and much of the research in this area utilizes self-selecting samples with no control groups (De Angelis, 2000). In light of this controversy, his paper seeks to examine Internet addiction in Asia. Specifically, it reviews the academic and empirical literature to address the following questions: * What empirical...

Words: 8510 - Pages: 35

Premium Essay

Fast Food Facts

...sixth, seventh, and ninth individually. Together their sales totaled $16.7 billion, or 12% of the market, and placed YUM! Brands in second place behind McDonald’s. The restaurants in our analysis represent several different segments of the fast food market including burgers (McDonald’s, Burger King, Wendy’s, Sonic, and Dairy Queen), sandwiches (Subway), snacks (Starbucks and Dunkin’ Donuts), Mexican food (Taco Bell), pizza (Pizza Hut and Domino’s), and chicken (KFC).4 The number of U.S. locations of these twelve restaurants totaled almost 100,000 and ranged from approximately 3,500 Sonic restaurants to almost 24,000 Subway restaurants. These twelve restaurants comprised 41% of locations for the top 50 restaurants. Fast food segment Table 2 presents 2008 and 2009 sales data for the twenty largest fast food restaurants in the United States and highlights the twelve restaurants included in our full analysis. In addition to the ten restaurants with the highest sales in 2008 and 2009, we have also included Domino’s and Dairy Queen in our analysis due to the large number of TV advertisements seen by children for these restaurants. In 2008, Domino’s ranked ninth in the amount of TV advertising seen by children, Arby’s ranked tenth...

Words: 52447 - Pages: 210

Premium Essay

Supply and Demand

...they could do their own painting and decorating. Alternatively people could engage in barter: they could produce things and then swap them for goods that other people had produced. ( Before reading on, how would you define scarcity? Must goods be at least temporarily unattainable to be scarce? See page 2 of text for a definition of scarcity. Goods need not be unattainable to be scarce. Because people’s incomes are limited, they cannot have everything they want from shops, even though the shops are stocked full. If all items in shops were free, the shelves would soon be emptied! ( If we would all like more money, why does the government not print a lot more? Could it not thereby solve the problem of scarcity ‘at a stroke’? The problem of scarcity is one of a lack of production. Simply printing more money without producing more goods and services will merely lead to inflation. To the extent that firms cannot meet the extra demand (i.e. the extra consumer expenditure) by extra production, they will respond by putting up their prices. Without extra production, consumers will end up unable to buy any more than previously. 5 ( (Box 1.1) What is it that makes each one of the above news items an economics item? Each one of the items has something to do with production, consumption or exchange, and/or the money incomes and expenditures involved. 6 ( Which of the following are macroeconomic issues, which are microeconomic ones and...

Words: 89665 - Pages: 359

Premium Essay

Student

...is, they are open systems. This approach recognizes the importance of studying inter-relatedness of planning, organizing, and controlling in an organization as well as the many subsystems. Characteristics of Organization 1) Organization is made up of a group of people 2) The group works under an executive head 3) Organization is a tool of management 4) It leads to division of work and responsibilities 5) It defines and fixes the duties and responsibilities of employees 6) It establishes a relationship between authority and responsibility and controls the effort of the group 7) Organization is a step towards achievement of established goals Elements of Organization The main elements or components of an organization are: 1) Well defined objectives 2) Well organized and coordinated group of people 3) Proper division of work and labour 4) Clear and well defined policies and procedures 5) Proper division of authority and responsibility 6) An effective system of communication Organization Chart Simple Organization Chart Lecture Notes on Industrial Organization and Management Subject handled by: Dr. Shouri P.V., Asst. Professor in Mechanical Engineering, MEC, Cochin (for S7 Biomedical) 2 An organization chart is a simple drawing of lines and boxes showing how the firm is organized. Boxes represent the activities of the firm and the people who perform these activities. Lines indicate the relationships among them. Positions near the top of the chart have...

Words: 28190 - Pages: 113

Free Essay

Fordism

...Fordism and Taylorism are responsible for the early success and recent decline of the U.S. motor vehicle industry Ronald Jean Degan International School of Management Paris 2011 Working paper nº 81/2011 globADVANTAGE Center of Research in International Business & Strategy INDEA - Campus 5 Rua das Olhalvas Instituto Politécnico de Leiria 2414 - 016 Leiria PORTUGAL Tel. (+351) 244 845 051 Fax. (+351) 244 845 059 E-mail: globadvantage@ipleiria.pt Webpage: www.globadvantage.ipleiria.pt WORKING PAPER Nº 81/2011 Setembro 2011 Com o apoio 2 Fordism and Taylorism are responsible for the early success and recent decline of the U.S. motor vehicle industry Ronald Jean Degen Ph.D. Candidate at the International School of Management Paris Vice Chairman of Masisa Chile Address: E-mail: rjdegen@gmail.com Phone: +55 21 8068 9000 Av. Pasteur 333 Botafogo/Urca Lancha Ovelha Negra Iate Clube do Rio de Janeiro 22290-240 Rio de Janeiro, RJ Brazil 3 Fordism and Taylorism are responsible for the early success and recent decline of the U.S. motor vehicle industry Abstract This paper identifies the ways in which the ideas of Fordism and Taylorism have been responsible for the success of the U.S. motor vehicle companies until 1955, and for their subsequent decline. On three occasions, the motor vehicle industry has changed the fundamental ideas on the process of manufacturing, and, perhaps more significantly, on how humans work together to create value. Under Fordism...

Words: 8511 - Pages: 35

Free Essay

Israeli Palestinian Conflict

...5/8/2014 Israeli–Palestinian conflict - Wikipedia, the free encyclopedia Israeli–Palestinian conflict From Wikipedia, the free encyclopedia The Israeli–Palestinian conflict (Arabic: ‫اﻟﻨﺰاع اﻟﻔﻠﺴﻄﯿﻨﻲ‬ ‫​- اﻹﺳﺮاﺋﯿﻠﻲ‬ al-Niza'a al'Filastini al 'Israili; Hebrew: ‫​הסכסוך הישראלי-פלסטיני‬ Ha'Sikhsukh Ha'YisraeliFalestini) is the ongoing struggle between Israelis and Palestinians that began in the mid-20th century.[1] The conflict is wide-ranging, and the term is sometimes also used in reference to the earlier sectarian conflict in Mandatory Palestine, between the Zionist yishuv and the Arab population under British rule. The Israeli–Palestinian conflict has formed the core part of the wider Arab–Israeli conflict. It has widely been referred to as the world's "most intractable conflict".[3][4][5] Despite a long-term peace process and the general reconciliation of Israel with Egypt and Jordan, Israelis and Palestinians have failed to reach a final peace agreement. The remaining key issues are: mutual recognition, borders, security, water rights, control of Jerusalem, Israeli settlements,[6] Palestinian freedom of movement,[7] and resolving Palestinian claims of a right of return for their refugees. The violence of the conflict, in a region rich in sites of historic, cultural and religious interest worldwide, has been the object of numerous international conferences dealing with historic rights, security issues and human rights, and has been a factor hampering tourism in and...

Words: 24422 - Pages: 98

Premium Essay

Clive M

...The Central Problem of Economics Needs and Wants Needs are the things we can’t survive without. They are necessities of life e.g. food, clothing, shelter, water, basic wealth and basic education. Wants are the things we desire to have or own but we can survive without them e.g. cell phones, TVs, oars, radios, entertainment etc. Our want are unlimited and we never seem to be satisfied with what we have. It is people’s wants rather than their needs we provide the motive for economic activity. The economic resources that are available to satisfy our wants are limited. These resources are called factors of production which are : Land (Natural Resources) Land refer to natural resources over which people have power of disposal and of which may be used to yield income/money e.g. farming and building land, forests, mineral deposits, air, seas, oceans, vegetation, fisheries. The reward for land is rent. Labour Labour is human effort – physical or mental which is directed to the product of goods and services. Reward for labour is wages/salary. Capital Is money and all man-made assets used in the production of goods and services e.g. money, machinery, factories, delivery vans etc. Reward for capital is interest. Enterprise Land, labour and capital on their own will not produce anything. There must be a person or people who will organise the 3 factors of production so that production can take place. Whoever takes these decisions and consequent risks is known as the entrepreneur...

Words: 18355 - Pages: 74