You are registering for a technology conference which includes the following:
Registering for the conference
Registering for specific sessions
Booking airline travel
Booking a car rental
Making reservations at a restaurant
Think about some of the pieces, are they just data? Or are they put into a meaningful context? Are they something that are known?
Listed, are some of the things that you may do when you register/travel for a conference. Think about what the different things are. Select either data, information or knowledge.
1. Data of the conference
2. Confirmation of conference registration
3. List of specific sessions
4. Upcoming technology conferences
5. Confirmation of registered sessions
6. Limit of airline schedules
7. Upcoming airline specials
8. Completed airline reservations
9. Completed car rental reservation
10. List of deals at specific restaurants
11. List of restaurants in the area
12. List of different rental cars
13. Confirmation of rental car
Hide Feedback
Correct
Your company is confused and needs your technical assistance. They have given you different scenarios and want to know if they should use a spreadsheet or a DBMS (Database Management System).
Think about the reasons for using a spreadsheet versus using a DBMS
When would a DBMS be a better solution?
Analyze each situation and select either DBMS or a Spreadsheet.
1. Statistical comparisons
2. Complex search queries
3. Summary reports
4. Calculations
5. Mortgage calculations
6. Managing data
7. Inventory control
8. Security control of data
9. Storing a small amount of data
10. Calculating grades in a class
Hide Feedback
Correct
Your company is concerned there is a problem with the data in one of the database tables. They want you to look at the data and determine if there is a problem. They have stressed it is important to have correct data as it is used for making decisions, and as a basis for reports for various departments.
Examine the data in the table and identify column(s) that contain data consistencies or inconsistences. Select the dropdown that is appropriate for each column.
STUDENT_ID
STUDENT_NAME
ADDRESS
CITY
STATE
PHONE
02134
Melissa, Tandy
145 Mountain Hall
Lake Tahoe
NV
775.321.7879
035678
Cindy Lou, Hardie
324 Flower Hall
Virginia City
775.345.3210
45678
Clayton ,Harvey
145 Mountain Hall
Nevada
398.4560
27869
William, Zander
14 Bighorn Lane
Reno
775.345.7539
1. STUDENT_ID
2. STUDENT_NAME
3. ADDRESS
4. CITY
5. STATE
6. PHONE
Your company is concerned there is a problem with the design of some of the database tables. They want you to look at the tables and determine if there is a problem. Management is concerned about data anomalies and data redundancies. They have stressed it is important to have correct design as it is used for making decisions and used as a basis for reports in the various departments.
Examine the fields in each table and determine if the table is designed correctly or incorrectly. Select the dropdown that is appropriate for each table.
Student
STUDENT_ID
STUDENT_NAME
ADVISOR
ADVISOR_OFFICE
DORM
DORM_ADDRESS
021345
Melissa, Tandy
Snow
145 Mountain Hall
Peaceful Hall
123 Peace Ln.
035678
Cindy Lou, Hardie
Mary
324 Flower Hall
Tulip Hall
789 Tulip Ln.
45678
Clayton ,Harvey
Snow
145 Mountain Hall
Bee Hall
45 Bee Ln.
27869
William, Zander
Harvey
145 Mountain Hall
Peaceful Hall
123 Peace Ln.
Advisor
ADVISOR_ID
ADVISOR_FNAME
ADVISOR_LNAME
ADVISOR_OFFICE
ADVISOR_PHONE
ADVISOR_EMAIL
1023
Melissa
Snow
145 Mountain Hall
775.345.9045
msnow@gmail.com
3698
Cindy Lou
Harris
324 Flower Hall
775.345.7482
charr@gmail.com
7892
Clayton
Harvey
365 Sandy Hall
775.345.7350
charv@gmail.com
1359
William
Bonahan
145 Mountain Hall
775.345.8945
wbona@gmail.com
Dorm
DORM_ID
STUDENT_FNAME
STUDENT_LNAME
DORM
DORM_ADDRESS
001
Jigisha
Patel
Peaceful Hall
123 Peace Ln.
002
Jose
Moreno
Tulip Hall
789 Tulip Ln.
003
Briana
McDogual
Bee Hall
45 Bee Ln.
Cindy
Chui
Peaceful Hall
123 Peace Ln.
1. Student
2. Advisor
3. Dorm
Hide Feedback
Correct
Management is concerned about data redundancies in a table. There is some data in the table that is redundant and you are questioning what happens if the data is changed. Assume that this is the only table, and all the data is required when a new record is entered. There is only one advisor per major.
What happens if the data is redundant and the data is updated, deleted or a new record is added?
Think about the following:
What data needs to be changed if you change majors? Think about what attributes are associated with a major.
What data needs to be added if an advisor is deleted?
What happens if you delete a student record and it is only one with a specific advisor? What do you need to do to preserve all the advisor data?
Review the specific actions that can occur. What if any changes need to be made to the data in other field(s). Think about redundancy and what happens if all the data is not updated.
Carlos has just created a new subnet for the finance department. He needs to be able to allow the employees in finance to retrieve files from the sales server, which is located in another subnet. Which of the following OSI model layers would it be necessary to categorize the device into? a. Layer 4 b. Layer 6 c. Layer 2 d. Layer 3 All of the cubicles in a company's office have cables that run up to the ceiling and across to an IDF. Inside the IDF, they connect directly to the latest generation switch available from the networking equipment vendor that they have chosen. Which of the following describes the physical topology most likely in use? a. mesh
Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A) True 2. Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A) Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A) Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in the project? A) Alerting Governance board if 10 percent over schedule 5. Of the following options, which stand
WEEK- 2 code install.packages("dplyr") library(dplyr) Rajeshdf = read.csv('c:\\Insurance.csv') str(Rajeshdf) str(Rajeshdf) summary(Rajeshdf) agg_tbl <- Rajeshdf %>% group_by(Rajeshdf$JOB) %>% summarise(total_count=n(), .groups = 'drop') agg_tbl a = aggregate( x=Rajeshdf$HOME_VAL, by=list( Rajeshdf$CAR_TYPE), FUN=median, na.rm=TRUE ) a QUIZ 2. What famous literary detective solved a crime because a dog did not bark at the criminal? A). Sherlock Holmes 1. In the Insurance data set, how many Lawyers are there? A). 1031 3. What two prefixes does the instructor use for variables when fixing the missing values? Select all that apply. A). IMP_ M_ 4. What is the median Home Value of a person who drives a Van? A). 204139 5. In the insurance data set, how many missing (NA) values does the variable AGE have? A) 7 1. What is the process called where missing data is fixed? a). Imputing 2. According to the instructor
Comments
Post a Comment