Premium Essay

Database Unit 1 Homework

In:

Submitted By Samba
Words 286
Pages 2
1. List the components included in a Relational Database Management System (RDBMS) in general.
Client and server, tools for backup and restore, tools for creation and maintenance of the DB, tools for securing access, administrative and reporting tools and often tools for data analysis.

2. What is the language used to interact with most modern relational database?
SQL

3. List the three (3) properties of a primary key.
Unique
Not Null
Can not be changed

4. Why is it required that every table in a modern relational database has a primary key defined?
The primary key in a given table is the only unique identifier for a row or record

5. Explain what “data integrity” means in the context of a modern relational database.
Data integrity means the data is consistent and factual, the data can be “trusted”

6. Explain why data redundancy is generally a “bad” thing in a modern relational database.
Storing the same exact information in multiple places leads to problems on update and delete and drastically increases the chance of data becoming inconsistent.

7. What is a “foreign key” in the context of a modern relational database. What is the role of a foreign key?
A foreign key is a primary key that has been imported from another table. The foreign key reinforces the “relationship” between two tables.

8. What is the relationship between a foreign key and a primary key?
A foreign key is a primary key that has been imported from another table.

9. What is one other example of a database besides relational database? delimited, fixed length, spreadsheet or hierarchical.

10. What is one other database product besides Microsoft SQL Server 2008?
MySQL, PostgresSQL, IBM DB2, Oracle DB,

Similar Documents

Premium Essay

Second Chapter

...Unit 2 Assignment 1: Homework Learning Objectives and Outcomes Review documents to discover relevant entities and attributes for database. Prepare interview questions and follow up. Prepare questionnaires. Observe work flow for process and exceptions. Identify the issues with the current database. Define and list requirements of a database. Define business rules of a database. Define entities and attributes of a database. Identify candidate keys for entities of a database. Assignment Requirements Answer the following True or False questions on the student answer sheet. Required Resources Textbook Submission Requirements Submit your written answers to your instructor at the beginning of Unit 3. Unit 2 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1) A requirement is something a database needs to do in order to fulfill its purpose.t 2) You only need to include the most important stakeholders in the database discussions.f 3) Forms are used for gathering input.t 4) A transaction database is optimized to track transactions in real time.t 5) Data mining uses business intelligence tools and techniques on a variety of data sources brought together in a data warehouses.t 6) The domain is the focus or knowledge area of a database.t 7) Interviews are good for asking open ended questions.t 8) Open ended question are questions that don't have fixed...

Words: 687 - Pages: 3

Premium Essay

Computer

...processing • Information • Information retrieval • Managing information Information Processing • Using an existing database • Creating a database Lesson 1 Unit 1T: Structure and Functions of computer 1T.1 Major functions and parts Specific Objectives: 1. List the three main components of a computer system. 2. Describe the functions of the three main components of a computer system. 3. List the three components of the CPU. 4. Briefly describe the functions of the following three components of the central processing unit. a. Arithmetic logic unit b. Control unit c. Registers 5. Explain what is meant by primary memory/storage. 6. Define secondary storage/memory. 7. Differentiate between Random Access Memory (RAM) and Read Only Memory (ROM). 8. Identify various types of : a. input devices b. output devices c. storage devices 9. Compare the use of various types of: a. input devices b. output deices c. storage devices 10. Identify the most commonly used input, output and storage devices. 11. Describe the basic structures of the following: a. floppy disk b. disk drive c. hard disk 12. Briefly explain how a disk drive works. 13. Relate the major parts of the microcomputer to the input-processing-output sequence. 14. Describe the processing cycle from input to output in terms of input, central processing unit and output. 15. Draw a simplified diagram of the components of a computer system to...

Words: 567 - Pages: 3

Free Essay

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 plans...

Words: 859 - Pages: 4

Free Essay

Unit 1 and Part of 2

...Unit 1 Homework 1. Why is the CPU the most important component in a computer? It’s the brain of the computer, without it nothing else matters. 2. What number does a bit that is turned on represent? What number does a bit that is turned off represent? 1, 0 3. What would you call a device that works with binary data? digital 4. What are the words that make up a high-level programming language called? Key Words 5. What are the short words that are used in assembly language called? Mnemonics 6. What is the difference between a compiler and an interpreter? A COMPILER is a program that translates a high-level language program into a separate machine language program. An INTERPRETER is a program that both translates and executes the instructions in a high-level language program 7. What type of software controls the internal operations of the computer’s hardware? OS’s Unit 1 Research Assignment 1. SQL It’s no surprise SQL (pronounced ‘sequel’) tops the job list since it can be found far and wide in various flavors. Database technologies such as MySQL, PostgreSQL and Microsoft SQL Server power big businesses, small businesses, hospitals, banks, universities. Indeed, just about every computer and person with access to technology eventually touches something SQL. For instance, all Android phones and iPhones have access to a SQL database called SQLite and many mobile apps developed Google, Skype and DropBox use it directly. 2. Java The tech community recently celebrated...

Words: 1008 - Pages: 5

Premium Essay

Absolutism and Relativism

...AQA AS Level ICT Course Handbook Contents 1: Introduction. 3 2: Code of Conduct 3 3: Resources 5 4: Homework 5 5: Contact Details 5 6: Course Structure 5 8: Monitoring Your Own Progress 6 9: Coursework Assignments 7 1: Introduction. Welcome to AS Level ICT. Please keep this handbook at the beginning of your ICT folder. What is the aim of this course? Information Technologies are now widely used in all aspects of government, business, education, leisure and the home. In an increasingly technological age, a study of Advanced Information Technology and particularly how computers are used in the solution of a variety of problems, is not only valuable to the students themselves but also essential to the future well being of the country. The course aims to provide students with knowledge and understanding in areas including: • An understanding of the nature of information, its structure, application and implications of its   uses.      • An awareness of the role of IT in the management, manipulation and dissemination of   information.       • An understanding of the role of people, technology and systems in   organisations.                                 • An awareness of the economic, social and ethical implications of the use of IT systems. • An understanding of the range of applications and information systems...

Words: 2055 - Pages: 9

Premium Essay

Argument

...Argument Essay Unit: Lesson Plan and Class Activities Global Learning Outcomes for this Unit *In the course of completing the assignment students will: • Learn to compose an argumentation-oriented thesis • Defend their thesis with academic-quality research that is properly sourced and cited as per the standard of university level writing • Anticipate and respond to counterarguments • Learn to critically engage the revision process through draft writing, instructor conferencing, and peer commentary • Respond the work of their peers as peer reviewers while providing relevant, productive feedback Class 1 – Introducing the Classical Argument Essay *Daily Learning Outcomes: • Reflect on Informative Essay • Introduce Classical Argument Essay • Break down the assignment sheet *Activity 1: Individual Reflection / Class Discussion (15 min) - Students open their portfolios and journals then reflect for ~10 minutes on their experiences during the Informative Essay Unit - Discuss reflections as a class *Activity 2: Introduce Classical Argument (20 min) - Have students bring a hard copy of the assignment to class with a highlighter: a. Get into groups of 4 b. Read the sheet aloud, highlighting all the action verbs c. Discuss the sheet as a group as instructor makes rounds *Activity 3: Mini-Lecture on Assignment /Questions (15 min) - Powerpoint slides “The Features of an Academic Argument” - Allow...

Words: 4392 - Pages: 18

Premium Essay

Yet Unknown

...Argument Essay Unit: Lesson Plan and Class Activities Global Learning Outcomes for this Unit *In the course of completing the assignment students will: • Learn to compose an argumentation-oriented thesis • Defend their thesis with academic-quality research that is properly sourced and cited as per the standard of university level writing • Anticipate and respond to counterarguments • Learn to critically engage the revision process through draft writing, instructor conferencing, and peer commentary • Respond the work of their peers as peer reviewers while providing relevant, productive feedback Class 1 – Introducing the Classical Argument Essay *Daily Learning Outcomes: • Reflect on Informative Essay • Introduce Classical Argument Essay • Break down the assignment sheet *Activity 1: Individual Reflection / Class Discussion (15 min) - Students open their portfolios and journals then reflect for ~10 minutes on their experiences during the Informative Essay Unit - Discuss reflections as a class *Activity 2: Introduce Classical Argument (20 min) - Have students bring a hard copy of the assignment to class with a highlighter: a. Get into groups of 4 b. Read the sheet aloud, highlighting all the action verbs c. Discuss the sheet as a group as instructor makes rounds *Activity 3: Mini-Lecture on Assignment /Questions (15 min) - Powerpoint slides “The Features of an Academic Argument” - Allow time for student questions...

Words: 4393 - Pages: 18

Free Essay

What Is the Difference Between a “Dashboard” and a “Scorecard”? Why Is It Important That Managers Know the Difference Between the Two? What Can They Learn from Each of Them?

... | | | MISY 3310 Management Information Systems Section W01: Online Course; 2013 Spring Semester Instructor: Dr. Tim Klaus Office: OCNR 385 Telephone: Office: (361) 825-2379 Cell Phone: (361) 248-8495 – feel free to call Mon-Sat between 9AM-10PM (I’ll be able to receive or return your call quicker than if you call the office) E-mail: tim.klaus@tamucc.edu Office Hours: Monday 8:30-8:55 AM, 9:55-10:55 AM, 12:00-3:10 PM Wednesday 8:30-8:55 AM, 9:55-10:55 AM Other days and times by appointment Course Website (Blackboard): http://iol.tamucc.edu/ Course Materials 1. Required Text: O’Brien, James and George Marakas, Introduction to Information Systems: Essentials for the E-Business Enterprise, 16th ed., Irwin/McGraw-Hill. Print - ISBN: 0073376884 eText – ISBN: 0077506413 2. Course material through http://iol.tamucc.edu/ Optional Materials None Prerequisites MISY 2305 or equivalent and Junior standing or above. Course Description: Provides an understanding of the importance of computer-based information in the success of the firm. Illustrates ways in which companies utilize computer systems to strategically compete within certain industries. Emphasis is on the role of information systems within each of the functional areas of business. Major concepts include data management, decision...

Words: 2297 - Pages: 10

Premium Essay

Unit 6 Assignment 1 Questions

...Unit 6 Assignment 1: Homework Learning Objectives and Outcomes Name the main events in the development of SQL statements. Run SELECT queries with wild cards, DISTINCT key word, calculations, sorting and aliasing. Run queries with the WHERE clause to filter the result sets. Use the Aggregate functions COUNT, AVG, SUM, MIN, and MAX. Assignment Requirements Answer the true-or-false questions on the next page by filling out the answer sheet. Required Resources Textbook Submission Requirements Submit your completed answer sheet to your instructor at the beginning of Unit 7. Unit 6 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1) SQL is the programming language used to manipulate data and data objects in a relational database management system. 2) SQL is a procedural language. 3) A declarative language is a language in which you tell the computer what to do not how. 4) DML, or Data Manipulation Language, contains all the commands for selecting and modifying data. 5) DDL, or Data Definition Language, contains all the commands for selecting and modifying data. 6) The * in SELECT * clause of an SQL statement is a wildcard for returning all columns in a table. 7) The DISTINCT keyword in a SELECT statement returns only unique rows. 8) The FROM keyword is used in a SELECT clause to determine which columns are included in the query. 9) An alias in SQL is a substitute...

Words: 363 - Pages: 2

Free Essay

Bae Project

...Homework #2 – Excel Charts and Pivot Tables Overview and Learning Objectives This homework assignment asks you to use Microsoft Excel to use the VLookup function in a report, and also to generate charts and pivot tables. These are all useful skills. VLookup simplifies spreadsheet logic in many situations, and charts offer a visual perspective that can help people to see trends and data relationships. And once you get the idea of pivot tables, they are extremely useful in summarizing data “on the fly” in a variety of formats. This assignment is related to course objective #4 (“Design and implement Microsoft Excel spreadsheets and Microsoft Access databases to support business decision making”). Quality Furniture Enterprises, Continued This homework assignment continues the scenario from Homework #1, about Quality Furniture Enterprises. Caitlin’s uncle (and boss) was pleased with the sales forecast report she created. “I guess I should learn Excel,” he says. “I’ve been using the calculator on my laptop to compute the totals, and then copying and pasting things into a Word document.” Caitlin did her best not to appear smug, but it was nice to be appreciated, especially since this was still her first month on the job. But before she had any time to bask in her success, her uncle said, “And since you did so well on that report, I have another project for you.” So much for taking an early lunch break today. “Sure,” she said. “What do you need?” “First off, remember how I told...

Words: 1904 - Pages: 8

Free Essay

Nt 1230 Assignment and Exercise

...Unit 8 Homework Unit 8 Assignment 1 DNS is a server based distributed database management system that translates domains host’s names to IP Addresses. It also allows a computer host or a client to use words instead of numbers to request information from a server or a client. You can get words or numbers to get the information from servers. Unit 8 Assignment 2 In Windows NT, when you make a change to the Security Accounts Manager, the change is applied directly to the Primary Domain Controller and is later replicated to each Backup Domain Controller. In an Active Directory multi-master replication environment, each domain controller contains a copy of Active Directory, not just the information for a single domain. When a change is made to Active Directory, the change is applied to whatever domain controller is the closest, and is then replicated to the remaining domain controllers. This prevents a designated Primary Domain Controller from being overburdened. Centralization sums up a primary reason for implementing Active Directory. The Active Directory structure makes it possible for you to achieve truly centralized management of users, regardless of how big the client’s network has become. In Windows NT a domain is a completely independent entity, and while it's possible to create a trust relationship between domains that exist on a common network, the domains are never truly integrated with each other because there is no higher authority that manages the domains. The domain...

Words: 422 - Pages: 2

Premium Essay

Rialway

...Homework Title / No. : ____________________________________________Course Code : _________ Course Instructor : ______________________ Course Tutor (if applicable) : ____________ Date of Allotment : _____________________ Date of submission : ___________________ Student’s Roll No._______________________ Section No. : _________________________ Declaration: I declare that this assignment is my individual work. I have not copied from any other student’s work or from any other source except where due acknowledgment is made explicitly in the text, nor has any part been written for me by another person. Student’s Signature : _____________ Evaluator’s comments: _____________________________________________________________________ Marks obtained : ___________ out of ______________________ Content of Homework should start from this page only: | | INDEX | | |1 | Elaborate on the advantages of DBMS over file system. | | |2 | Explain in detail the architecture of DBMS. | | |3 |What are the various responsibilities of a DBA. | | ...

Words: 1998 - Pages: 8

Premium Essay

Asperger's

...Running head: Asperger’s Syndrome Asperger’s Syndrome Cynthia Brownlee Eng 101 October 30, 2011 Abstract Asperger Syndrome (AS) is a relatively new disability to the United States. The awareness of the disability is about twenty years old. However, the increase of the number of individuals being diagnosis is rapidly growing. This paper defines the characteristics of an AS individual and provides information for educators as far as strategies and accommodation needed to make the classroom successful. The education arena holds the responsibility of learning strategies and interventions in assisting an individual with AS. Asperger’s Syndrome According to Lee and Park (2007), “‘Autistic psychopathy’ (as cited in Asperger, 1944, p.76) was the first term used to describe Asperger’s Syndrome” (p. 132). In 1943 the condition of autism was discovered by Dr. Leo Kanner. His description of autism reflects the lack of involvement of children socially with other people, but reflects the consistency of routines and differences in mannerisms. In 1944 Dr. Hans Asperger, who was unknowing of Kanner’s work with autism, introduced children with a milder form of Autism. He published his work; however, the audience of the research was very limited. Asperger revealed in Asperger’s Syndrome (AS) when his works were published in Germany. The United States was not introduced to this disability until...

Words: 2591 - Pages: 11

Premium Essay

Sylubus

...ANTHROPOLOGY 101 Introduction to Cultural Anthropology Queens College / CUNY, Spring 2015 TuTh 12:15-1:30PM, Kiely 150 Professor: Ramona Lee Pérez, PhD Email: ramona.perez@qc.cuny.edu Office hours: Th 2-3 PM, PH 315H COURSE DESCRIPTION This course is an introduction to the range of human diversity through an exploration of the peoples of the world. We will cover the basic concepts, theories, and methods that anthropologists use to study variations in cultural norms and social practices, economic systems and rules of law, social organization and patterns of inequality, identity and worldview, and patterns of social and cultural change. Focusing on the culture concept and the method of ethnography, we begin with the historical foundations of anthropology and then follow its attempts to understand contemporary human cultures. Comparative analysis of multiple ethnographic case studies and major theoretical approaches illuminates the range of human diversity, the forces that shape cultures, and how people adapt to a rapidly changing modern world. The central objectives of this course are to develop your intellectual skills, your cross-cultural fluency, and your sense of civic and moral engagement in global society. I hope that this course inspires many of you to become anthropology majors or minors, and grants each of you an anthropological perspective on your own life. REQUIREMENTS This is an intensive course that requires full participation from every student...

Words: 9454 - Pages: 38

Premium Essay

Management Information System

...Homework #5 Due: 12:00pm noon, 4/30/2009 Topic: Build, Manage, and Globalize Projects Reading: Chapters 13, 14, and 15 Instruction 1: Write answers in your own language. In other words, if you find some answers from the textbook or other resources, paraphrase them thoroughly and add references or URLs as follows: • Example 1: Infosys is one of the exemplary companies that provide outsourcing services globally (Thomas L. Friedman, “The World is Flat,” p. 110). • Example 2: SAP provides various core business functions, such as finance, human resource, and manufacturing (http://www.nytimes.com/2008/08/25/technology/25sap.html). Instruction 2: Only cite the reliable sources defined as “Scholarship” and “News Organizations” in http://en.wikipedia.org/wiki/Wikipedia:Reliable_sources. Note that Wikipedia itself is NOT considered as a reliable sources because some contents of it are still evolving and may contain biased and partial information. Wikipedia may contain links to good resources, though. Instruction 3: Basically, submit only your answers, not the instruction and questions. All instructions and questions are highlighted in yellow (except for the homework number and due dates). Thus, before submitting your homework, remove all of the yellow areas. If you keep the yellow area, the plagiarism detection system may put a flag on your homework. Instruction 4. Save your answers in a file as “hw2_[Purdue Career Account].doc” (e.g, “hw2_yij.doc”), and...

Words: 3289 - Pages: 14