Nation Warehouse is supplier that supplies many kinds of product to retailers. All stocks are supply by many manufacturers depends on types of products before its distributed to all retailers.
Currently, this company is using manual system to store information on inventory and stock delivery where by the process of ordering the products on will be done when stock is reach required level and its calculated based on quantity left at the rack. This process is consumes a lot of time and the company decided to develop a database system to assist them in storing and updating related information.
The following are requirements for the system
All information about manufactures need to be stored such as manufacturer ID, company name, address, telephone number and fax number.
Inforamtion about retailers also need to be kept such as retailer ID, company name, address, telephone number, and fax number.
Product information also will recorded such as product code, type of product, product name, selling price, retail price and quantity in stock.
All information of each order that made to manufacturer need to be recorded such as order number, date of order, quantity ordered for each product code and overall total.
All information for delivering products ordered made by the manufacturer need to be kept such as delivery number, date of delivery, overall total, manufacturer ID. Each delivery made can contain many kind of products and must have product code, quantity delivered for each product, delivery number and sub total.
Information about purchasing made by the retailers also needs to be kept such as product code, retailers ID, quantity and subtotal. Invoice will be giving to the retailer that contains invoice number, invoice date and overall total.
Trace Entities
1. Manufacturer ( manufacturer_id <PK> , company name , address, telephone number, fax number )
2. Retailers ( retailers_ID <PK> , company name, address, tel_no , fax_no )
3. Product ( product_code <PK> , type of product, product_name, selling_price, retail_price, quantity)
4. Order ( order_no <PK>, date of order, quantity_order, total )
5. Delivery ( delivery_no, date of delivery, total, manufacturer_ID<FK>, product_code<FK>, quantity_delivered)
6. Purchase ( product_code<PK> , retailers_ID, quantity, quantity, total )
7. Invoice (Invoice_no, Invoice_date, total )
Productif Sepakat is a company that specialized in organizing many programs and activities to youth and teenagers, Most of them are arranged by government or private sector. All programs are concerning on self grooming development of youth and youngster.
You are required to create ERD based on the requirements specification below :
a) Company is organizing many kinds of program and the information about program that need to be kept are program code, name of the program, type of program,date the program held, end date, venue, duration and budget allocation.
b) Each programs organized has sponsored company that sponsored the cost of the programs. Sponsored company may come from government sector and private sector. The information held about sponsored company are sponsor code, name of the sponsor, address, telephone number, fax number and contact person name.
c) One sponsored company may sponsor more than one program and each program may sponsor by more than one company. Total of sponsorship given by the company will recorded
d) Candidate that is interested in attending the programs needs to register by giving the important personal details such as candidate’s name , address, house number phone, hand phone number, and office phone number. Candidate can be individually or group of staff form company. Each candidate is identified by a unique candidate code
e) Candidate is allow to register on more than one one program
f) Each programs has many volunteers who are assisting the company in running the program smoothly. Information kept for a volunteer is volunteer code, name of volunteer, address and phone number. Volunteers can participates in more than one program. Time , day, and date need to be recorded for every participation
g) All information about facilitator involved in each program need to berecorded such as facilitator code, facilitator name, address and phone number.
h) Each facilitator is offered to handle more than one program and each program can be handle by many facilitator. Name of the activity in each program handled by the facilitator, time, dateand also day need to be recorded
