I've already began a project like that and this is the outline of the coding:
Create table tbl_shop_configuration
(shop_id varchar(3) primary key,
shop_name varchar (50) not null,
shop_address varchar (200) not null,
shop_phone varchar (15) not null
);
Create table tbl_shop_customer
(shop_id varchar (3) not null,
customer_id varchar (10) not null,
primary key (shop_id,customer_id)
);
Create table tbl_customers
(customer_id varchar (10) primary key,
customer_name varchar (50) unique not null,
customer_phone varchar(15) not null,
customer_address varchar(200) not null
);
Create table tbl_services
(service_id varchar(10) primary key,
service_name varchar(50) not null
);
Create table tbl_shop_service
(shop_id varchar(3) not null,
service_id varchar(10) not null,
primary key (shop_id,service_id)
);
Create table tbl_parts
(part_id varchar(10) primary key,
part_name varchar(50) not null,
part_price number(10) ,
part_qty number(10)
);
Create table tbl_shop_part
(shop_id varchar(3) not null,
part_id varchar(10) not null,
primary key (shop_id,part_id)
);
Create table tbl_orders
(order_id varchar(3) primary key,
customer_id varchar(10),
CONSTRAINT customer_order_fk FOREIGN KEY (customer_id)REFERENCES tbl_customers(customer_id),
order_date date,
shop_id varchar(3),
CONSTRAINT shop_order_fk FOREIGN KEY (shop_id)REFERENCES tbl_shop_configuration(shop_id),
service_id varchar(10),
CONSTRAINT service_order_fk FOREIGN KEY (service_id)REFERENCES .......