Database Question

Create two entities for Online Journalists business.

Each entity must have 5 attributes and explain the type of each attribute.

A systems developer needs to provide machine-to-machine interface between an application and a database server in the production environment. This interface will exchange data once per day. Which of the following access control account practices would BEST be used in this situation?

A.Establish a privileged interface group and apply read -write permission.to the members of that group.

B.Submit a request for account privilege escalation when the data needs to be transferred

C.Install the application and database on the same server and add the interface to the local administrator group.

D.Use a service account and prohibit users from accessing this account for development work

A marketing director of a soft drink company wants to know what proportion of its potential U.S. customers have heard of a new brand. The company has access to a database with the mobile phone numbers of 10,000 U.S. college students. The director’s assistant asks a simple random sample of 50 students from this database whether they heard of the new soft drink brand, and constructs the sample proportion. 1 (a) What is the target population? (b) What is the sampled population? (c) Will the sample proportion be unbiased for the proportion in the sampled population? Explain. (d) Will the sample proportion be unbiased for the proportion in the target population? Explain.

A new hospital is preparing to open. They want to ensure that, when it is time to report on the national quality measures to The Joint Commission, the data flows properly.

Assist in creating the data dictionary for the following data elements to be reported by noting the correct format and allowable values.
Identify and use the appropriate source document for this information.
Admission date
Discharge disposition
Sex
Race
Hispanic
Payment source

Objective: Apply knowledge of database architecture and design

Assessment: Student will apply knowledge of database architecture and design by formatting a data dictionary to the standardization of internal and external forces to meet the needs of the enterprise.

1. These three terms all refer to the same part of a database: True or False

• Instance
• Row
• Field

  2. When compared to File Processing systems, select each of the following that are advantages of a database system. Note: there may be more than one right answer.

  Group of answer choices;

  A. Shorter development times.

  B. If the data structure changes, a program may not need to be changed.

  C. The data does not need to be duplicated.

  D. There is very little if any program-data dependence

• 3. Describe the difference between a logical data model and a physical data model.

(TCO F) A chain of fitness centers with 25 locations throughout the Southwest currently maintains several different operational databases. At corporate headquarters, the marketing department maintains a marketing database with information on advertising, e-mail promotions, and inquiries from prospective customers; and the accounting department maintains a financial database for budgets, accounts receivable, accounts payable, and general ledger. Each location maintains its own records of members, subscription payments, and member visits to the location. Propose at least three ways in which this organization could benefit from adopting an enterprise data warehouse.

1. Fortunately, once an application that accesses a database is tuned for optimal relational access to the data, there is never any performance degradation after that.

.True

.False

2 Monitoring a database system for performance management purposes means to watch the system as it runs, paying particular attention to statistics gathered by the RDBMS

. True

. False

3. RDBMS, in general, during normal operational use, use _______________ cache(s). Choose the best answer

a. exactly two

b. no

c. a number of

d. exactly one

4. Indexes can be used to avoid having the RDBMS sorted returned data.

. True

. False

The Jonesburgh County Basketball Conference (JCBC) is an amateur basketball association. Each city in the county has one team as its representative. Each team has a maximum of 12 players and a minimum of 9 players. Each team also has up to 3 coaches (offensive, defensive, and physical training coaches). During the season, each team plays 2 games (home and visitor) against each of the other teams. Given those conditions, do the following:

• Draw the Chen and Crow’s Foot ERDs to represent the JCBC database.

• Draw the UML class diagram to depict the JCBC database.

Compare the strengths and weaknesses of SQL and NoSQL Databases.

1. What´s the meaning of each and how they work and store data. 2. In which scenarios is better to use one or the other. 3. What are the different types of SQL and NoSQL Databases. 4. What are the advantages of NoSQL over traditional SQL Databases. 5. When to use a NoSQL database instead of a relational database? 6. Which one is more scalable and flexible and in which scenarios. 7. Explain the use of transactions in SQL and NoSQL Databases. 8. Provide good examples on each. 9. Provide a good conclusion.

Perfect Pizza is a pizza delivery and pick up shop. They are hiring you to create a database designed to track their customers, employees, products, and orders. Their needs are outlined below. They want to use the customer’s telephone number to identify the customer. They are interested in households, not individuals. They need the street address and zip code for delivery. They only deliver to the following zip codes: 29572, 29575, 29577, 29578, 29579, and 29588. Since all zip codes are in the Myrtle Beach area, they would like that information auto filled for the city and state, but want the option to enter other cities and states due to pick up orders from tourists. They also need an order detail table to store the price charged. They need to be able to change the price charged for two reasons: it may be different than product price due to a discount or special allowance and it will keep a historic record of the price. That way, when they are updating a product in the product table, it doesn’t affect the prices charged in past sales.

1) Make a list of Entities you feel this database needs and give an explanation for your reasoning behind each one. 2) For each of the entities you listed above, list the attributes you feel need to be included in each of those entities. 3) Identify the attribute that would be designated as the primary key in each entity. 4) Make a list of questions you would ask to help you better design the database. (Must be at least 5 questions) 5) Make a list of suggestions for the pizza shop owners to improve the database. (Must be at least 3 suggestions)