subject

For the following questions, assume the following database schema: Users (UserID INTEGER, Name CHAR(30), Age INTEGER, ReviewCount INTEGER) Businesses (BusinessID INTEGER, BName CHAR(30), City CHAR(20), State CHAR(2)) Checkins (BusinessID INTEGER, Weekdays INTEGER, Weekends INTEGER) Reviews (ReviewID INTEGER, UserID INTEGER, BusinessID INTEGER, Stars REAL) Reviews (UserID) is a foreign key referring to Users (UserID). Reviews (BusinessID) is a foreign key referring to Businesses (BusinessID). Checkins (BusinessID) is a foreign key referring to Businesses (BusinessID).A page is 8 kB in size (1kB = 1024B). The RDBMS buffer pool has 10,000 pages, all of which are available. Initially, the buffer pool is empty. The relation instances have the following statistics. Assume there are no NULL values. Each integer or real is 8B, and each character is 1B (so as an example CHAR(20) is 20B).Relation Number of PagesUsers 75,000Businesses 42,000Checkins 20,000Reviews 500,000

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 18:00
Suppose an astronomer discovers a large, spherical-shaped body orbiting the sun. the body is composed mostly of rock, and there are no other bodies sharing its orbit. what is the best way to categorize this body? a. planet b. moon c. comet d. asteroid
Answers: 1
question
Computers and Technology, 23.06.2019 17:00
Companies that implement and apply an information system effectively can create
Answers: 1
question
Computers and Technology, 24.06.2019 07:30
Aproject involves many computing systems working together on disjointed task towards a single goal what form of computing would the project be using
Answers: 3
question
Computers and Technology, 24.06.2019 13:00
Which one of the following functions is not available on the autosum tool? sum average if max
Answers: 3
You know the right answer?
For the following questions, assume the following database schema: Users (UserID INTEGER, Name CHAR(...
Questions
question
Mathematics, 20.07.2019 05:00
question
Social Studies, 20.07.2019 05:00
Questions on the website: 13722360