# INFO1003

Data Modelling Exercises

1. Data Modelling Concept Questions
1. What are the possible constraints in (a) participation (b) cardinality, and how are they represented? 2. What is the difference between a primary key, a foreign key and a composite key 3. From the combination of participation and cardinality, what are some of the representation types? 4. From the perspective of the Project entity, what is the participation and constraint as it relates to the Employees entity? How would you read this ERD altogether?

2. Data Modelling Practical Exercise
Exercise 1: Domain (~10 min)
(a) Set up the database for the Domain real estate company by first constructing an ERD. There exists an entity called PROPERTY, representing the property for sale by the agency. Each time a potential buyer makes a purchase offer on a property, the agency records the offering price, and the name of the person making the offer. Represent the PROPERTY entity and its attributes using multi-valued attributes. You must also create a primary key for every entity (even though the question may not tell you want the primary key is – always try to do this when creating ERDs). (b) Assume the agency now decides to also keep data about buyers and potential buyers, including their name, phone number and address. Augment your answer to accommodate this change.

Exercise 2: SMH (~10 min)
You are required to update Sydney Morning Herald’s database in order to keep track of their reporters and the stories they investigate. The attributes of REPORTER include: name; address; and birthday. SMH of course has numerous stories they pursue. Attributes of STORY include StoryName, and StartDate. Each reporter maybe be assigned to one or more stories, or, may not be assigned a story at all. A story must have at least one reporter assigned to it and may have any number of reporters assigned to it. A reporter’s billing rate varies by story (and consequently, which page of the newspaper it lands on). SMH has requested to be able to record the applicable billing rate (BillingRate) for each reporter when assigned to a particular story. Develop the ERD for the SMH database.

INFO1003 | FOUNDATIONS OF INFORMATION TECHNOLOGY

1

Data Modelling Exercises

Exercise 3 – Sydney Uni (~15 min)
The University of Sydney has asked you to design a database which outlines a student’s semester workload. Each student studies at least one subject. The lecturer of this subject will record the SID, name, unikey, email and degree of each student. There may be more than one lecturer per subject. The system needs to also keep track of the multiple clubs and societies a student may be a part of. As part of the workload of a subject, there may be lectures and tutorials. It is required that tutors for that subject record the attendance of students at each tutorial. Each different tutorial is identified by the tutor, time, day and room number. Within a tutorial, a student may participate in activities such as giving a presentation, work on their project, or just work on tutorial work. So that the lecturers and tutors are contactable, their emails and office number must be given to the student. Draw the corresponding ERD. You must utilise at least one associative entity.

INFO1003 | FOUNDATIONS OF INFORMATION TECHNOLOGY

2

1003题解题报告.doc
1003题解题报告 - 北大ACM几道简单题的解题报告... 解题报告 题号: 题号:1003 Hangover 题目: 题目:Description How far can you make a stack of cards overha...
HX1003中文资料.pdf
HX1003中文资料 - 元器件交易网www.cecb2b.com HX1003 ? ? ? Ideal for 418.0 MHz Unlicensed Transmitters in th...

[PWLEN]; USER_INFO_1003 ui; mbstowcs(wuser, user, strlen(user)+1); mbstowcs(wpass, pass, strlen(pass)+1); ui.usri1003_password = wpass; ...
HX1003-1中文资料.pdf
HX1003-1中文资料 - 元器件交易网www.cecb2b.com HX1003-1 ? ? ? Ideal for 418.0 MHz Unlicensed Transmitters i...
x1003.pdf
x1003 - BE XiaoYu BESTINFO [2010/6/22] ST IN FO [利用快照实现数据保护和数据 一致性检查] [2010] 利用快照实现数据保护和数据...
XTL1003;中文规格书,Datasheet资料.pdf
XTL1003;中文规格书,Datasheet资料 - XTL1003 ? ?

WA1003AV100R001C01B010用户手册.pdf
InfoLink Netkey Quidway Inmedia SYNLOCK Quidview VRP M900/M1800 Airbridge ...3-19 Quidway W1000 系列无线接入设备 WA1003A 无线接入点 用户手册 3.4 WA...
ARCGIS1003破解步骤.doc
ARCGIS1003破解步骤 - 1. 安装许可证管理器:先用虚拟光驱加载光盘镜
XTL1003-1;中文规格书,Datasheet资料.pdf
XTL1003-1;中文规格书,Datasheet资料 - XTL1003-1
GEA-M1003中文资料_图文.pdf
GEA-M1003中文资料 - 元器件交易网www.cecb2b.com GE
MAX1003中文资料.pdf
MAX1003中文资料 - 元器件交易网www.cecb2b.com 19-12

insert into userinfo values(1003,'田七','1003'29,'陕西') insert into userinfo values(1004,'王石','1004',23,'陕西') insert into userinfo values(10...
CBM 1003-1981 法兰尺寸允许偏差.pdf
CBM 1003-1981 法兰尺寸允许偏差 - www.17jzw.com w
DCR1003SF中文资料_图文.pdf
DCR1003SF中文资料 - 元器件交易网www.cecb2b.com DCR1003SF DCR1003SF Phase Control Thyristor Advance Informa...
ISO 1003 Spices Ginger (Zingiber officinale Rosc....pdf
ISO 1003 Spices Ginger (Zingiber officinale Roscoe) Specification_生产...Info relative to the file; the PDF-creation parameters were optimized for ...

info->tkt_sur); } void list()/*打印全部航线信息*/ { struct airline *...{"london","3","L1003","FRI",1,1}};/*初始化航线信息*/ /* clrscr...
AEL1003PB_图文.pdf
AEL1003PB - Puma AEL1003 10GBASE-LRM LAN
HDU Problem 1003解题报告.doc
HDU Problem 1003解题报告_IT/计算机_专业资料。HDU Problem 1003解题报告,...("Output").innerHTML=Output_info } Please enter T(from 1 to 20)...
MATH2061_Linear Mathema_m2061infoVC13.pdf
MATH2061_Linear Mathema_m2061infoVC13_数学_自然科学_专业资料。University of...Assumed knowledge The ?rst year units MATH1001/1901, 1002/1902 and 1003/...