首页
网站开发
桌面应用
管理软件
微信开发
App开发
嵌入式软件
工具软件
数据采集与分析
其他
首页
>
> 详细
COMP9311代做、Java/c++程序代写
项目预算:
开发周期:
发布时间:
要求地区:
COMP9311 23T3: Assignment 1
Deadline: Fri 16:59:59 6th October (Sydney Time)
Question 1 (8 marks)
An organizer commissioned us to design a database for an inventory
management system. They provide a summary of requirements as below.
• A supplier is identified by his/her id. We also record his/her name, phone
number and supplier type. A supplier may have several supplier types.
• A product is identified by its id. We also record its name, price, production
date and availability. A supplier must provide one or many products. Each
product must be provided by one supplier.
• A manager is identified by his/her id. We also record his/her name, phone
number, working hours and job description. Each manager is hired by one
supplier. A supplier may hire zero or many managers.
• A manager can oversee zero or many products. Each product can be
overseen by zero or many managers.
• An order is identified by its id. We also record its order date, status and
price. We are interested in the number of products in each order as well.
• An order must involve one or many products. Each product is involved in
at most one order.
• Each shipping is identified by its id. We also record the shipping address,
shipping company and status. The shipping address is composed of street
number, street name, city and country.
• An order can have at most one shipping and each shipping must
correspond to an order.
• Each order is associated with zero or many invoices. An invoice is
identified by a combination of the invoice id and the order id. It must exist
along with the order. We also record its date, billing address, payment
method and tax information.
Your task: draw an ER diagram to represent the scenario, clearly state any
reasonable assumptions that you choose to make. Reasonable relation
names are acceptable. Please keep to the notations taught in the lecture.
Question 2 (6 marks)
Your task: convert the above ER-diagram into a relational data model, and please
only keep to the notations/model taught in the lecture.
Question 3 (10 marks)
Consider the following schema for a movie database:
Player (pID, pName, nationality)
Game (gID, gName, price, platform)
Genre (gID, genre)
Play (pID, gID, duration)
Your task: write the relational algebra expressions for the following queries:
1) Find the names of the games that are in the role-playing genre and have
prices lower than $200. (2 marks)
2) Find the names of the players who have played more than 5 games
where duration of each is more than 3 hours. Only consider the games
that are on the Windows Platform. (2 marks)
3) Find the names of the games that are in both Adventure and Action
genres at the same time and have been played by German players. (3
marks)
4) Find the names of the Italian players who have only played games that
are on the PSP platform and have never played any game that are in the
Fighting genre. (3 marks)
Note: Attributes that are not part of the primary key are not unique. Please keep
to the operators/notations taught in the lecture.
Assignment Submission
• You must submit an electronic copy of their answers to the above
questions to the course website in Moodle. You can handwrite your
answers and scan or take a photo. Make sure they are legible.
• We only accept .doc or .pdf files.
• Please name your files in the following format: ass1_studentID.doc or
ass1_studentID.pdf (e.g., ass1_z5100000.doc or ass1_z5100000.pdf).
Note:
1. If you have problems relating to your submission, please write to the
course email at junhua.zhang@unsw.edu.au or yiheng.hu@unsw.edu.au.
If there are issues with Moodle, send your assignment to the above email
with the title “
COMP9311 Ass1 Submission”.
2. All submissions will be checked for plagiarism. The university regards
plagiarism as a form of academic misconduct and has very strict rules. Not
knowing the rules will not be considered a valid excuse when you are
caught.
a. For UNSW policies, penalties, and information to help avoid plagiarism,
please see: https://student.unsw.edu.au/plagiarism.
b. For guidelines in the online ELISE tutorials for all new UNSW students:
https://subjectguides.library.unsw.edu.au/elise/plagiarism.
Late Submission Penalty
• 5% of the max assessment mark will be deducted for each day late (1
second late is considered as one day late), up to 5 days (5*24 hours).
• Submissions that are more than five days late will not be marked.
软件开发、广告设计客服
QQ:99515681
邮箱:99515681@qq.com
工作时间:8:00-23:00
微信:codinghelp
热点项目
更多
data程序代写、代做c/c++编程语...
2024-05-17
data程序代写、代做python编程...
2024-05-17
program代做、c/c++,python程...
2024-05-17
代写math 3333 3.0 - winter 2...
2024-05-17
代做seng6110 programming ass...
2024-05-17
代写seng6110 object oriented...
2024-05-17
代写comp828: statistical pro...
2024-05-17
代做culture and society调试数...
2024-05-17
代做comp 4911 winter 2024 as...
2024-05-17
代做lh physical iiib / 03 33...
2024-05-17
代做3032ict big data analyti...
2024-05-17
代写comp4702 report代写留学生...
2024-05-17
代写fin2020 hw6代写c/c++编程
2024-05-17
热点标签
fit2004
fit3152
mec208
econ20120
cpt304
econ2101
econ0051
engi4547
econ1048
eengm2510
fit1008
7033mkt
ec2066
cct380h5f
man00019m
mech265001
fin2020
fit9137
n1542
csc4140
math6119
comp1710
fina864
csys5020
busi4412
math5007
2702ict
dts204tc
comp2003j
cosc2673
ecmt2150
bff3121–
comu7000
stat6118
comp814
acc202
ematm0067
bit233
ecs776p
600543
bpln0025
comp3400
econ7030
159.342 ‐ operating
mang6134
math1005/math6005
geog5404m
comp1710/6780
infs 2042
inf6028
bman30702
math0002
msci242l
mgt11001
com00177m
bman71282
fit2001
cpt210
159.341
econ7310
comp3221
comp10002
cpt206
ecmt1010
finm081
econ2005
cpt202
fit3094
socs0030
data7201
data2x01
mn-3507
mat246h1
ib2d90
ib3j80
acc207
comp90007
compx518-24a
fit1050
info1111
acct2201
buad801
compsci369
cse 332s
info1110
math1033
scie1000
eeee2057
math4063
cmt219
econ5074
eng5009
csse2310/csse7231
ec333
econ0001
cpt204
elec4630
ma117
dts104tc
comp2017
640481
csit128
eco000109m
finc5090
ggr202h5f
nbs8295
4ssmn902
chc6171
dsa1002
ebu6304
comp1021
csci-ua.202
com6511
ma416
mec206
iom209
bism7202
idepg001
cpt106
comp1212
ecom209
math1062
mn-3526
fnce3000
fmhu5002
psyc10003
fina2222
be631-6-sp/1
finc2011
37989
5aaob204
citx1401
econ0028
bsan3204
comp9123
cmt218
itp122
qbus6820
ecmt1020
bus0117
soft3202/comp9202
basc0057
mecm30013
aem4060
acb1120
comp2123
econ2151
ecmt6006
inmr77
com 5140
ocmp5328
comp1039
had7002h
cmt309
asb-3715
elec373
cpt204-2324
be631-6-sp
econ3016
mast10007
buss6002
comp4403
comp30023
finm1416
csc-30002
6qqmn971
fin668
mnfg309
inft2031
cits1402
comp2011
eecs 3221
ebu4201
ct60a9600
com336
8pro102
econ7300
comp3425
comp8410
comp222
finm8007
comp2006
comp26020
comp1721
eeen3007j
cis432
csci251
comp5125m
com398sust
finm7405
econ7021
fin600
infs4205/7205
mktg2510-
32022
mth6158
comp328
finn41615
2024
mec302
联系我们
- QQ: 9951568
© 2021
www.rj363.com
软件定制开发网!