Task 1
The database for Pulse Learning is modelled in Figure 1. The diagram is based on the information provided by Pulse Learning.
Task 2
The relational model of X database is modelled below. The model is derived from the use case and the ERD in Figure Deriving Entity types
RELATION (attribute, attribute, attribute)
RELATION (attribute, attribute, attribute)
Deriving Relationship types
RELATIONSHIP NAME was derived by adding RELATION with attribute and attribute as foreign keys to link with RELATION and RELATION because of MULTIPLICITY and/or PARENT/CHILD
RELATIONSHIP NAME was derived by merging RELATION and RELATION because of MULTIPLICITY and/or PARENT/CHILD
RELATIONSHIP NAME was derived by adding attribute to RELATION as a foreign key to link with RELATION because of MULTIPLICITY and/or PARENT/CHILD
Relational Model
RELATION (attribute, attribute, attribute)
RELATION (attribute, attribute, attribute)
RELATION (attribute, attribute, attribute)
RELATION (attribute, attribute, attribute)
RELATION (attribute, attribute, attribute)
Foreign Keys
· Relation (attribute) is dependent on Relation (attribute).
· Relation (attribute) is dependent on Relation (attribute).
Other Constraints
· The X attribute of the Y relation can only be from 1000 to 9999.
Task 3
|
Relation |
||||
|
Attribute |
Attribute |
Attribute |
Attribute |
Attribute |
|
value |
value |
Value |
Value |
Value |
|
Value |
Value |
Value |
value |
Value |
|
Value |
Value |
value |
Value |
Value |
|
value |
Value |
value |
value |
value |
…
· A delete operation that would run successfully
Delete the row:
|
value |
Value |
value |
value |
value |
From Relation
· An update operation that would run successfully
Update the row:
|
value |
Value |
value |
value |
value |
From Relation to
|
value |
Value |
value |
value |
value |
· An update operation that would not run successfully
Update the row:
|
value |
Value |
value |
value |
value |
From Relation to
|
value |
Value |
value |
value |
value |
· An insert operation that would not run successfully
Insert the row:
|
value |
Value |
value |
value |
value |
Into Relation
…
Task 4
Student is xNF because it respects A and B but there is Z which prevents it from being (x+1)NF
Tutor is xNF because it respects C and D but there is W which prevents it from being (x+1)NF
Coordinator is xNF because it respects E and F but there is Y which prevents it from being (x+1)NF
代写CS&Finance|建模|代码|系统|报告|考试
编程类：C++,JAVA ,数据库,WEB,Linux,Nodejs,JSP,Html,Prolog,Python,Haskell,hadoop算法,系统 机器学习
金融类：统计，计量，风险投资，金融工程，R语言，Python语言，Matlab，建立模型，数据分析，数据处理
服务类：Lab/Assignment/Project/Course/Qzui/Midterm/Final/Exam/Test帮助代写代考辅导
E-mail:850190831@qq.com 微信：BadGeniuscs 工作时间：无休息工作日-早上8点到凌晨3点
如果您用的手机请先保存二维码到手机里面，识别图中二维码。如果用电脑，直接掏出手机果断扫描。
