Database Management Chapter 2

In: Computers and Technology

Submitted By jcsmith83
Words 416
Pages 2
1. Besides redundancy, what other problems are associated with the nondatabase approach to processing data? Another problem with the nondatabase approach is accessing related data. In order to access data that is related to one another, you would have to open multiple spreadsheets, nondatabase systems also have way less security features than a database system. 2. What is a relationship? A one to many relationship? A relationship is an association between entities. A one-to-many relationship is a relationship where one entity is related to a group of entities, and everything in that group of entities is related to the first entity but they are not related to each other. 3. How do you create a one-to-many relationship in a database system? To create a one-to-many relationship in a database you will first need to create an entity, this entity should have something in common with the entities that it is related to, meaning they need to have at least one attribute in common. 4. What is a DBMS? DBMS stands for database management system, which is a program, or collection of programs, through which users interact with a database. 5. What is a form? A form is screen object used to maintain, view, and print data from a database. 6. What is meant by the sharing of data? Sharing data allows many different users to have access to the same data, if one user changes or updates that data the changes will be visible to all users. 7. How does consistency result from controlling redundancy? Without redundancy there is more efficiency, and with efficiency comes consistency? 8. What is security? How does a DBMS provide security? Security is the prevention of unauthorized access to the database. A DBMS provides security by assigning passwords to authorized users. A DBMS can also assign users to groups, and all the users in those groups can be restricted…...

Similar Documents

Management Accouting Chapter 2

...Assignment 2 Cost Terms, Concepts, and Classifications P 2-21: Variable and Fixed Costs; Subtleties of Direct and Indirect Costs P 2-24: Schedule of Cost of Goods Manufactured; Income Statement; Cost Behaviour 1. *** Computations: Direct Labour = $675,000 - 270,000 - 340,000 = $65,000 Beg. WIP = $720,000 – 30,000 + 33,000 – 675,000 = $48,000 End. Finished Goods = $720,000 – 635,000 = $85,000 2. 3. Based on the assumption that the company expects to produce 50,000 units in the following year, the average cost per unit and total cost for direct materials and for rent on the factory building are as follows: Direct materials: i) Since direct material is classified as a variable cost, the average cost per unit for direct materials is $9.00 ($450,000/50,000 units) ii) Total cost for direct materials = $9 x 50,000 units = $450,000 Rent on the factory building: i) Since rent on the factory building is classified as a fixed cost, the average cost per unit = $90,000/50,000 units = $1.80 per unit; ii) Total cost for rent on the factory building = $90,000 (no change) 4. When considering the differences in the average costs per unit between variable and fixed costs, it is important to highlight the impact that changes in the activity level have on direct materials (variable cost) and rent on the factory building (fixed cost). Specifically, when there is an increase in the units of production, total variable cost will also increase with......

Words: 795 - Pages: 4

Human Resource Management Chapter 2

...Human Resource Management Week 2 Assignment August 30, 2012 Chapter 2 Learning Exercise 2 1. Small businesses comprise a major portion of the U.S. economy. Larger companies typically have more resources to hire staff dedicated to supporting the management of employees than do smaller companies, which often lack formal HR departments to provide similar support. This does not eliminate the need to attend to people issues in smaller companies; rather line managers or company owners must perform HR practices in addition to their other activities. Also, smaller businesses often do not have the resources to provide the same level of pay, benefits, and training opportunities to employees as larger companies. 2. Although small companies often do not have the same type or level of resources enjoyed by larger companies, the importance of effectively managing employees may be magnified in smaller companies. With a smaller staff, managers may expect employees to display greater autonomy and discretion. As a result, the types of knowledge, skills, and abilities that employees may need in small versus large companies, even for the same job, differ. Furthermore, in contrast to large operations, in a small company, the performance of each employee is likely to have a larger, more direct impact on company success. 3. Yes, it would influence my decision about how to manage my employees. The pressures of managing employees in a young, startup company are different......

Words: 793 - Pages: 4

Database Management

...1 Introduction to Databases LESSON 1 Database Learning Objectives: On completion of Lesson 1, you should have been able to: 1. Describe the role of a database system 2. Briefly describe the evolution of database systems and the limitations of conventional file processing systems 3. Describe the three schema architecture for database and explain the difference between conceptual , external and physical schemas 4. Define the functions of a database administrator Keywords and Phrases LEARNER Database Database System Entities Conceptual Model Logical Model Physical Model Constraints Metadata Database Management System File System Indexing Introduction This module introduces the reader to the different concepts of databases. It also tackles a brief history how automated databases came into existence. A number of advantages is discussed why the evolution of database management system is very much appreciated by system developers nowadays. 2 What is a Database ? Let us try to get the answers from the different Database Management System book authors. Answer from Pratt/Adamski: o A Database (DB) is structure that can store information about: 1. multiple types of entities, 2. the attributes that describe those entities; and 3. the relationships among the entities Answer from Elmasri/Navathe: o A Database (DB) is collection of related data - with the following properties: 1. A DB is logically coherent and has some relevant meaning 2. A DB is designed,......

Words: 6349 - Pages: 26

Project Management Chapter 2 Case Study Solution

...1. How do we create a partnership between the project manager and line managers when project manager focuses only on the best of his/her project and the line manager is expected to make impartial company decision? I think the most important point is that project manager and line manager should stand on the same level, which means each of them should have same formal authority, line manager should manage right people to project manager, and project manager should arrange right people to the right position, for the best interest of company, this is a partnership they should establish. 2. Who should have more of a say during negotiations for the resource manager or the line manager. I think it depends on what size the company is, for case one, line manager have more of a say during negotiations for resource, during the context, line manager control several key staff, while project manager have to work with the one he does not want to work with. Ideally, project manager should have a say in the assembly of his project team and his resource, which will help him to gain their personal commitment, support and required quality of service. 3. How should irresolvable conflicts over staffing between the project and line managers be handle? Basically, for this kind of conflict should be handle by sponsor, it is the sponsor who support the project, if there is a conflict between the project manager and line manager, sponsor should evaluate the situation to decide who should go...

Words: 429 - Pages: 2

Cis 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions

...CIS 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions http://homeworktimes.com/downloads/cis-106-chapter-2-relational-databases-queries-multiple-choice-questions/ 1.) When entering, deleting, or editing table data: A.) The table must be in Design View B.) The table must be in Datasheet View C.) The table may be in either Datasheet or Design View D.) Data may be entered only in a form 2.) Which of the following is true for the Query Wizard? A.) You can only select tables as a source B.) No criteria can be added C.) Fields from multiple tables are not allowed D.) You do not need a summary 3.) Which of the following was not a suggested guideline for designing a table? A.) Include all necessary data B.) Store data in its smallest parts C.) Avoid calculated fields D.) Link tables using common fields 4.) A query’s specifications providing instructions about which records to include must be entered: A.) On the Show row of the query design grid B.) On the Sort row of the query design grid C.) On the Criteria row of the query design grid D.) On the Table row of the query design grid 5.) An illustration of a one-to-many relationship would be: A.) A person changes his/her primary address B.) A customer may have multiple orders C.) A branch location has an internal branch ID code D.) A balance field is totaled for all accounts for each person 6.) When adding criteria to the query design view: A.) The value you...

Words: 403 - Pages: 2

Cis 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions

...CIS 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions http://homeworktimes.com/downloads/cis-106-chapter-2-relational-databases-queries-multiple-choice-questions/ 1.) When entering, deleting, or editing table data: A.) The table must be in Design View B.) The table must be in Datasheet View C.) The table may be in either Datasheet or Design View D.) Data may be entered only in a form 2.) Which of the following is true for the Query Wizard? A.) You can only select tables as a source B.) No criteria can be added C.) Fields from multiple tables are not allowed D.) You do not need a summary 3.) Which of the following was not a suggested guideline for designing a table? A.) Include all necessary data B.) Store data in its smallest parts C.) Avoid calculated fields D.) Link tables using common fields 4.) A query’s specifications providing instructions about which records to include must be entered: A.) On the Show row of the query design grid B.) On the Sort row of the query design grid C.) On the Criteria row of the query design grid D.) On the Table row of the query design grid 5.) An illustration of a one-to-many relationship would be: A.) A person changes his/her primary address B.) A customer may have multiple orders C.) A branch location has an internal branch ID code D.) A balance field is totaled for all accounts for each person 6.) When adding criteria to the query design view: A.) The value you...

Words: 403 - Pages: 2

Cis 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions

...CIS 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions http://homeworktimes.com/downloads/cis-106-chapter-2-relational-databases-queries-multiple-choice-questions/ 1.) When entering, deleting, or editing table data: A.) The table must be in Design View B.) The table must be in Datasheet View C.) The table may be in either Datasheet or Design View D.) Data may be entered only in a form 2.) Which of the following is true for the Query Wizard? A.) You can only select tables as a source B.) No criteria can be added C.) Fields from multiple tables are not allowed D.) You do not need a summary 3.) Which of the following was not a suggested guideline for designing a table? A.) Include all necessary data B.) Store data in its smallest parts C.) Avoid calculated fields D.) Link tables using common fields 4.) A query’s specifications providing instructions about which records to include must be entered: A.) On the Show row of the query design grid B.) On the Sort row of the query design grid C.) On the Criteria row of the query design grid D.) On the Table row of the query design grid 5.) An illustration of a one-to-many relationship would be: A.) A person changes his/her primary address B.) A customer may have multiple orders C.) A branch location has an internal branch ID code D.) A balance field is totaled for all accounts for each person 6.) When adding criteria to the query design view: A.) The value you...

Words: 403 - Pages: 2

Database Management Chapter 1

...Principles of Database Management Systems Homework 1 Ying Li 4861521 Homework 1 Exercise 1.4 Explain the difference between external, internal, and conceptual schemas. How are these different schema layers related to the concepts of logical and physical data independence? Answer: External schemas, which usually are also in terms of the data model of the DBMS, allow data access to be customized (and authorized) at the level of individual users or groups of users. Internal (physical) schemas summarize how the relations described in the conceptual schema are actually stored on secondary storage devices such as disks and tapes. Conceptual (logical) schema describes the stored data in terms of the data model of the DBMS. In a relational DBMS, the conceptual schema describes all relations that are stored in the database. Any given database has exactly one conceptual schema and one internal schema because it has just one set of stored relations, but it may have several external schemas, each tailored to a particular group of users. External schemas provide logical data independence, while conceptual schemas offer physical data independence. Exercise 1.6 Scrooge McNugget wants to store information (names, addresses, descriptions of embarrassing moments, etc.) about the many ducks on his payroll. Not surprisingly, the volume of data compels him to buy a database system. To save money, he wants to buy one with the fewest possible features, and he......

Words: 859 - Pages: 4

Cost Management Chapter 2 Solution

...Chapter 2 The Cost Function LEARNING OBJECTIVES Chapter 2 addresses the following questions: Q1 What are different ways to describe cost behavior? Q2 What is a learning curve? Q3 What process is used to estimate future costs? Q4 How are the engineered estimate, account analysis, and two-point methods used to estimate cost functions? Q5 How does a scatter plot assist with categorizing a cost? Q6 How is regression analysis used to estimate a mixed cost function? Q7 What are the uses and limitations of future cost estimates? These learning questions (Q1 through Q7) are cross-referenced in the textbook to individual exercises and problems. COMPLEXITY SYMBOLS The textbook uses a coding system to identify the complexity of individual requirements in the exercises and problems. Questions Having a Single Correct Answer: |No Symbol |This question requires students to recall or apply knowledge as shown in the textbook. | |e |This question requires students to extend knowledge beyond the applications shown in the textbook. | Open-ended questions are coded according to the skills described in Steps for Better Thinking (Exhibit 1.10): ( Step 1 skills (Identifying) ( Step 2 skills (Exploring) ( Step 3 skills (Prioritizing) ( Step 4 skills (Envisioning) QUESTIONS 2.1 This function has both fixed costs and variable costs. ...

Words: 8844 - Pages: 36

Concepts of Database Management – Premiere Product Exercise Chapter 4

...Zip, Customer.Balance, Customer.CreditLimit FROM Customer WHERE (((Customer.Balance)>10000) AND ((Customer.CreditLimit)>=10000)); 2) A… CREATE VIEW PartOrder AS SELECT PartNum, Description, Price, OrderNum, OrderDate, NumOrdered, QuotedPrice FROM Part ; B… CREATE VIEW TopLevelCust AS SELECT PartNum, Description, OrderNum, QuotedPrice FROM Part WHERE QuotedPrice>100 ; C… SELECT Part.PartNum, Part.Description, Part.Price, Orders.OrderNum, Orders.OrderDate, OrderLine.NumOrdered, OrderLine.QuotedPrice FROM Part INNER JOIN (Orders INNER JOIN OrderLine ON Orders.OrderNum = OrderLine.OrderNum) ON Part.PartNum = OrderLine.PartNum WHERE (((OrderLine.QuotedPrice)>100)); 3) CREATE VIEW OrdTot AS SELECT OrderNum, NumOrdered*QuotedPrice AS OrderTotal INTO OrdTot FROM OrderLine; 4) A… CREATE INDEX PartIndex1 ON OrderLine(PartNum); B… CREATE INDEX PartIndex2 ON Part(Warehouse); C… CREATE INDEX PartIndex3 ON Part(Warehouse, Class); D… CREATE INDEX PartIndex4 ON Part(Warehouse, OnHand DESC); 5) DROP INDEX PartIndex3; 6) CHECK (Class IN (SG, HW, AP)) FOREIGN KEY (PartNum) PRIMARY KEY (PartNum) REFERENCES Part 7) ALTER TABLE Part ADD Allocation(0); SELECT SUM(NumOrdered) AS Allocation FROM Part, OrderLine PartNum = KV29 WHERE PartNum= PartNum ; 8) ALTER TABLE Part MODIFY Warehouse CHAR(2) UPDATE Part SET Warehouse=’1a’ WHERE Warehouse=’1’ ; 9) ALTER TABLE Part DELETE Allocation ; 10) DROP Part......

Words: 340 - Pages: 2

Database Management Chapter 1 & 2

...Chapter 1: (10 points each) 1. Give an example of two related tables other than one in the textbook. Use the STUDENT and GRADE tables in Figure 1-1 of the textbook as an example pattern for your tables. Name the tables and columns using the conventions in the textbook. * I used MysqL workbench to create 2 tables 1- Customers that has customers with some of their information(primary key is “Customer ID”) * CREATE TABLE IF NOT EXISTS `mydb`.`Customer` ( * `CustomerID` INT NOT NULL, * `Name` VARCHAR(45) NULL, * `Email` VARCHAR(45) NULL, * PRIMARY KEY (`CustomerID`), * UNIQUE INDEX `Email_UNIQUE` (`Email` ASC)) * ENGINE = InnoDB 2- Purchases that has number of purchases that has been done by the customers(Pkey is PurchaseID, and foreign key is “CustomerID” from Customer table. * CREATE TABLE IF NOT EXISTS `mydb`.`Purchases` ( * `PurchasesID` INT NOT NULL, * `productID` INT NULL, * `PricePaid` INT NULL, * PRIMARY KEY (`PurchasesID`)) * ENGINE = InnoDB * * *note I made the customerID as the foreign key and the relationship is (1 to many) * * * Figure1 the Customer and Purchases tables’ relationship. * 2. For the tables you created in Question 1, what are the primary keys of each table? Do you think that any of these primary keys could be surrogate keys? * In Customer table the Primary key is CustomerID * In the Purchases table the primary key is......

Words: 1949 - Pages: 8

Database Management

...CIS 260 Home Work # 1 Due to: 21/3/2013 Chapter 1: Review Questions 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, meta-data, and transaction-processing application. 1.2. What four main types of actions involve databases? Briefly discuss each. 1.3. Discuss the main characteristics of the database approach and how it differs from traditional file systems. 1.4. What are the responsibilities of the DBA and the database designers? 1.5. What are the different types of database end users? Discuss the main activities of each. 1.6. Discuss the capabilities that should be provided by a DBMS. 1.7. Discuss the differences between database systems and information retrieval systems. Chapter 2: Review Questions 2.1. Define the following terms: data model, database schema, database state, internal schema, conceptual schema, external schema, data independence, DDL, DML, SDL, VDL, query language, host language, data sublanguage, database utility, catalog, client/server architecture, three-tier architecture, and n-tier architecture. 2.2. Discuss the main categories of data models. What are the basic differences between the relational model, the object model, and the XML model? 2.3. What is the difference between a database schema and a database state? 2.4. Describe the three-schema architecture. Why do we need mappings between schema levels? How do different schema definition...

Words: 1108 - Pages: 5

Chapter 2 Essay Questions Strategic Management

...Chapter 2 Application Questions 1. Imagine yourself as the CEO of a large firm in an industry in which you are interested. Please (1) identify major trends in the general environment, (2) analyze their impact on the firm, and (3) identify major sources of information to monitor these trends. (Use Internet and library resources.)As I am striving to work in the Funeral or Death Industry as a Funeral Director, I am observing the change in our industry from traditional burial to cremation. This shift in the industry which reduces the price of a funeral by three or four thousand dollars depending on the demographic area, these trends can be followed in Funeral Industry standards such as the NAFD, a Funeral Directors Organization 2. Analyze movements across the strategic groups in the U.S. retail industry. How do these movements within this industry change the nature of competition?The retail industry is driven by young consumers. These consumers make decisions for their group by purchasing the goods and services that they want. Making the decisions changing competiton for everyone. 3. What are the major trends in the general environment that have impacted the U.S. pharmaceutical industry?More easily accessible drug information. Help with drug costs through programs from the pharmacy and the drug companies. Rewards programs. 4. Go to the Internet and look up www.kroger.com. What are some of the five forces driving industry competition that are affecting the......

Words: 321 - Pages: 2

Database Management

...CIV E 603: Information Modeling and Database Systems Lecture 1 1 What to Study?  Introduction to Data base  Relational Model  Database design  Structured Query Language (SQL) 22 Let’s begin the journey !! …. in to fascinating world of databases 23 Today’s outline  Database Management System (DBMS)  Entity-Relationship (ER) Model 24 What is a database?  Many people would like to call it organization… 25 What is a database? Database is a structured collection of related data. Many name it efficiency… 26 A database is  A home for data – since that is where data stay…  A manager for data – since data are organized neatly…  A GOOGLE for data – since a particular record can be found in a snap…  A guardian for data – since a database rejects malicious accesses…  … 27 What is a Database? Database: is a collection of related data Data: known facts that can be recorded and that have implicit meaning Properties of database: • represents some aspect of the real world (mini-world -UoD) • logically coherent collection of data with some inherent meaning. A random assortment of data cannot correctly be referred to as a database. • designed, built, and populated with data for a specific purpose. It has an intended groups of users. 28 What is a Database? A database can be of any size and of varying complexity. • For example, the list......

Words: 2400 - Pages: 10

Chapter 6 Foundations of Business Intelligence: Database and Information Management

...Chapter  5   IT  Infrastructure  and  Emerging  Technologies     IT  Infrastructure   • Shared  technology  resources  providing  platform  for  specific  IS  applications   • Investment  in  hardware,  software,  services  (consulting,  education,  training)   • Foundation  for  serving  customers,  working  with  vendors,  managing  business   process   • Set  of  physical  devices  and  software  required  to  operate  enterprise   • Set  of  firmwide  services   o Computing  platforms  providing  computing  services  (e.g  desktop   computer,  laptop)   o Telecommunications  services   o Data  management  services  (+analyzing)   o Application  software  services  (ERP,  CRM,  SCM,  KMS)   o Physical  facilities  management  services   o IT  management  (plan  infrastr.  Coordinate  with  BU),  standards  (policies),   education  (training)  ,  research  and  development  services  (future   investments)   • “Service  platform”  perspective  more  accurate  view  of  value  of  investments     Evolution  of  IT  Infrastructure   • General-­‐purpose  mainframe  &  minicomputer  era:  1959  to  present ...

Words: 3490 - Pages: 14

Vew full schedule | 11 : الجاسوس-جزء1 | Watch movie