Homework 1, Part 1
Introduction to Core Concepts, ER Modeling, Relational Algebra, SQL
Introduction and Overview
●HW 1 will have two parts. This is the first part.
●Part 1 tests and reinforces the basic elements of:
Relational model and relational algebra.
●Part 2 will have a set of practical exercises that have students implement simple but realistic tasks.
●Part 1 applies to both programming and non-programming tracks. .
Complete all the tests in this notebook and submit only this notebook as a PDF to GradeScope. To convert the jupyter notebook into a pdf you can use either of the followving methods:
●File –> Print Preview –> Print -> Save to PDF
●File –> Download As HTML –> Print -> Save to PDF
Due date: February 12, 11:59 PM EDT on GradeScope
It is recommended that you put the screenshots into the same folder as this notebook so you do not have to alter the path to include your images.
Please read all the instructions thoroughly!
You may not work with or collaborate with anyone in any way to complete the homework. You may speak with the professor and TAs. You may ask private questions on Ed if you need clarification.
You may use lecture slides, the textbook slides, the textbook or public information on the web to help you answer your questions. You may not “cut and past” information. Your answer must be in your own words and demonstrate the you understand the concept. If you use information for sources other than lectures,lecture slides, textbook slides or the textbook, you MUST provide a URL to the source you used.
Read the Columbia University academic integrity. information. (ttps://www.cc seas.columbia.edu/inegrity.). In the answer section, state that you take the pledge.
Add Student Information
1. Replace my name with your full name.
2. Replace my UNI with your UNI.
3. Replace “Cool Track” with either “Programming” or “Non-programming.”
S1: This is a sample of the format for answering the relational algebra questions. Your answer will contain:
1. A markdown cell with the relational algebra statement.
2. A screen capture of the execution.
You will use the RelaX calculator (tts:/bis-uibk.github.io/relax/calc/gist/47866c17624ca9dfa85ed2482078be8/relax- siberschatz english.txt/0). with the schema associated with the book.
Write a relational algebra statement that produces a relation with the columns:
And only contains tuples from the Spring semester and a classroom. capacity > 50.
o semester=’ Spring’人capacity>50
(π course_ id, sec_ id， semester, year, building, room_ number， capacity
R2: Write a relational algebra expression that returns a relation of the form:
The relation contains courses that earn at least 4 credits.
本网站支持淘宝 支付宝 微信支付 paypal等等交易。如果不放心可以用淘宝交易！
E-mail: email@example.com 微信:itcsdx