当前位置:天才代写 > 数据库代写,Database代写SQL代做-cs大神助你起飞 > Database代写留学生CS专业数据库的作业Task1.2.3.4

Database代写留学生CS专业数据库的作业Task1.2.3.4

2018-03-29 08:00 星期四 所属: 数据库代写,Database代写SQL代做-cs大神助你起飞 浏览:847

Task 1

The database for Pulse Learning is modelled in Figure 1. The diagram is based on the information provided by Pulse Learning.

 

image.png

 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点


如果您用的手机请先保存二维码到手机里面,识别图中二维码。如果用电脑,直接掏出手机果断扫描。

qr.png

 

    关键字:

天才代写-代写联系方式