Premium Essay

Database 1

In: Computers and Technology

Submitted By Tanvir76
Words 521
Pages 3
1. What are the main differences between a file-processing system and a database management system?
Ans: A database management system coordinates both the physical and the logical access to the data, whereas a file-processing system coordinates only the physical access. 2. What are the major advantages of a database system? What are the major
Disadvantages of a database system? Ans:- Advantages a) Controlling Data redundancy
b) Data Consistency
c) Data Sharing
d)Data security

Disadvantages:- a) Cost of hardware and software b) Cost of data sharing c) Database Failures d) Complexity 3. Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2.?
Ans: The database has shown the student information for smith and brown. It also represents the course details. Then it shows the intake of the subject and instructor.
In grade report section its display the grade result of smith and brown.
Also it illustrates the prerequisite for the major subject.
From this Database we can get the information of student, course details, course instructor, prerequisite for the major subject and grade report of the student. 4. Discuss the capabilities that should be provided by a DBMS?
i) Restricting Unauthorised access ii) Providing multiple user interface iii) Controlling redundancy iv) Providing backup and recovery
v) Providing persistence storage for programs object and vi) Representing complex relationship among data vii) Enforcing Integrity constraints

5. List the responsibilities of the database manager. For each responsibility, explain those problems that would arise if the responsibility were not met?

Ans: responsibilities of data manager: a) Interaction with the file manager b) Integrity enforcement c) Security reinforcement…...

Similar Documents

Premium Essay

It250 Chapter 1 - Intro to Databases

...Databases Chapter 1 – Intro Lab 1.2 1. Nouns: doctors, patients, drugs, side effects. 2. Major Topics: doctor Records, patient medical records, side effects / symptoms, and screening records. Lab 1.3 1. Major Topics: faculty, software, and computers. 2. Draft statement of work that includes scope, objectives, and preliminary timeline: a. Scope – A database with the ability to track faculty and staff computers and software. b. Objectives – Faculty software, version, license agreement, record of computers with software, location of computer, user access to computer, software install / uninstall timestamps, status of the computer. i. Additional: ability to track software requests and software availability. c. Timeline ii. Gathering data – gather records of the school computers and its staff, a list of software purchased and in use, interview and questionnaire information understand the faculty needs. Time: 1.5 weeks. iii. Analyzing data – Understanding the data to create data model. Know the needs of the faculty members and type of software / computers in use to determine business rules. Time: 2 weeks. iv. Normalization – Data modeling; entities and relationships normalized. Time: 2 weeks. v. Building the physical database – Create RDBMS database. Time: 4 days. vi. Testing and security – Testing using sample data. Create user permission for different levels of faculty, block out...

Words: 369 - Pages: 2

Premium Essay

Database Unit 1 Lab 1

...Lab 1 1. A collection of information accessible from a computer or server 2. DBMS is a Database Management System that organizes information internally. 3. Dbms stores information, spreadsheet runs formulas 4. Product | Use | Where it was used | Cost | DB2 | Open database environment | A small single-user application to a large multi-user system. | $598 + $99 additional user | Microsoft Access | Relational databases that have tables of data. | Software developers and data architects | $199 (Amazon) | Microsoft SQL Server | primary function is to store and retrieve data as requested by other software applications | workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users | Vary (Different Prices for different purposes) | Filemaker Pro | database engine with a GUI-based interface | ??? | $329.00 | Oracle | transfer any customer info from one location to any other in the world | larger organizations and small chain stores | ??? (Couldn’t find anything) | Mysql | database for use in web applications | Personal and commercial use | $2k-$10k/year | 5. “DBMS stands for database management system whereas RDBMS stands for relational database management system; these softwares are created to maintain and utilize large scale collection of data in an efficient manner.” 6. 290 7. Peng J Wu 8. Footlocker:......

Words: 447 - Pages: 2

Premium Essay

Database Concepts Unit 1

...1. A recent trend for major commercial database developers is to offer free “Express” versions of their databases. Microsoft has SQL Express, Oracle has Oracle Express, and DB2 has DB2 Express. Go to the company websites, and look up these Express editions. What features does each one have? What limits do they have? How do they compare to each other? The features are: SQL Server Express supports most of the features and functionality of SQL Server. The following table lists some of the major features and components that are supported. Stored Procedures SQL Server Configuration Manager Views Replication (as a subscriber only) Triggers Advanced Query Optimizer Cursors SMO/RMO sqlcmd and osql utilities Integration with Visual Studio 2005 Snapshot Isolation Levels Service Broker (as a client only)¹ Native XML support, including XQuery and XML Schemas SQL CLR Transact-SQL language support Multiple Active Result Sets (MARS) Dedicated Administrator Connection² Import/Export Wizard The limits are: The following table lists the additional SQL Server database features that are not supported in this version of SQL Server Express. It also lists database features from previous versions of SQL Server that are not supported. SQL Server features not supported in SQL Server Express SQL Server features from previous versions not supported in SQL Server Express Database mirroring SQL Mail Online restore Fail-over clustering Database snapshot Distributed partitioned......

Words: 376 - Pages: 2

Premium Essay

Database Theory Exam 1

...CHAPTER 1 1 The word ________ indicates that the facts have not yet been processed to reveal their meaning. a. data b. dictionary c. raw d. information correct: c 2 Processed data, or ________, can be used as the foundation for decision making. a. information b. DP c. raw data d. queries correct: a 3 Raw data must be properly ________ for storage, processing, and presentation. a. sorted b. grouped c. formatted d. arranged correct: c 4 What is a key characteristic of knowledge? a. "new" Knowledge can be derived from "old" knowledge. b. It is assembled from raw data. c. It cannot be duplicated. d. It exists in a vacuum. correct: a 5 Accurate, relevant, and timely ________ is the key to good decision making. a. relationships b. data c. processing d. information correct: d 6 What is the name for data about data? a. unique data b. superdata c. metadata d. raw data correct: c 7 Data management is a discipline that focuses on ________. a. the proper generation, storage, and retrieval of data b. the help items to be used by end users c. the management of end users d. the proper generation, storage, and retrieval of information correct: a 8 What is a benefit of using a DBMS? a. It provides seamless Internet access to database data. b. It creates automatic backups. c. It helps create an environment for end users to have access to more data. d. It provides full security to data using private/public key encryption. correct: c 9 The ________ manages interaction between the end...

Words: 8796 - Pages: 36

Premium Essay

Database Processing Ch 1 and Part of Ch 2

...Chapter 1 – Review Questions 1.1 What is the purpose of a database? - The purpose of a database is to help people keep track of things. 1.2 What is the most commonly used type of database? - The relational database is the most commonly used type of database. 1.7 Define the terms data and information. Explain how the two terms differ. - Data are facts and figures. Information is defined as knowledge derived from data, or as data presented in a meaningful context. Data is simply recorded in the database, but the data must be manipulated in some way to produce information. 1.12 What is the purpose of the largest databases used by e-commerce companies such as - The largest databases used by e-commerce companies are Web-activity databases used to track customer behavior. 1.13 How do the e-commerce companies use these databases? - The e-commerce companies’ Web-activity databases are used to determine which Web page items are popular and successful, and to test if certain variations in Web page design will generate more orders. 1.14 How do digital dashboard and data mining applications differ from transaction processing applications? - Digital dashboard and data mining applications do not generate new data, but instead are used to summarize existing data to provide information to management. 1.15 Explain why a small database is not necessarily simpler than a large one. - While small databases vary from large databases in terms of the amount of data......

Words: 1418 - Pages: 6

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

Words: 859 - Pages: 4

Premium Essay

Database Systems Cornel/Morris Chapter 1 Summary

...Chapter 1 Database Systems Why Databases? * At the heart of all of these systems are the collection, storage, aggregation, manipulation, dissemination, and management of data * Databases are specialized structures that allow computer-based systems to store, manage, and to retrieve data very quickly Data vs. Information * Data – raw facts * Raw indicates that the facts have not yet been processed to reveal their meaning * You transform the raw data into a data summary * Information – the result of processing raw data to reveal its meaning * Data processing can be as simple as organizing data to reveal patters or as complex as making forecasts or drawing inferences using statistical modeling * To reveal meaning, information requires context * Raw data must be properly formatted for storage, processing, and processing * Ex: dates must be stored in Julian calendar formats and yes/no responses must be converted to Y/N or 0/1 * Data are the foundation of information which is bed rocked of knowledge * Knowledge – body of information and facts about a specific subject * Knowledge implies familiarity, awareness, and understanding of information as it applies to the environment * A key characteristic of knowledge is that “new: knowledge can be derived from “old” knowledge * Key Points: * Data constitute the building blocks of information * Information is produced by......

Words: 2824 - Pages: 12

Premium Essay

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

Premium Essay

Chapter 1 Test Database Concepts

...answers the question. 1) A good definition for a database is: 1) _______ A) A text file with values delimited by commas B) A collection of related data C) A card catalogue D) A piece of software for managing databases 2) Redundancy refers to what database condition? 2) _______ A) All data is stored in tables B) You have more than one database devoted to the same thing C) The same data is recorded in more than one place in the same database D) A primary key is repeated in another table as a foreign key 3) Which best defines the function of a primary key? 3) _______ A) It uniquely identifies each record B) It is always a number C) It unlocks the data in a table D) It is the first field in a table 4) What best describes the function of a foreign key? 4) _______ A) A foreign key is at the primary key of one table repeated in another table in order to create a relationship between the tables B) A foreign key is a field telling what language the data is in C) A foreign key is a key that doesn't belong in the table D) A foreign key is redundant data 5) A database entity can best be described as: 5) _______ A) The person responsible for the database B) Something that describes a person or process C) Something the database is concerned......

Words: 666 - Pages: 3

Premium Essay

Database Design Chapter 1 Review Questions

...1. a. Data – Raw facts b. Field – An alphabetic or numeric character or group of characters that defines a characteristic of a person, place, or thing. c. Record – A collection of related fields. d. File – A named collection of related records 2. Data redundancy occurs when the same data are stored in multiple places unnecessarily. Have more than one incorrect copies of information can cause it. 3. Data independence exists when you can change the data storage characteristics without impeding the program's ability to access the data. It is lacking because of how it has to tell the computer what to do, and how to do it. Causing the program to have much more lines of code than should be needed. 4. It is a software tool that makes it possible to organize data in a database. Its functions are data dictionary management, data storage management, data transformation and presentation. 5. Structural independence exists when you can change the file structure without affecting the application's ability to access the data. If it did not exist, any change to a files structure would require several extra steps for every single record in the file. 6. Data is raw facts that have not been processed. Information is data that has been processed and given context. Databases help to organize the manipulation of data to create information by providing an organizational structure that makes relationships and connections between data explicit. 7. The DBMS serves as the......

Words: 480 - Pages: 2

Premium Essay

Database Managment - Chapter 1 Assigment

...CHAPTER 1 ASSIGNMENT 1. Part A a. Automatic information processing was introduced by James Power whose company later became known as IBM b. The emergence of reusable data opened up the horizons for database management systems. c. Data provides a competitive advantage for businesses of all shapes and sizes. Part B a. Backup and recovery technology allows database managers to sleep in peace knowing their data is safe. b. Data Security protects consumers from data theft. c. Data privacy is very important. Hospital employees, for example, are only allowed access to certain parts of the EMR system which holds patient data. 2. 1986 – When my world began… IBM becomes the first company to use a one megabit chip in the IBM 3090 1991 – The first web site was built at CERN labs and put online August 6th 1992 – Microsoft Access was released 1995 – MySQL’s initial release 1998 – Google began 2004 – Emergence of Web 2.0 2007 – Amazon releases the Kindle fostering a huge database of electronic books 2013 – MySQL is the second most widely used database management system 2015 – I take Database Management class with Mr. Ted Lee! 3. Here at the Show Me The Money Bank of Tennessee, our database systems allows us to send birthday greetings, send Congratulations to new graduates and newlyweds, reward long time clients, and off the most competitive interest rates on cars, houses, boats, etc. 4. Early data management was very time consuming. The examples of the seven years it took...

Words: 341 - Pages: 2

Premium Essay

Database Unit 1 Homework

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

Words: 286 - Pages: 2

Free Essay

Database 1

...Dylan Gehman Chapter 1 review 1-13   1. System analysis and design techniques provide the analyst with a systematic procedure for analyzing data input, data flow, and information output; furthermore, the techniques can improve the functioning of business. 2. The three roles of a system analyst are: A. Consultant--hired from outside an organization to address information systems issues within that organization. B. Supporting Expert--serves as a resource for those who are managing a systems project. C. Change Agent--an analyst who serves as a catalyst for change, develops a plan for change, and works with others in facilitating that change. 3. Personal qualities helpful to systems analysts include: A. Problem-solving abilities B. Communication skills C. Computer experience D. Self-discipline and self-motivation E. Project management capabilities I4. The seven phases of the SDLC are: 1. Identifying problems, opportunities, and objectives--recognizing problems and opportunities confronting the business and determining business objectives. 2. Determining information requirements--understanding what information users need to perform their jobs. 3. Analyzing system needs--structured analysis of information needs and decision making. 4. Designing the recommended system--logical design of the information system. 5. Developing and documenting software--structured development of software and documentation. 6. Testing and maintaining the system--testing and......

Words: 406 - Pages: 2

Premium Essay

Database Theory Tutorial 1

...DCS5078 DATABASE SYSTEMS TUTORIAL 1 CHAPTER 1 1. Discuss each of the following terms: a. Data b. Field c. Record d. File 2. What is data redundancy, and which characteristics of the file system can lead to it? 3. What is a DBMS, and what are its functions? 4. What is a business rule, and what is its purpose in data modeling? Given the file structure shown in Figure T1.1, answer Problems 5 - 8. FIGURE T1.1 The File Structure for Problems 5-8 5. How many records does the file contain, and how many fields are there per record? 6. What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure? 7. If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure? 8. What data redundancies do you detect, and how could these redundancies lead to anomalies? FIGURE T1.5 The File Structure for Problems 9-11 9. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure T1.5. CDP OCT 2014/2015 1 DCS5078 DATABASE SYSTEMS TUTORIAL 1 10. Identify the different data sources in the file you examined in Problem 9. 11. Given your answer to Problem 10, what new files should you create to help eliminate the data redundancies found in the file shown in Figure T1.5? Use the contents of Figure T1.11 to work problems 12. FIGURE T1.11 Linking......

Words: 355 - Pages: 2

Premium Essay

Week 3 Determining Databases Scenario 1 and 2

...Determining Databases and Data Communications Tasha Carson BIS/320 3/14/2016 Professor Rita Solomon-Moore Determining Databases and Data Communications Scenario 1: The methodology of managing a trade show booth is to keep certain things in mind about the components, equipment and each and every item that is to be transported back to the head office, when you are closing the booth. We are in charge of setting up a consumer electronics trade shown which mainly consists of products like dry batteries, cell phones, laptops, computer accessories, phone accessories and monitor LCDs. We need to make sure that these products are safely returned when the trade show is over. There can be a number of ways in which we to categorize these products into their respective fields so we can keep track of them when shipping them to the main office, because we are liable to the security of these materials. By classifying smaller goods, like dry batteries, we can categorize them into one shipment package that can be transported safely back. Other products like cell phones and their accessories, we can pack them together so we have a safety for the products to remain in one carton. Likewise, keeping computer accessories with laptops and keeping LCDs separate, we can ensure that the products do not get damaged during transportation. Data base system is not that compulsory for managing this equipment, although it is a good thing to have it but it gets costly, when we can easily......

Words: 1125 - Pages: 5