数据库代写 | COMP 3005 Assignment #3

本次数据库代写是概念解释与查询语句

COMP 3005
Assignment #3
Due: October 18
Instruction
1. You should do the assignments independently. Copying is not allowed.
2. Submit your assignment as a single word/PDF document on culearn.
Part 1 Concepts (20 marks)
Explain the following terms as complete as possible. Simply give full name is not acceptable. Each question is 2
marks.
1. Mini World
2. Data Model
3. Database System
4. Domain
5. Relational Model
6. Attribute
7. Relation
8. Primary Key
9. Logical Data Independence
10.SQL
Part 2 Queries (70 marks)
Given the Person-Hobby database shown below. Use Domain Relational Calculus (DRC) to expression the
following queries. Submit your query expressions. Each query is 5 marks. You should use one DRC query when
possible and use more than one in this case will not get any mark.
1. Get the names of hobbies that “lastname” plays.
Person
P# Name Age
P1 Smith 20
P2 Jones 30
P3 Blake 25
P4 Lastname 20
P5 Adams 30
Hobby
H# Name
H1 Bowling
H2 Chess
H3 Dancing
H4 Hiking
H5 Skating
H6 Ski
Play
P# H# Times
P1 H1 3
P1 H2 2
P1 H3 4
P1 H4 2
P1 H5 1
P1 H6 1
P2 H1 3
P2 H2 4
P2 H3 5
P2 H4 2
P3 H2 2
P3 H3 3
P4 H2 3
P4 H3 4
2. Get the names of persons who play Bowling.
3. Get the names of persons who play a hobby more than 3 times.
4. Get the names of persons who play either chess or dancing.
5. Get the names of persons who play both chess and dancing.
6. Get the person name/hobby name pairs such that the indicated person plays the indicated hobby.
7. Get the names of persons who do not play Ski.
8. Get the names of persons who do not play any hobby.
9. Get the names of persons who play all hobbies.
10. Get the names of persons who play all hobbies that “lastname” plays.
11. Get the names of persons who play only all the hobbies that “lastname” plays.
12. Get the names of persons who play all hobbies except Skating and Ski.
13. Get the names of persons who play hobbies, the number of hobbies and total number of times they play
those hobbies.
14. Get the names of persons who play hobbies but play the least number of hobbies.


程序代写代做C/C++/JAVA/安卓/PYTHON/留学生/PHP/APP开发/MATLAB


本网站支持淘宝 支付宝 微信支付  paypal等等交易。如果不放心可以用淘宝交易!

E-mail: [email protected]  微信:dmxyzl003


如果您使用手机请先保存二维码,微信识别。如果用电脑,直接掏出手机果断扫描。

发表评论