# 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

INFO1003_Foundamental of IT_2012 Semester 2_tutoria...
INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 1_FTP With FileZilla_电脑基础知识_IT/计算机_专业资料。University of Sydney_INFO1003_Founda...

\n"); } } void return_tkt() /*退票模块*/ { struct airline *info; ...{"london","3","L1003","FRI",1,1}};/*初始化航线信息*/ /* clrscr...
1003题解题报告

info wid ip sign 说明贵平台用户 ID 替换贵网站登录用户 ID 挖米啦任务 ID...1003 tradid 重复 1004 userid 不存在 1005 wtid 不存在 1006 非法 IP 说明...
My First RPG Game总结二
100 1003,蓝药,icon-potion3,Drug,0,100,60,80 我们发现,当物品种类是药品...value 为 ObjectInfo 集合来标识 [csharp] view plain copy 在 CODE 上查看...

( 2003, --two-dimensional polygon NULL, NULL, SDO_ELEM_INFO_ARRAY(1,1003,3), --one rectangle (1003 = exterior) SDO_ORDINATE_ARRAY(1,1, 5,7) ...
HDU Problem 1003解题报告
HDU Problem 1003解题报告_IT/计算机_专业资料。HDU Problem 1003解题报告,javascript...("Output").innerHTML=Output_info } Please enter T(from 1 to 20)...

"L1003","FRI",1,3}};; void display(struct airline *info) /*打印每条航线的基本信息*/ {printf("%8s\t%3s\t%s\t%4s\t\t%3d\t%10d\n",info-...
C 语言数据结构实验——航空票务管理系统
info->tkt_sur); } void list()/*打印全部航线信息*/ { struct airline *...{"london","3","L1003","FRI",1,1}};/*初始化航线信息*/ /* clrscr...