Exercise in the textbook: 1. 2.7 in page 61 (20 points) 2. 2.14 in page 63 (20 points) 3. 2.15 in...

Question

Exercise in the textbook: 1. 2.7 in page XXXXXXXXXXpoints) XXXXXXXXXXin page XXXXXXXXXXpoints) XXXXXXXXXXin page XXXXXXXXXXpoints) Practice with real dataset 4. Write SQL commands to create...

1 answer below »

Exercise in the textbook:

1. 2.7 in page 61 (20 points)

2. 2.14 in page 63 (20 points)

3. 2.15 in page 63 (20 points)

Practice with real dataset

4. Write SQL commands to create tables for Yelp data: (20 points)

- Get Yelp dataset at: https://www.yelp.com/dataset_challenge

- Take a look at the JSON files: business.json, checkin.json, review.json, tip.json, user.json

- Design relation schemas for the data

- Write SQL commands to create tables

5. Import the sample dataset into MySQL on any database server you can access (20 points)

- Go to the link: https://dev.mysql.com/doc/employee/en/

- Follow the instructions and import the Employees Sample Database into MySQL on the database server.

- Capture any screen that shows the tables and how many data are imported.

Submission:

You have to submit the followings to D2L:

MS word file

- Solutions for Q.1, 2, and 3

- SQL commands for Q.4

- Captured screen for Q.5

Exercise in the textbook: Abraham Silberschatz, Henry Korth and S. Sudarshan, Database System Concepts McGraw-Hill Science/Engineering/Math ; 7/e , ISBN 9780078022159, 2019 Online Material 1. 2.7 in page 61 2. 2.14 in page 63 3. 2.15 in page 63 Practice with real dataset 4. Write SQL commands to create tables for Yelp data: - Get Yelp dataset at: https://www.yelp.com/dataset_challenge - Take a look at the JSON files: business.json, checkin.json, review.json, tip.json, user.json - Design relation schemas for the data - Write SQL commands to create tables 5. Import the sample dataset into MySQL on any database server you can access (20 points) - Go to the link: https://dev.mysql.com/doc/employee/en/ - Follow the instructions and import the Employees Sample Database into MySQL on the database server. - Capture any screen that shows the tables and how many data are imported.

hw1-hgz4jdfl.docx

Answered Same DayAug 31, 2021

Neha · Accepted Answer

43906-2-jsr25pno/43906/43906.docx
Student Name:
Student Id:
2.Bank Database
a. Name of each branch located in “Chicago ”
     Π branch_name (σ branch_city = “Chicago” (branch))
 b. Id of each borrower who has a loan in branch “Downtown” 
      Π ID (σ branch_name = “Downtown” (borrower ⋈ loan))
3. Employee Database
a) Id and name of each employee who works in “BigBank”
    Π ID,person_name (σcompany-name = “BigBank” (works))
b) Id , name and city of employee who works for BigBank
     Π ID,person-name, city (employee ⋈  (σcompany-name =           “BigBank” (works))
c) Id, name, city and address of employee who works for BigBank and earns more than 10000.  
   Π ID, person-name, street, city (σ(company-name = “BigBank” ∧ salary > 10000) works ⋈  employee)
d)  Id and name of employee who lives in same city as company for which he/she works.
    Πperson-name (employee ⋈ works ⋈ company)
4 Bank Database
a) Each loan number with amount greater than 10000
        Π loan_number (δamount > 10000 (loan))
b) Id of each depositor who has account with balance greater than 6000
        Πcustomer_name (δbalance > 6000 (depositor ⋈ account ))
c) Id of each depositor who has account with balance greater than 6000 at the uptown.

Exercise in the textbook: 1. 2.7 in page XXXXXXXXXXpoints) XXXXXXXXXXin page XXXXXXXXXXpoints) XXXXXXXXXXin page XXXXXXXXXXpoints) Practice with real dataset 4. Write SQL commands to create...

Answer To: Exercise in the textbook: 1. 2.7 in page XXXXXXXXXXpoints) XXXXXXXXXXin page XXXXXXXXXXpoints) ...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment