slide1
Download
Skip this Video
Download Presentation
Overview of Database

Loading in 2 Seconds...

play fullscreen
1 / 13

Overview of Database - PowerPoint PPT Presentation


  • 78 Views
  • Uploaded on

THE DATABASE OF MSY TECHNOLOGY PTY. LTD PRODUCT Ronald Diningrat High Distinction Assignment Autumn 2007. Overview of Database. This database is designed for MSY Product Stock. http://www.msy.com.au/Parts/PARTS.pdf Has 9 store around Australia. Selling computer parts

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Overview of Database' - karan


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1
THE DATABASE OF MSY TECHNOLOGY PTY. LTD PRODUCTRonaldDiningrat High Distinction AssignmentAutumn 2007
overview of database
Overview of Database
  • This database is designed for MSY Product Stock.
  • http://www.msy.com.au/Parts/PARTS.pdf
  • Has 9 store around Australia.
  • Selling computer parts
  • The database is used to organise the stock from all over the store
  • Store, Stock, Product and Product category.
slide3
ERD

Stock

BranchName*

ProductNo*

Available

Product

ProductNo

BrandName

BrandType

ProductCategoryNo*

Price

Store

BranchName

Street

Suburb

State

Postcode

Tel

Fax

WorkingHours

ProductCategory

ProductCategoryNo

Category

Subcategory

a simple query of a single table
A Simple query of a single table
  • List the table of product categroy
natural join
Natural join
  • List branch name, product no. and brand type from table stock and product
group by
Group by
  • List the branch name and stock available in each store.
sub query
Sub Query
  • List the brand name and brand type of product that has price cheaper that ML-2010
check constraint
Check Constraint

CONSTRAINT State CHECK (State IN (

\'NSW\',

\'VIC\',

\'QLD\',

\'ACT\',

\'WA\',

\'SA\',

\'NT\',

\'TAS\'

))

sql syntax for actions
SQL Syntax for Actions
  • CONSTRAINT FKProduct FOREIGN KEY (ProductCategoryNo) REFERENCES PRODUCTCATEGORY
  • ON DELETE CASCADE
  • ON UPDATE CASCADE
  • CONSTRAINT FKStock2 FOREIGN KEY (ProductNo) REFERENCES PRODUCT
  • ON DELETE CASCADE
  • ON UPDATE CASCADE
create view
Create View
  • Create a table contains brand and price of ASUS
ad