Brand Apple
type: Brand
product name: Apple

Brand Samsung
type: Brand
product name: Samsung

Brand Nike
type: Brand
product name: Nike

Brand Penguin
type: Brand
product name: Penguin Books

Cat Catalog
type: Category
product name: Catalogue général

Cat Electronics
type: Category
product name: Électronique
sub category of: Cat Catalog

Cat Smartphones
type: Category
product name: Smartphones
sub category of: Cat Electronics

Cat Laptops
type: Category
product name: Ordinateurs portables
sub category of: Cat Electronics

Cat Fashion
type: Category
product name: Mode
sub category of: Cat Catalog

Cat Shoes
type: Category
product name: Chaussures
sub category of: Cat Fashion

Cat Books
type: Category
product name: Livres
sub category of: Cat Catalog

Seller TechStore
type: Seller
full name: TechStore SARL

Seller FashionHub
type: Seller
full name: FashionHub

Prod iPhone15
type: Electronics
product name: iPhone 15 Pro
price: 12999.00
stock quantity: 25
description: Smartphone Apple 256 Go
has category: Cat Smartphones
has brand: Brand Apple
sold by: Seller TechStore
related product: Prod MacBookAir
has review: Rev 1

Prod GalaxyS24
type: Electronics
product name: Samsung Galaxy S24
price: 9999.00
stock quantity: 0
description: Smartphone Samsung 256 Go
has category: Cat Smartphones
has brand: Brand Samsung
sold by: Seller TechStore
has review: Rev 4

Prod MacBookAir
type: Electronics
product name: MacBook Air M3
price: 15999.00
stock quantity: 8
has category: Cat Laptops
has brand: Brand Apple
sold by: Seller TechStore
has review: Rev 3

Prod NikeAirMax
type: Clothing
product name: Nike Air Max 90
price: 1299.00
stock quantity: 40
has category: Cat Shoes
has brand: Brand Nike
sold by: Seller FashionHub
has review: Rev 2

Prod CleanCode
type: Book
product name: Clean Code
price: 499.00
stock quantity: 100
has category: Cat Books
has brand: Brand Penguin
sold by: Seller TechStore

Prod iPhone14
type: Electronics
product name: iPhone 14
price: 8999.00
stock quantity: 5
has category: Cat Smartphones
has brand: Brand Apple
sold by: Seller TechStore
replaced by: Prod iPhone15

Addr Amine
type: Address
city: Casablanca
country: Maroc

Addr Sara
type: Address
city: Rabat
country: Maroc

Cust Amine
type: Customer
full name: Amine El Idrissi
loyalty level: gold
has address: Addr Amine

Cust Sara
type: Customer
full name: Sara Benali
loyalty level: silver
has address: Addr Sara

Cust Youssef
type: Customer
full name: Youssef Tazi
loyalty level: bronze

Order 1001
type: Order
ordered by: Cust Amine
order date: 2026-06-01
total amount: 13498.00
has order item: Item 1001a
has order item: Item 1001b
has payment: Pay 5001
shipped to: Addr Amine

Item 1001a
type: OrderItem
refers to product: Prod iPhone15
quantity: 1
unit price: 12999.00

Item 1001b
type: OrderItem
refers to product: Prod CleanCode
quantity: 1
unit price: 499.00

Pay 5001
type: Payment
amount: 13498.00
payment method: card

Order 1002
type: Order
ordered by: Cust Sara
order date: 2026-06-05
total amount: 2598.00
has order item: Item 1002a
has payment: Pay 5002
shipped to: Addr Sara

Item 1002a
type: OrderItem
refers to product: Prod NikeAirMax
quantity: 2
unit price: 1299.00

Pay 5002
type: Payment
amount: 2598.00
payment method: paypal

Rev 1
type: Review
rating: 5
review text: Excellent téléphone, livraison rapide !
written by: Cust Amine

Rev 2
type: Review
rating: 4
review text: Très bonnes chaussures, taille un peu grande.
written by: Cust Sara

Rev 3
type: Review
rating: 3
review text: Correct mais cher.
written by: Cust Youssef

Rev 4
type: Review
rating: 2
review text: Déçu, ne fonctionne pas bien.
written by: Cust Youssef

Promo Summer
type: Promotion
product name: Soldes d'été
discount rate: 0.15
applies to: Prod NikeAirMax
applies to: Prod MacBookAir