1a) A requirement to begin designing physical files and databases is: A) normalized relations. B) physical tables created. C) implementation complete. D) all datatypes determined. 1b) A key decision in the physical design process is: A) ignoring the size of the database. B) selecting structures. C) deciding on the monitor. D) deciding the e-r diagrams. 1c) Designing physical files requires ________ of where and when data are used in various ways. A) maps B) descriptions C) keys D) hints 1d) Database access frequencies are estimated from: A) transaction volumes. B) user logins. C) security violations. D) random number generation.

1a) A requirement to begin designing physical files and databases is: A) normalized relations. B) physical tables created. C) implementation complete. D) all datatypes determined. 1b) A key decision in the physical design process is: A) ignoring the size of the database. B) selecting structures. C) deciding on the monitor. D) deciding the e-r diagrams. 1c) Designing physical files requires ________ of where and when data are used in various ways. A) maps B) descriptions C) keys D) hints 1d) Database access frequencies are estimated from: A) transaction volumes. B) user logins. C) security violations. D) random number generation.

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter8: System Acquisition And Development

Section: Chapter Questions

Problem 3PSE: A new sales ordering system needs a relational database that contains a customer table, a product...

See similar textbooks

Similar questions

A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spreadsheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.
Your Division Head's point of view is as follows: "Pictures are stored in a database, and the basic design/structure we chose includes some very sensitive driver information." What if we placed it in its own folder, out of reach of people who shouldn't have access to it? What would your stance be, or, more precisely, which strategy would you prefer? It is necessary to present justification.
What is wrong with the following designs from the perspective of cohesion, and what could be done to improve them? There are two subsystems in a university registration system that do the following. Subsystem A displays lists of courses to a student, accepts requests from the student to register in courses, ensures that the student has no schedule conflicts and is eligible to register in the courses, stores the data in the database and periodically backs up the database. Subsystem B allows faculty members to input student grades, and allows administrators to assign courses to faculty members, add new courses, and change a student registration. It also prints the bills that are sent to students. In an electronic commerce application, a module is created to add books to the ‘shopping basket’ and perform such operations as computing the total amount the customer owes. A second module adds ‘special reward’ merchandise to the shopping basket; this module also displays the contents of the…
‘Problem 2: Data Modeling The recrultment agency TEMPO proposes intemship. employees for enterprises for a period of time. An internship employee is a temporary employee that will be recruited for a period of time. You must develop a database application in order to salisfy these: specifications: - The enterprises (id, name, address and phone number) define the posts for which they nead one or many employees. A post is defined with a label, a daily remuneration, the start date, the end cate and the number of employees for this post. A post needs eventually diploma(s) and a list of many skills. - Anintemship employee s described by a ssn, first name, last name, an address, a phone number, histher diplomas (we store for each diploma the year when it is obtained) and his/her skills. - An empioyee could be recruited for one or many posts. This recruitment of an employee for a given post is validated by a chief (ssn, first name, last name, address) designated by the enterprise. This chief…
Given the scenario and requirements in Problem 2, answer the following questions:a. What recommendations will you make regarding the type and characteristics of the required database system?b. What type of data fragmentation is needed for each table?c. What criteria must be used to partition each database?d. Design the database fragments. Show an example with node names, location, fragment names, attribute names, and demonstration data.e. What type of distributed database operations must be supported at each remote site?f. What type of distributed database operations must be supported at the headquarters site?
131. The process of suppression of details regarding storage and data type to highlight important features for better understanding is called a. data abstraction b. structural abstraction c. client abstraction d. server abstraction
Q1: What is wrong with the following designs from the perspective of cohesion, and what could be done to improve them? (a) There are two subsystems in a university registration system that do the following. Subsystem A displays lists of courses to a student, accepts requests from the student to register in courses, ensures that the student has no schedule conflicts and is eligible to register in the courses, stores the data in the database and periodically backs up the database. Subsystem B allows faculty members to input student grades, and allows administrators to assign courses to faculty members, add new courses, and change a student registration. It also prints the bills that are sent to students. ¬ (b) In an electronic commerce application, a module is created to add books to the ‘shopping basket’ and perform such operations as computing the total amount the customer owes. A second module adds ‘special reward’ merchandise to the shopping basket; this module also displays the…
a)Briefly explain the benefits that can be achieved from a high-quality Requirement Engineering Process? b) Shortcomings in requirement practices pose many risks, creeping user requirements is one of these risks. How this risk can be managed? c) Write the FURPS+ category of the following requirements. i. The Persistence will be handled by a relational database ii. A chemist who has never used the Chemical Tracking System before shall be able to place a request for a chemical correctly with no more than 30 minutes of orientation
33. ____________ means to hide certain details of how data is stored and maintain. a. Data Abstraction b. Data Integrity c. Data Isolation d. None of these
1b)By using a scenario, explain program-data dependence issue found in previous database technologies such as file-oriented database before relational database model was introduced.
107. The drawback(s) of a database is (are) a. need to protect sensitive data from unauthorized access b. cost of specialized personnel c. both (a) and (b) d. all application share centralized files
1. A software system that allows users to define, create, maintain and control access to the database. 2. A collection of application programs that performs various services for end users, for example the production of reports. Each program defines and manages its own data. 3. A computerized system whose general purpose is to store information and enable users to retrieve and update it. 4. A shared collection of logically related data, together with a description of these data, which are designed to satisfy the needs of the user.A shared collection of logically related data, together with a description of this data, that is designed to meet the information needs of an organization. Which answer goes with which number a) Database Management System b) File-Based System c) Database System d) Database