THE DATABASE OF MSY TECHNOLOGY PTY. LTD PRODUCT
Download
1 / 13

Overview of Database - PowerPoint PPT Presentation


  • 75 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
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.


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