If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ANSI SQL > Entities

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-01-07, 08:22
truetaurus truetaurus is offline
Registered User
 
Join Date: Apr 2007
Posts: 5
Question Entities

I got a problem trying to determine entities from a piece of text:
SEE ATTACHMENT (see page 3 of the attachment pls (KWEA case study))

This is what i did, but i jus want someone to tell me if it look correct or what i need to do?
Entities
 STAFF_MEMBER
 PROPERTY
 TENANT
 SERVICE
 PLACEMENT
 WAITING_LIST
 OWNER

thanks wud appreciate
Attached Files
File Type: pdf CSG1207 A2 sem1 2007 OS.pdf (333.4 KB, 1347 views)
Reply With Quote
  #2 (permalink)  
Old 05-01-07, 10:28
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
thank you for the lovely example database design assignment paper

i have not read it, i just glanced at it

you know, like if you're shipwrecked on a lonely island with only a volleyball for company, and you find all these wonderful packages floating ashore -- first you rescue it (saves pdf to hard drive) and then you open it at leisure

anyway, regarding your question:

Entities
 STAFF_MEMBER
 PROPERTY
 TENANT
 SERVICE
 PLACEMENT
 WAITING_LIST
 OWNER

looks like a list of entities to me, so i guess that's okay

or were you asking whether i think there might be one missing?

let me give you a big hint about how to do data modelling and database design -- you need to know the data, inside and out

study the information that is given for the assignment, all the entities are in there

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On