SHARE
TWEET

Untitled

a guest Sep 22nd, 2019 100 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /*
  2. Dataset DreamHome terdiri dari 7 relasi yaitu Branch, Staff, PropertyForRent, Client, PrivateOwner, Viewing, dan Registration
  3. */
  4.  
  5. group: DreamHome
  6. Branch = {
  7.     branchNo:string, street:string, city:string, postcode:string
  8.     'B005'    , '22 Deer Rd'     , 'London'     , 'SW1 4EH'        
  9.     'B007'    , '16 Argyll St'   , 'Aberdeen'   , 'AB2 3SU'            
  10.     'B003'    , '163 Main St'    , 'Glasgow'    , 'G11 9QX'
  11.     'B004'    , '32 Manse Rd'    , 'Bristol'    , 'BS99 1NZ'
  12.     'B002'    , '56 Clover Dr'   , 'London'     , 'NW10 6EU'
  13. }
  14.  
  15. Staff = {
  16. staffNo:string, fName:string, lName:string, position:string, sex:string, DOB:string, salary:number, branchNo:string
  17. 'SL21'  , 'John'    , 'White'   , 'Manager' , 'M', '1-Oct-45'   , 30000 , 'B005'
  18. 'SG37'  , 'Ann'     , 'Beech'   , 'Assistant'   , 'F', '10-Nov-60'  , 12000 , 'B003'
  19. 'SG14'  , 'David'   , 'Ford'    , 'Supervisor'  , 'M', '24-Mar-58'  , 18000 , 'B003'
  20. 'SA9'   , 'Mary'    , 'Howe'    , 'Assistant'   , 'F', '19-Feb-70'  , 9000  , 'B007'
  21. 'SG5'   , 'Susan'   , 'Brand'   , 'Manager' , 'F', '3-Jun-40'   , 24000 , 'B003'
  22. 'SL41'  , 'Julie'   , 'Lee'     , 'Assistant'   , 'F', '13-Jun-65'  , 9000  , 'B005'
  23. }
  24.  
  25. PropertyForRent = {
  26. propertyNo:string, street:string, city:string, postcode:string, type:string, rooms:number, rent:number, ownerNo:string, staffNo:string, branchNo:string
  27. 'PA14'  , '16 Hollhead'     , 'Aberdeen'    , 'AB7 5SU' , 'House'   , 6, 650, 'CO46', 'SA9'     , 'B007'
  28. 'PL94'  , '6 Argyll St'     , 'London'  , 'NW2'     , 'Flat'    , 4, 400, 'CO87', 'SL41'    , 'B005'
  29. 'PG4'   , '6 Lawrence St'   , 'Glasgow' , 'G11 9QX' , 'Flat'    , 3, 350, 'CO40', ''        , 'B003'
  30. 'PG36'  , '2 Manor Rd'      , 'Glasgow' , 'G32 4QX' , 'Flat'    , 3, 375, 'CO93', 'SG37'    , 'B003'
  31. 'PG21'  , '18 Dale Rd'      , 'Glasgow' , 'G12'     , 'House'   , 5, 600, 'CO87', 'SG37'    , 'B003'
  32. 'PG16'  , '5 Novar Dr'      , 'Glasgow' , 'G12 9AX' , 'Flat'    , 4, 450, 'CO93', 'SG14'    , 'B003'
  33. }
  34.  
  35. Client = {
  36. clientNo:string, fName:string, lName:string, telNo:string, prefType:string, maxRent:number, eMail:string
  37. 'CR76', 'John'  , 'Kay'     , '0207-774-5632'   , 'Flat'    , 425, 'john.kay@gmail.com'
  38. 'CR56', 'Aline' , 'Stewart' , '0141-848-1825'   , 'Flat'    , 350, 'astewart@gmail.com'
  39. 'CR74', 'Mike'  , 'Ritchie' , '01475-392178'    , 'House'   , 750, 'mritchie01@yahoo.co.uk'
  40. 'CR62', 'Mary'  , 'Tregear' , '01224-196720'    , 'Flat'    , 600, 'maryt@hotmail.co.uk'
  41. }
  42.  
  43. PrivateOwner = {
  44. ownerNo:string, fName:string, lName:string, address:string, telNo:string, eMail:string, password:string
  45. 'CO46', 'Joe'   , 'Keogh'   , '2 Fergus Dr  , Aberdeen AB2 7SX' , '01224-861212'    , 'jkoegh@llh.com'  , '*******'
  46. 'CO87', 'Carol' , 'Farrel'  , '6 Achray St  , Glasgow G32 9DX'  , '0141-357-7419'   , 'cfarrel@gmail.com'   , '*******'
  47. 'CO40', 'Tina'  , 'Murphy'  , '63 Well St   , Glasgow G42'      , '0141-943-1728'   , 'tinam@hotmail.com'   , '*******'
  48. 'CO93', 'Tony'  , 'Shaw'    , '12 Park Pl   , Glasgow G4 0QR'   , '0141-225-7025'   , 'tony.shaw@ark.com'   , '*******'
  49. }
  50.  
  51. Viewing = {
  52. clientNo:string, propertyNo:string, viewDate:string, comment:string
  53. 'CR56', 'PA14'  , '24-May-13', 'too small'
  54. 'CR76', 'PG4'   , '20-Apr-13', 'too remote'
  55. 'CR56', 'PG4'   , '26-May-13', ''
  56. 'CR62', 'PA14'  , '14-May-13', 'no dining room'
  57. 'CR56', 'PG36'  , '28-Apr-13', ''
  58. }
  59.  
  60. Registration = {
  61. clientNo:string, branchNo:string, staffNo:string, dateJoined:string
  62. 'CR76', 'B005', 'SL41', '2-Jan-13'
  63. 'CR56', 'B003', 'SG37', '11-Apr-12'
  64. 'CR74', 'B003', 'SG37', '16-Nov-11'
  65. 'CR62', 'B007', 'SA9', '7-Mar-12'
  66. }
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top