BUS-120-Debriefing-paper-outline
.docx
keyboard_arrow_up
School
San Jose State University *
*We aren’t endorsed by this school
Course
120B
Subject
Business
Date
May 17, 2024
Type
docx
Pages
2
Uploaded by SuperHumanThunder12272
Cao Kieu My Nguyen
Trinh To
Huynh Tran
BUS 120 Debriefing paper outline
1. Please briefly describe some of the challenges encountered when building a database from an ER diagram with minimal user input.
-
Reading the ER diagram is hard to find the relationship with each entity. -
When creating the tables in database, we have to decide which field should be the primary key.
-
When setting up the tables, we should be able to select the correct Data Type for
each field. This step makes us the most confusing. o
PostalCode: at first, we choose “Number”, and we want to limit with only 5 characters, we try to set “Field size” with 5, but with “Number” type there is
drop box with default properties, such as Byte, Single, Long Integer, … We decide to choose “Short Text” type, then set field size with 5. o
ProductNo appears in both “OrderDetails” and “Stocks” table. In “Stocks” table, it is primary key, so we think it should be “Auto Number” type. However, in “Orderdetails”, we set it “Number”. If we make relationship between these 2 tables, there will not have any connection, so we have to choose “Number” type. -
Creating validity checks (Catalog in Stocks Table - Only H or S or F are valid. Quantity in Stocks Table - Have to be >= 0). It is a little confusing to put the statement into “Validation Rule” or “Validation Text”. We figure out that in Validation Rule it formats “Only H” Or “S” Or “F are valid”, which is in quotation mark is the one we have to fill out the table. It has to be “H” Or “S” Or “F”, and “Only H or S or F are valid” in Validation Text, which will pop up when we fill out other value except H, S, and F. 2. Please give a few recommendations about what information would be useful to have (that may not have been available for the project) when building a database.
-
Each table will have at least one entity which is included in another table to create a relationship. Therefore, we should consider carefully to select the correct Data Type. -
PhoneNumber field, we can choose Data look with (***) ***-****
-
Title and Rating field, we should create list box with value “Mr., Mrs, Ms.” and “1,2,3,4,5”
These could help us more convenient when filling out the tables. 3. The database in the exercise is a fully normalized database. In certain cases, database professionals may want to employ a non-normalized database. Give two
examples of why you would want to normalize a database, and one example of why you would want to use a non-normalized database.
-
The data is organized into the database which involves creating the tables and having relationships between them with the rules designed for protecting the data. Normalization is necessary whenever designing the database. This is dependent on the algorithm which would be used for the database. Having a normalized database would reduce the extra and invalid information optimizing the performance of the data. Normalization could be avoided in machine learning
as each of the datasets does not require normalization. It also prevents any of the issues caused in the database during the modifications like deletion, insertion, and other things. When we try to run a query, normalization will give us an accurate data with matching our needs. -
Some problems are accompanied by the normalization process. As the data is real and is not duplicated, joins for the table are required. Thus, queries become complicated and hence the read times become slow. With the lack of normalization, problems like performance issues and inaccurate data could be caused. Also, redundancy could put a load on the programs and would become difficult to modify.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
A service provided delivering packages to a locker for customers to pick up at their convenience is an example of:
Question content area bottom
Part 1
A.
hybrid office.
B.
passive contact.
C.
active contact.
D.
front office.
arrow_forward
1. Appraise the handling of information in mc donals.
2. Identify key factors in matching information system to user requirements
arrow_forward
Question 4 (1 point)
As buyers are increasingly facing information overload, salespeople should ensure information is streamlined and
personalized.
OTrue
OFalse
Question 5 (1 point)
Blogs, white papers, webinars, and presentations should be proyided to targeted customers.
OTrue
OFalse
Question 6 (1 point)
dal fne avaluating solution alternatives uses weighted averages.
arrow_forward
I need typing clear urjent no chatgpt use i will give 5 upvotes
full explanation pls
arrow_forward
1. A forecaster must decide on the value of this factor before he can use the simple moving average model. *
a. Actual demand for each period
b. Averaging period
c. Exponential smoothing constant
d.Weights
2. A forecaster must decide on the value of this factor before he can use the exponential smoothing model. *
a. Actual demand for each period
b. Averaging period
c. Exponential smoothing constant
d. Weights
3. A forecaster must calculate this value to assess the accuracy of a time series forecasting model. *
a. Averaging period
b. Correlation coefficient
c. Exponential smoothing constant
d. Mean absolute deviation
arrow_forward
1. Match the phrase in Column A with the appropriate term in Column B. For each answer, onlywrite the question number and answer. E.g. a – i.
a. Database
i. spread across several smaller databases
connected via telecommunications devices.
b. Human Resource MIS
ii. travel agent booking travel for a university
c. Enterprise collaboration
systems
iii. consists of computer equipment used to
perform input, processing, and output
activities..
d. Database Administrator
iv. Cost leadership, Differentiation and
Segmentation (or Focus).
e. Executive Support
System
v. a skilled IS professional who directs all
activities related to an organization’s database
f. Generic Strategies
vi. an information system that is concerned with
activities related to employees and potential
employees of an organization
g. Distributed Database
vii. designed to handle strategic decisions.
h. Hardware
viii. enhance team and workgroup communications
and productivity, and…
arrow_forward
Required information
[The following information applies to the questions displayed below.]
The Air Force Museum Foundation has commissioned the purchase of 16 Four F Sixes, pre-World War II aircraft. They will
be built completely from scratch to the exact specifications used for the originals. As further authentication, the aircraft will
be made using the technology and manufacturing processes available when the originals were built. Each of the 16
airplanes will be flown to Air Force and aviation museums throughout the country for exhibition. Aviation enthusiasts can
also visit the production facility to see exactly how such aircraft were built in 1938.
Soren Industries wants to bid on the aircraft contract and asked for and received certain cost information about the Four F
Sixes from the Air Force. The information includes some of the old cost data from the builders of the original aircraft. The
available information is for the total accumulated time as the 1st, 8th, and 32nd…
arrow_forward
Identify the Information System that would generate the type of report shown below.
DOEJOE INC.
STATEMENT OF OWNER'S EQUITY
FOR MONTH OF AUGUST 21, 2022
JOHN DOE, CAPITAL, AUGUST 31, 2022
INVESTMENT DURING THE PERIOD
NET INCOME FOR PERIOD
SUBTOTAL
WITHDRAWLS DURING THE PERIOD
NET LOSSES FOR PERIOD
JOHN DOE, CAPITAL, AUGUST 31, 2022
O a. Management Information System
O b. Decision support system
O c. Business Intelligence Dashboard
Od. Transaction processing system
4,000.00
1,000.00
2,000.00
$ 7,000.00
2,000.00
$5,000.00
arrow_forward
This data will help you determine if you have to use the same retailer in a location. *
a. Net sales volume
b. Break-even point
c. Sales volume variance
d. Sales variance percentage
arrow_forward
Quantitative Methods
1.The minimum expected opportunity loss ____________________.
a.) is equal to the highest expected payoff.
b.) is greater than the expected value with perfect information.
c.) is equal to the expected value of perfect information.
d.) is computed when finding the minimax regret decision.
2.) A decision tree is preferable to a decision table when_________________________.
a.) a number of sequential decisions are to be made.
b.) probabilities are available.
c.) the maximax criterion is used.
d.) the objective is to maximize regret.
3.In decision theory, probabilities are associated with _____________________.
a.) payoffs.
b.) alternatives.
c.) states of nature.
d.) none of the above.
arrow_forward
Whcih of the following is NOT false
a. Service Quality and Customer Satisfaction are interchangebale terms
O b. Service Quality is one of the
input to achieving Customer
Satisfaction
Service Quality is the only input
to achieving Customer Satisfaction
O d. Service Quality and Customer satisfaction are not co related
arrow_forward
Explain about the background of information system. (With References)
arrow_forward
Plz solve
arrow_forward
I need both answers
arrow_forward
a
b
When using the Daily Business Manager, you cannot do which of the following:
a
C
b
d
с
d
Show Transcribed Text
a
b
с
Record notes (messages) to help you remember tasks to be completed.
HST is charged to a customer when:
Advance the session date for recording transactions.
List recurring invoices for the next 7 days.
Change the setting to not display this manager window.
d
Show Transcribed Text
S
The customer will be reselling the goods to another customer.
The customer will be using the goods for their own use.
When the red stick pin is clicked in a Sales Journal window, Sold to: area, it means that:
The customer has prepaid the order and will pick up the goods in 10 days.
a and b are correct.
a Graphs.
This is an invoice for a
arrow_forward
. Illustrate the drawbacks of database, if any
arrow_forward
..
arrow_forward
Which of the following modules outlines the different formats to use when collecting data manually?
A) Measurement Systems Analysis (MSA)
B) Check Sheets
C) Operational Definitions
D) Stratification
arrow_forward
4. Volume statistics is related to :
A. Tourist Motivation
B. Tourist Behavior
C. Purpose of Visit
D. Spending of the Tourist
arrow_forward
DFD of proposed solution
USER
Request Form
[Type input]
Find Lease
Document Problem
Submit Request
[Lease Store]
Common Problems Store]
[Request Store]
Phone
Camera
arrow_forward
12.30. The manager of Sarah's Ice-Cream store needs an accurate
forecast of the demand for ice-cream. The store orders ice-cream
from a distributor a week ahead, and if too little is ordered the store
loses business. If it orders too much, it must be thrown away. The
manager believes that a major determinant of ice-cream sales is
temperature; that is, the hotter it is, the more ice-cream people buy.
Using an almanac, the manager has determined the average daytime
temperature for 10 weeks selected at random and then, from store
records, has determined the ice-cream consumption for the same 10
weeks. The data are summarized as follows:
Week
Temperature
(Gallons Sold)
1
75
95
67
90
3
83
125
89
150
77
85
80
115
84
110
8
92
145
9.
89
130
10
65
100
a. Develop a linear regression model for this data and forecast
the ice-cream consumption if the average weekly daytime tem-
perature is expected to be 80.
4-
67
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Related Questions
- A service provided delivering packages to a locker for customers to pick up at their convenience is an example of: Question content area bottom Part 1 A. hybrid office. B. passive contact. C. active contact. D. front office.arrow_forward1. Appraise the handling of information in mc donals. 2. Identify key factors in matching information system to user requirementsarrow_forwardQuestion 4 (1 point) As buyers are increasingly facing information overload, salespeople should ensure information is streamlined and personalized. OTrue OFalse Question 5 (1 point) Blogs, white papers, webinars, and presentations should be proyided to targeted customers. OTrue OFalse Question 6 (1 point) dal fne avaluating solution alternatives uses weighted averages.arrow_forward
- I need typing clear urjent no chatgpt use i will give 5 upvotes full explanation plsarrow_forward1. A forecaster must decide on the value of this factor before he can use the simple moving average model. * a. Actual demand for each period b. Averaging period c. Exponential smoothing constant d.Weights 2. A forecaster must decide on the value of this factor before he can use the exponential smoothing model. * a. Actual demand for each period b. Averaging period c. Exponential smoothing constant d. Weights 3. A forecaster must calculate this value to assess the accuracy of a time series forecasting model. * a. Averaging period b. Correlation coefficient c. Exponential smoothing constant d. Mean absolute deviationarrow_forward1. Match the phrase in Column A with the appropriate term in Column B. For each answer, onlywrite the question number and answer. E.g. a – i. a. Database i. spread across several smaller databases connected via telecommunications devices. b. Human Resource MIS ii. travel agent booking travel for a university c. Enterprise collaboration systems iii. consists of computer equipment used to perform input, processing, and output activities.. d. Database Administrator iv. Cost leadership, Differentiation and Segmentation (or Focus). e. Executive Support System v. a skilled IS professional who directs all activities related to an organization’s database f. Generic Strategies vi. an information system that is concerned with activities related to employees and potential employees of an organization g. Distributed Database vii. designed to handle strategic decisions. h. Hardware viii. enhance team and workgroup communications and productivity, and…arrow_forward
- Required information [The following information applies to the questions displayed below.] The Air Force Museum Foundation has commissioned the purchase of 16 Four F Sixes, pre-World War II aircraft. They will be built completely from scratch to the exact specifications used for the originals. As further authentication, the aircraft will be made using the technology and manufacturing processes available when the originals were built. Each of the 16 airplanes will be flown to Air Force and aviation museums throughout the country for exhibition. Aviation enthusiasts can also visit the production facility to see exactly how such aircraft were built in 1938. Soren Industries wants to bid on the aircraft contract and asked for and received certain cost information about the Four F Sixes from the Air Force. The information includes some of the old cost data from the builders of the original aircraft. The available information is for the total accumulated time as the 1st, 8th, and 32nd…arrow_forwardIdentify the Information System that would generate the type of report shown below. DOEJOE INC. STATEMENT OF OWNER'S EQUITY FOR MONTH OF AUGUST 21, 2022 JOHN DOE, CAPITAL, AUGUST 31, 2022 INVESTMENT DURING THE PERIOD NET INCOME FOR PERIOD SUBTOTAL WITHDRAWLS DURING THE PERIOD NET LOSSES FOR PERIOD JOHN DOE, CAPITAL, AUGUST 31, 2022 O a. Management Information System O b. Decision support system O c. Business Intelligence Dashboard Od. Transaction processing system 4,000.00 1,000.00 2,000.00 $ 7,000.00 2,000.00 $5,000.00arrow_forwardThis data will help you determine if you have to use the same retailer in a location. * a. Net sales volume b. Break-even point c. Sales volume variance d. Sales variance percentagearrow_forward
- Quantitative Methods 1.The minimum expected opportunity loss ____________________. a.) is equal to the highest expected payoff. b.) is greater than the expected value with perfect information. c.) is equal to the expected value of perfect information. d.) is computed when finding the minimax regret decision. 2.) A decision tree is preferable to a decision table when_________________________. a.) a number of sequential decisions are to be made. b.) probabilities are available. c.) the maximax criterion is used. d.) the objective is to maximize regret. 3.In decision theory, probabilities are associated with _____________________. a.) payoffs. b.) alternatives. c.) states of nature. d.) none of the above.arrow_forwardWhcih of the following is NOT false a. Service Quality and Customer Satisfaction are interchangebale terms O b. Service Quality is one of the input to achieving Customer Satisfaction Service Quality is the only input to achieving Customer Satisfaction O d. Service Quality and Customer satisfaction are not co relatedarrow_forwardExplain about the background of information system. (With References)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- BUSN 11 Introduction to Business Student EditionBusinessISBN:9781337407137Author:KellyPublisher:Cengage LearningEssentials of Business Communication (MindTap Cou...BusinessISBN:9781337386494Author:Mary Ellen Guffey, Dana LoewyPublisher:Cengage LearningAccounting Information Systems (14th Edition)BusinessISBN:9780134474021Author:Marshall B. Romney, Paul J. SteinbartPublisher:PEARSON
- International Business: Competing in the Global M...BusinessISBN:9781259929441Author:Charles W. L. Hill Dr, G. Tomas M. HultPublisher:McGraw-Hill Education
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education