1.1 What is data mining? In your answer, address the following:(a) Is it another hype?(b) Is it a simple transformation or application of technology developed from databases,statistics, machine learning, and pattern recognition?(c) We have presented a view that data mining is the result of the evolution of databasetechnology. Do you think that data mining is also the result of the evolution of machinelearning research? Can you present such views based on the historical progress of thisdiscipline? Address the same for the fields of statistics and pattern recognition.(d) Describe the steps involved in data mining when viewed as a process ofknowledgediscovery.

Data mining refers to the process or method that extracts or “mines” interesting knowledge or…

Answered: What is data mining? In your answer,…

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Big Data

Section: Chapter Questions

Problem 4PSE

See similar textbooks

Similar questions

Can you please answer these two questions:question 8 : In a DDB environment, the term used for the ability to easily expand the number of nodes in database is called:A) node replication B) expandability C) Horizontal scalability D) vertical scalability E) ease of usequestion 9: In a DDB environment, the term used for the ability to expand the capacity of an individual node in the database is called...A) Oreferred growth B) Expandability C) node transparency D) horizontal scalability E) vertical scalability
Consider the following business rule:An employee can manage multiple customers. A customer can be managed by multiple employees. How does this business rule(s) affect the database design? a.) The business rules define that there isn't a need for a relationship between the EMPLOYEE and CUSTOMER entities, as the relationship isn't a strong one. b.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:M relationship between those two entities. c.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and an M:N relationship between those two entities requiring a bridge table. d.) The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:1 relationship between those two entities.
111. Subschema can be used to a. create very different, personalized views of the same data b. present information in different formats c. hide sensitive information by omitting fields from the sub-schema's description d. All of the above
Consider the following proposition: The greatest threat to individual privacy in modern times is database management systems and data warehousing techniques. What, in your opinion, are the problems with the federal government's data aggregation and collection?
When should distributed database systems make advantage of data replication against data fragmentation? Are replication and fragmentation mutually exclusive processes? What's the difference between fragmentation that happens horizontally and fragmentation that happens vertically? Could you kindly clarify your stance via the use of an example?
25)What does schema-on-write mode mean? • the schema is defined during the write process • during the write process, data does not need to conform to any schema • during the write process, data must conform to a pre-defined schema definition • the schema can be changed during the write process (26) Question 26 12 points) Which one of the V's of big data refers to the different forms of data that are generated? • velocity • variety • value • veracity
Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment: • Thedatabasekeepstrackofthehistoryofalltheteams that each player has played on and all the players who have played on each team. • The database only keeps track of the current team that a coach works for. • Team number, team name, and player number are each unique attribute across the league. • Coach name is unique only within a team (and we assume that a team cannot have two coaches of the same name). • Serial number (for bats) is unique only within a team. • In the Affiliation table, the Years attribute indicates the number of years that a player played on a team; the batting average is for the years that a player played on a team. Write SQL SELECT commands to answer the following…
Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment: • Thedatabasekeepstrackofthehistoryofalltheteams that each player has played on and all the players who have played on each team. • The database only keeps track of the current team that a coach works for. • Team number, team name, and player number are each unique attribute across the league. • Coach name is unique only within a team (and we assume that a team cannot have two coaches of the same name). • Serial number (for bats) is unique only within a team. • In the Affiliation table, the Years attribute indicates the number of years that a player played on a team; the batting average is for the years that a player played on a team. Write SQL SELECT commands to answer the following…
5.15. Consider the following relations for a database that keeps track of business trips of salespersons in a sales office: SALESPERSON(Ssn, Name, Start_year, Dept_no) TRIP(Ssn, From_city, To_city, Departure_date, Return_date, Trip_id) EXPENSE(Trip_id, Account#, Amount). A trip can be charged to one or more accounts. Specify the foreign keys for this schema, stating any assumptions you make. Textbook is fundamentals of database systems, by elmasri and navathe, 7th edition Give me unique correct answers not AI generated anwsers or solutions from text book
Defineanomaly? What are the chances of finding three abnormalities in a database? Discuss the issues and propose a way to deal with the anomalies that arise as a result.
Describe how the following informationabout railways, trains (for a particular day), and passengers would berepresented in a relational database:Trains: Rolar, Omni, and HolidayTrains for Rolar: R221, R567, and R234Holiday special Trains: H897 and H008Trains for Omni: O999 and O815John has reservations on R221 (seat 34U),R567 (seat 23U), and R234 (seat 43L).Henry has reservations on O999 (seat 15L) andH008 (seat 18L).Duke has reservations on H897 (seat 7U) andO815 (seat 2L).
Consider a “Digital Games” database with the following relations and attributes: Gamer: (UserID, Name, Age, Address, City, Favorite-Game, Rank) Game: (GameID, Name, Company, Release-Year, Version) Store: (StoreID, Name, Address, City) WhereToFind: (GameID, StoreID, Price) Category: (GameID, Category-Name) From the relational schemas illustrated above, use the different relational algebra operators and operations (ρ, σ, π, ⋂, ⋃, -, ⨝) discussed in class to build the following queries:1. List -by name and ID- each gamer who lives in the city of Chicago, with a rank of 5, and is aged between 15 (included) and 30 (included).2. List games -by name and release year- that are not in the “Action” category3. Since each game can fall within several categories, list games -by name and release year- that are in the “Action” category and also in the “Role-Playing” category4.…

SEE MORE QUESTIONS

Recommended textbooks for you

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS