1 / 8

DATA MANAGEMENT: ATTRIBUTE COMPONENT

DATA MANAGEMENT: ATTRIBUTE COMPONENT. www.malaysiagis.com. DATABASE CONCEPTS. collection of logical and implicit data designed, built and populated with data for a certain purpose represents certain aspects database model is used to describe it’s structural concept.

ketan
Download Presentation

DATA MANAGEMENT: ATTRIBUTE COMPONENT

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATA MANAGEMENT:ATTRIBUTE COMPONENT www.malaysiagis.com

  2. DATABASE CONCEPTS • collection of logical and implicit data • designed, built and populated with data for a certain purpose • represents certain aspects • database model is used to describe it’s structural concept. • data type, relationship and dependency between data • a data management language to define the data characteristics and the data structure and to manipulate the data • instants are data in database at a certain period of time

  3. LICENSE NO_LICENSE NRIC D_APPR J_LICENSE PERIOD P_APPOVAL HAWKERS NRIC OWNER NAME DOB ADDRESS GENDER STALLS SALES NRIC OWNER ADDRESS SHOP OWNERS NRIC OWNER NAME DOB ADDRESS GENDER Schema model of Data Relationship

  4. LAND PARCEL LOT_NO VALUATION_PRICE TAX_RATE OWNERSHIP OWNER NAME 4479 194 2001 350 50,000 700,000 950,000 25 200 5,500 7,000 25 freehold lease lease freehold Farid Sulaiman Sharifah Sulaiman Database Instants

  5. Structured Query Language (SQL) • a non-procedural language • user specifies what must be done, but not how it is to be done • uses algebra operations to perform queries • SQL has become the catalyst in the development of client/server and distributed databases • Basic forms of SQL: SELECT <attribute list> FROM <relationship list> WHERE <conditions>

  6. LICENSE LICENSE_NO NRIC_HAWKER T YEAR LICENSE PERIOD APPROVAL STORE CATEGORY NRIC HAWKER ADDRESS HAWKER NRIC HAWKER NAME DOB ADDRESS GENDER 423 193 701 311 200 200 50 50 Ali Samad Samad Ali 4805637 5547430 6000439 3776519 1983 1992 1990 1987 makanan makanan surat khabar surat khabar Jln Tembaga Kuning, Sri Skudai Jln Ronggeng, Skudai Baru Jln Tembaga Merah, Sri Skudai Jln Timah, Sri Putri buah-buahan surat khabar makanan makanan 4805637 6000439 3954197 5547430 7889012 6000139 2671900 Razali Aminah Hassan 08.11.65 04.04.48 27.03.47 lelaki perempuan lelaki 45 Jln Timah 2, Sri Putri 2 Jln Timah 18 Sri Putri 14 Jln Emas 2, Sri Skudai Database Instants

  7. SQL QUERY: EXAMPLE 1 Obtain license number and IC no. of licensee SELECT LICENSE_NO, NRIC_LICENSEE FROM LICENSEE WHERE LICENSE = “MAKANAN” select tuple from relationship LICENSEE that fulfills the condition on attribute LICENSE_NO and NRIC_LICENSEE SQL QUERY: EXAMPLE 2 – Lab Exercise 2 – Waqf project

  8. BENEFITS OF DATABASE • connector between program and data • redundancy control • data sharing • data security

More Related