Data quality and date integrity are important issues as they have a significant impact on the output of information and knowledge used by the organization.
A. Discuss data quality by considering its major attributes.
B. Why data integrity is imposed within a database? State four ways data integrity is compromised.
In: Computer Science
Answer the following two questions in paragraph form:
1. A database system is made up of five major parts. Identify these
parts. Provide specifics of what make up these components.
2. A DBMS provides at least nine functions. Identify these
functions and provide a brief explanation of each.
In: Computer Science
A database Deadlock
a. is a lock placed on a record to prevent it from being accessed by other processes.
b. occurs when two records are accidentally assigned the same primary key
c. occurs when a unique record is accessed by several different processes simultaneously.
d. is none of the above.
In: Accounting
identify and briefly discuss three important factors to be aware of for organization that store data in database connected to their management information system?
list and briefly describe 3 points identified from the open revolution class discussion?
why should a business complete a threat and risk assessment of their mis?
In: Operations Management
1. Two long solenoids are placed in the coaxial position, one inside the other, they have 30 cm and 20 cm diameters, respectively. The outer solenoid is 2 m long with 5000 turns, and carrying a current of 4 A. The inner one is 1 m long with 2000 turns, and carrying a current of 2 A in the opposite sense. Find the magnitude of the magnetic field (in mT) at any point on the solenoid axis inside.
A. 10.52
B. 3.68
C. 15.08
D. 7.54
2.
A straight conductor is split into identical semicircular turns, as shown in the figure. What is the magnetic field at the center of the circular loop?
A. μoi/2R
B. μoiR/4
C. 0
D. μoi/4R
3.
Which of the followings are correct for Ampere’s Law? (Choose three correct answers)
A. The magnetic field decreases non-linearly outside of a
current carrying wire
B. The net magnetic field is zero at the both end of the current
carrying wire
C. The magnetic field has its maximum value on the surface of a
current carrying wire
D. The magnetic field increases linearly within a current carrying
wire from its center to its surface
In: Physics
For all questions assume the following starting point: The money supply (M) is composed of currency (C) held by the non-bank private sector (NBPS) and demand deposits (DD) held at banks. Banks are required to hold cash reserves (CR) equal to 10% of their demand deposit liabilities. The remainder of the banks DD liabilities are backed by loans (L). Initially banks have 2000 in cash reserves and the NBPS holds 500 in currency. Currently, banks no not hold excess reserves.
a) What are the initial values for DD, L and M?
b) What happens to the values in part a, if the NBPS decides to hold an additional 200 in currency?
c) What would happen to the values in part a if banks decided to hold 2.5% excess reserves?
d) What happens to the values in part a if concerns about the economy's future caused both b and c to happen?
e) If nominal GDP is 5.5 times the money supply, what happens to nominal GDP in parts a-d
Given the result in part-d, what open market operation would you use to keep the money supply at the level in part a of Module 5?
In: Economics
1a. Construct (draw) an E-R diagram representing the conceptual design of the database. Be sure to identify primary keys, relationship cardinalities, etc. State any assumptions you make.
1b. Convert your E-R diagram to the relational schema. Identify the primary keys of ever relation.
Consider the following application: An electronics vendor operates both a Web site and a chain of many physical stores. Examples include Best Buy and Circuit City. To find out more about this application, think about any experiences you may have had making purchases both online and in-store of a store like Best Buy (you can browse their website).
In our hypothetical company, it has been decided to redesign a major part of the database that underlies company operations. Unfortunately, the manager assigned to solicit database design proposals is not very computer literate and is unable to provide a very detailed specification at the technical level. Fortunately, you are able to do that.
Here are a few points to consider:
• There are different products, grouped into a variety of (possibly overlapping)
categories. Groupings can be done --> by type of product (cameras, phones, etc.), by manufacturer
(Sony, Apple, etc.), or by other means (for example, a Gateway PC might be packaged
with a Sony monitor and an HP printer and marketed as a package).
• Some customers have a contract with the company and bill their purchases to an account number. They are billed monthly. Other customers are infrequent customers and
pay with a credit or debit card. Card information may be stored for online customers,
but not for in-store customers.
• Online sales must be sent to a shipper. The company needs to store the tracking
number for the shipping company so it can respond to customer inquiries.
• Inventory must be accurate both in stores and in warehouses used to replenish stores
and to ship to online customers. When inventory is low, a reorder should be sent to
the manufacturer and listed in the database. When goods arrive, inventory should be
updated and reorders marked as having been filled.
• Sales data are important for corporate planning. Marketers may want to look at sales
data by time period, product, product grouping, season, region (for stores), etc.
In: Computer Science
This is my last assignment in a programming class I had to take as a prerequisite for a database course (seems odd). The instructor has been awful and I haven't learned much of anything. I use VBA at work and just can't follow C++. I'm stuck on this assignment and have no idea what I'm doing. I'm a database guy at work, I'm not a programmer. Please help.
In C++, a program that performs the following tasks:
1. Design a Book class that has three data members:
string title
int pages
double price
2. Add constructors and methods (as well as method parameters when necessary):
Book() // constructor(s)
getBookInfo() // print title, pages, price
setPrice() // change price
3. In the main() function, create two Book objects:
b1("C++ Programming", 834, 93.53)
b2("Data Structures", 217, 64.42)
4. Change the price of b2 to 55.46 using the setPrice() method.
5. Using cout, Print out book information using the getBookInfo() method as shown below:
C++ Programming 834 93.53
Data Structures 217 55.46
IN C++, a program that performs the following tasks:
1. Derive a TextBook class (child) from the Book class (parent).
2. Add new data members:
string school
double discount
3. Add new constructors and methods (as well as method parameters when necessary):
TextBook() // constructor(s)
compTextBookPrice() // price = price - discount
4. Override inherited methods:
getBookInfo() // print title, pages, price, school, discount
5. In the main() function, create two Book objects and two TextBook objects:
b1("C++ Programming", 834, 93.53)
b2("Data Structures", 217, 64.42)
tb1("Database", 365, 74.41, "YSU", 20.00)
tb2("Networks", 522, 92.58, "YSU", 20.00)
6. Using cout, print out book information as shown below:
C++ Programming 834 93.53
Data Structures 217 64.42
Database 365 54.41 YSU 20.00
Networks 522 72.58 YSU 20.00
In: Computer Science
The data in the accompanying table represent the population of a certain country every 10 years for the years 1900-2000. An ecologist is interested in finding an equation that describes the population of the country over time. Complete parts (a) through (f) below. LOADING... Click the icon to view the data table. (a) Determine the least-squares regression equation, treating year as the explanatory variable. Choose the correct answer below. A. ModifyingAbove y with caretequals2 comma 022xnegative 1 comma 542 comma 401 B. ModifyingAbove y with caretequalsnegative 3 comma 776 comma 857xplus2 comma 022 C. ModifyingAbove y with caretequals2 comma 022xnegative 3 comma 776 comma 857 D. ModifyingAbove y with caretequals1 comma 236 comma 373xnegative 3 comma 776 comma 857 (b) A normal probability plot of the residuals indicates that the residuals are approximately normally distributed. Test whether a linear relation exists between year and population. Use the alphaequals0.01 level of significance. State the null and alternative hypotheses. Choose the correct answer below. A. Upper H 0: beta 1 equals 0 Upper H 1: beta 1 not equals 0 B. Upper H 0: beta 1 equals 0 Upper H 1: beta 1 greater than 0 C. Upper H 0: beta 0 equals 0 Upper H 1: beta 0 greater than 0 D. Upper H 0: beta 0 equals 0 Upper H 1: beta 0 not equals 0 Determine the P-value of this hypothesis test. P-valueequals nothing (Round to three decimal places as needed.) State the appropriate conclusion. Choose the correct answer below. A. Reject Upper H 0. There is sufficient evidence to conclude that a linear relation exists between year and population. B. Reject Upper H 0. There is not sufficient evidence to conclude that a linear relation exists between year and population. C. Do not reject Upper H 0. There is sufficient evidence to conclude that a linear relation exists between year and population. D. Do not reject Upper H 0. There is not sufficient evidence to conclude that a linear relation exists between year and population. (c) Draw a scatter diagram, treating year as the explanatory variable. Choose the correct graph below. A. 1900 2000 Year, x Population, y font size decreased by 3 1 times 10 Superscript 5 font size decreased by 3 2 times 10 Superscript 5 font size decreased by 3 3 times 10 Superscript 5 A scatter diagram has a horizontal axis labeled Year, x from 1900 to 2000 in increments of 100 and a vertical axis labeled Population, y from 0 to 4 times 10 Superscript 5 in increments of 1 times 10 Superscript 5. A series of plotted points closely follow the pattern of a line rising from left to right passing through the points (1900, 80000) and (2000, 280000). All coordinates are approximate. B. 1900 2000 Year, x Population, y font size decreased by 3 1 times 10 Superscript 5 font size decreased by 3 2 times 10 Superscript 5 font size decreased by 3 3 times 10 Superscript 5 A scatter diagram has a horizontal axis labeled Year, x from 1900 to 2000 in increments of 100 and a vertical axis labeled Population, y from 0 to 4 times 10 Superscript 5 in increments of 1 times 10 Superscript 5. From left to right, a series of plotted points closely follow the pattern of a line rising passing through the point (1900, 80000) to the point (1950, 150000), and then closely follow the pattern of a line falling to the point (2000, 80000). All coordinates are approximate. C. 1900 2000 Year, x Population, y font size decreased by 3 1 times 10 Superscript 5 font size decreased by 3 2 times 10 Superscript 5 font size decreased by 3 3 times 10 Superscript 5 A scatter diagram has a horizontal axis labeled Year, x from 1900 to 2000 in increments of 100 and a vertical axis labeled Population, y from 0 to 4 times 10 Superscript 5 in increments of 1 times 10 Superscript 5. A series of plotted points closely follow the pattern of a line falling from left to right passing through the points (1900, 280000) and (2000, 80000). All coordinates are approximate. (d) Plot the residuals against the explanatory variable, year. Choose the correct graph below. A. 1900 2000 0 -10,000 10,000 -20000 20000 Year, x Residuals A scatter diagram has a horizontal axis labeled Year, x from 1900 to 2000 in increments of 100 and a vertical axis labeled Residuals from negative 20,000 to 20,000 in increments of 10,000. From left to right, a series of plotted points follow the pattern of a curve rising passing through the point (1900, negative 8000) to a maximum at the point (1920, negative 1000), falling to a minimum at the point (1950, negative 15000), rising to a maximum at the point (1980, 0), and falling to the point (2000, negative 14000). All coordinates are approximate. B. 1900 2000 0 -10,000 10,000 -20000 20000 Year, x Residuals A scatter diagram has a horizontal axis labeled Year, x from 1900 to 2000 in increments of 100 and a vertical axis labeled Residuals from negative 20,000 to 20,000 in increments of 10,000. A series of plotted points closely follow the pattern of a line rising from left to right passing through the points (1900, negative 13000) and (2000, 5000). All coordinates are approximate. C. 1900 2000 0 -10,000 10,000 -20000 20000 Year, x Residuals A scatter diagram has a horizontal axis labeled Year, x from 1900 to 2000 in increments of 100 and a vertical axis labeled Residuals from negative 20,000 to 20,000 in increments of 10,000. From left to right, a series of plotted points follow the pattern of a curve falling passing through the point (1900, 8000) to a minimum at the point (1950, negative 15000), and then rising at a decreasing rate passing through the point (1990, 2000). A point is plotted at (2000, 14000). All coordinates are approximate. (e) Does a linear model seem appropriate based on the scatter diagram and residual plot? Yes No (f) What is the moral? A. The moral is that explanatory variables may indicate that a linear relation between the two variables does not exist even though diagnostic tools (such as residual plots) indicate that a linear model is appropriate. B. The moral is that inferential procedures may indicate that a linear relation between the two variables exists even though diagnostic tools (such as residual plots) indicate that a linear model is inappropriate. C. The moral is that inferential procedures may indicate that a nonlinear relation between the two variables exists even though diagnostic tools (such as residual plots) indicate that a linear model is appropriate. Click to select your answer(s).
Year, x Population, y
1900 73212
1910 95228
1920 106021
1930 123202
1940 132164
1950 151325
1960 179323
1970 203302
1980 226542
1990 248709
2000 281421
In: Statistics and Probability
What are some characteristics of a normal distribution? What does the empirical rule tell you about data spread around the mean? How can this information be used in quality control?
Can you compare apples and oranges, or maybe elephants and butterflies? In most cases the answer is no – unless you first standardize your measurements. What are a standard normal distribution and a standard z score?
In: Statistics and Probability