1.To build a database that meets business requirements, which of the following information will be important to the database designer? a.The type and amount of data information to be stored b.All the business rules c.What works and what does not in the current business process d.All the above 2.Which of the following are components of data modeling? a.Entities, Attributes and Business rules b.Domains and relations c.All the above d.None of the above 3.State TRUE or FALSE.The entity-relationship data model is a software code used to represent the logical structure of a database. a.This is true b.This is false

1.To build a database that meets business requirements, which of the following information will be important to the database designer? a.The type and amount of data information to be stored b.All the business rules c.What works and what does not in the current business process d.All the above 2.Which of the following are components of data modeling? a.Entities, Attributes and Business rules b.Domains and relations c.All the above d.None of the above 3.State TRUE or FALSE.The entity-relationship data model is a software code used to represent the logical structure of a database. a.This is true b.This is false

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Applications

Section: Chapter Questions

Problem 3PSE

See similar textbooks

Similar questions

Banking Database Schema:branch ( branch_name, branch_city, assets )customer ( cust_ID, customer_name, customer_street, customer_city )loan ( loan_number, branch_name, amount )borrower ( cust_ID, loan_number )account ( account_number, branch_name, balance )depositor ( cust_ID, account_number ) a) What are the appropriate primary keys? Indicate the appropriate primary keys by copying-and-pasting the above schema and underlining the primary key attributes.b. Given your choice of primary keys, identify appropriate foreign keys (i.e. identify attributes in referencing and referenced relations). You can state the foreign key constraints in words. For example, “For loan relation: branch_name attribute referencing branch relation.”c. Construct a relational database schema diagram for the bank database given above. Include a picture/illustration of your relational database schema diagram
Create a summary of database administration information. According to the following, Data and information are critical to the success of a company. 2. Methods for assuring the quality of the data collected. The quality of the information. What a database can do for you Databases of all kinds, from simple to complex. Roles of database administrators and analysts
1.d. Describe the use of null values in a database e. What are the two requirements to ensure entity integrity? 3.d. What are the sources of business rules, and what is the database designer’s role with regard to business rules? e. Describe the three basic characteristics of Big Data databases.
4. What is type of prototyping is used especially for developing Web applications? Select One Evolutionary prototyping Extreme prototyping Incremental prototyping Throwaway Prototyping 5. Which is a simple file that describes the way the data is arranged in a database? Select One data dictionary entity relationship diagram Structured Query Language all of the above 6. What is a method widely used in software engineering that represents a system as a collection of objects that interact with one another? Select One Object-Oriented Planning CASE tools Object-Oriented Analysis and Design all of the above
I. What is needed at ALL stages of the process of developing a database system? a design principles. b system integration c. management approval d. user approval II. Which SQL command must be used when you are using a function (like SUM or COUNT) in a Select statement (like COUNT (CustomerID))? a.Group by b. Select Into c. Order by d.Having III. In the Database Life Cycle (DBLC) which phase includes analyzing the company situation and defining objectives? a.Database initial study b. Database design c. Database design d. Database analysis
Q2 Computer Science Which of the following is NOT among a database design principal a. A database should reflect the real world b. Replace an attribute with an entity when possible c. Designer should avoid redundancy as much as possible d. Designer should ensure simplicity as much as possible
Course: Principles of Database please solve it within 30 minutes. please please, pleaseThank you Single Choice Questions 1. The main function of a database management system is to ( ). A. Achieve unified management of data and perform operations on the data in the database. B. Collect data. C. Plan, design, and maintain databases. D. Provide a data query interface 2. A database is organized and stored in a computer system according to a certain model of ( ). A. Collection of files. B. Collection of programs. C. Collection of commands. D. Collection of data. 3. All base tables comprise the ( ) of the database. A. Internal schema. B. Conceptual schema. C. External schema. D. Logical schema. 4. Traditional data models classify database systems into three types: ( ). A. Interactive, embedded, and hybrid. B. English, Chinese, and compatible. C. Hierarchical, network,…
Q.2. Which of the following provides the best description for a transactional database? 1. Highly denormalized to avoid redundancy of data 2. Delivers a comprehensive overview of organizational data 3. Support business operations of an organization 4. All of the answers are correct 5. Optimised for strategic decision making
Subject: Database Topic: EERD Please use UML Modelling Notation. (Don't use Chen’s Notation or Crow’s Feet Notation). The attached EERD is not the answer. it's for your reference only about UML Modelling Notation. -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. You are required to design a database for a car championship. The requirements are as follows: In the championship, each car’s information such as the car model, the top speed and the acceleration will be stored, and it is identifiable through a unique car ID. Each car will be drove by only one driver. Each driver’s info such as the unique driver number, driver name and the experience level of the driver are stored as well. A driver may have many trainers from more experience drivers and these experience drivers would have at least one trainee who follow them. Each of these drivers are usually supported by a team which each team have a name and is identifiable…
1. Patrick is working for a small data strategy company and involved in a strategy project. Big Data and NoSQL are the two popular technologies today and his job is to compare the two technologies and advise the project owner the impact of Big Data and NoSQL on the future database system trends. Please prepare the answers to the following questions for him: a. Compare the relational database technology to Big Data and NoSQL. b. Discuss the compact of Big Data and NoSQL technologies on the future of databases. Subject: MYSQL
1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.)2. Design a database diagram for a database that stores information about the downloads that users make from a website.Each user must have an email address, first name, and last name.Each user can have one or more downloads.Each download must have a filename and download date/time.Each product can be related to one or more downloads.Each product must have a name.
1， Briefly tell your experiences building a database using Microsoft Access 2， Suggest the best way you can improve your database if you have a chance to do it again in the future. 3， Explain whether your database has achieved your expectations, and justify why.