C:/Users/TWRC/DownloadsA قراءة بصوت عالعرضLab 1: Database SystemsI.IntroductionThis first lab focuses on database management systems (DBMSS)-what they are, what they do, and whywe need them.Review Questions1) Define each of the following terms:II.a. datab. fieldc. recordd. file2) What is data redundancy, and which characteristics of the file system can lead to it?3) What is data independence, and why is it lacking in file systems?4) What is a DBMS, and what are its functions?5) What is structural independence, and why is it important?6) Explain the differences between data, information, and a database.7) What is the role of a DBMS, and what are its advantages? What are its disadvantages?8) Describe different types of databases.9) What are the main components of a database system?10) What is metadata?11) Explain why database design is important.12) What are the potential costs of implementing a database system?13) Use examples to compare and contrast unstructured and structured data. Which type is moreprevalent in a typical business environment?III.ActivitiesGiven the file structure shown in the following figure, answer the questions below:MANAGER ADDRESS3334 Lee Rd., Gainesville, FL 37123PROJECT_CODE PROJECT_MANAGER MANAGER_PHONEHolly B. ParkerPROJECT_BID_PRICE16833460.0021-5Z25-2D25-5A25-9T27-4Q29-2031-7PHow many records does the file contain? How many fields are there per record?904-338-3416615-898-9909218 Clark Blvd, Nashville, TN 3636212500000.00Jane D Grant124 River Dr Franklin, TN 291853334 Lee Rd., Gainesville, FL 37123124 River Dr., Franklin, TN 291853334 Lee Rd., Ganesville, FL 37123216 Morton Rd, Stetson, FL 3015532512420.00George F. DortsHolly B. ParkerGeorge F. DortsHolly B. Parker615-227-1245904-338-341621563234.00615-227-124510314545.00904-338-341625559999.0056850000.00VWilliam K. Moor904-445-2719

“Since you have asked multiple questions, we will solve the first question for you. If you want any…

1) Define 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 data independence, and why is it lacking in file systems?

1) Define 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 data independence, and why is it lacking in file systems?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

A driver’s license bureau maintains a database of licensed drivers. State, whether each of the following represents data or metadata: (just write data or metadata for each answer) A) Driver’s name, address, and birth date. B) The fact that the driver’s name is a 30-character field. C)The make and serial number of the scanning device that was used to scan the fingerprint. D)The resolution (in megapixels) of the camera that was used to photograph the driver. E)The fact that the driver’s birth date must precede today’s date by at least 16 years
Identify and discuss the serious data redundancy problems exhibited in the following file structures. Also discuss how could these redundancies lead to anomalies?
1. Discuss each of the following terms: 1. data 2. field 3. record 4. file 2. What is data redundancy? 3. Discuss the disadvantages of file-based systems. 4. Explain the difference between data and information.
This is a Database System question in Computer Science. Popular file types offer a predictable for of related data. List all file formats which knows form of related data. Do you have a particular file format that you like? Include some reasons why you like it. Thank you.
What is true about storage limitations with databases? a.) All commercial databases have the same database storage size limitations. b.) All paid commercial databases have the same database storage size limitations. c.) All commercial databases can support unlimited data for storage. d.) Most commercial databases do not have the same database storage size limitations.
in a database, the foreign key field is used to Select one: a. identify duplicated data o b. create a link c. uniquely identify a record d. specify an entity
Explain the concept of object serialization in programming. Why is it important, and how does it enable data persistence?
Which one of the following IS a characteristic of file based information systems? Question 14 options: 1) File systems can be maintained by users with no programming background. 2) Excessive data redundancy is often present leading to loss of data integrity. 3) It is easy for non-programmers to perform ad-hoc queries on the data. 4) The programmer does not have to manage the storage and security of the data.
How many records does the file contain? How many fields are there per record? 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? 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? What data redundancies do you detect? How could those redundancies lead to different types of anomalies?
22. Before any changes to database structure are attempted one should first: a. clearly understand the current structure and contents of the database only. b. test any changes on a test database only. c. create a complete backup of the operational database only. d. All of the above should be done.
File type formats and markers in each file type that are unique. For example header signatures, tail signatures, intermediate markers. Make a detailed presentation of these markers for the file type selected by you. The focus should be how you can use these markers to identify blocks that belong to this filetype. The file type is .AVI