soalan yg diberi ialah.
Question 1
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 it is 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 only will be done when process is consumes a lot of time and the company decided to develop a database system to assist them instoring and updating related information.
The following are requirements for the system:-
All information about manufacture need to be stored such as manufacture ID,company name,address,telephone number and fax number.
Information about retailers also needs to be kept such as retailer ID,company name,address,telephone number and fax number.
Product information also will be recorded such as product code,type of product,product name,selling price,retail price and quantity in stock.
All information for 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 manufacturer need to be kept such as delivery number,date of delivery ,overall total and manufacturer ID.Each delivery made can contain many kind of product ,delivery number and sub total.
Information abuot purchasing made by retailerss also needs to be kept such as product code,retailer ID,quantity and sub total.Invoice will be giving to the retailer that contains invoice number,invoice date and overall total.
Question 2
Produkif Sepakat is a company that specialized in organizing many programs and activities related to youth and teenagers. Most of the programs are arranged by government or private sector. All programs are concerning on self grooming development of youth and youngsters.
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 program organized has sponsored company that sponsors the cost of the program.Sponsored company may come from government sector or private sector .The information held about sponsored company are sponsors code,name of sponsors,address,telephone number,ffax number and contact person’s name.
c)One sponsored company may sponsored more than one program and each program may sponsored by more than one company.Total of sponsorship given by the company will be recorded
d)Candidate that is interested in attending the program needs to register by giving the important personal details such as candidate’s name,address ,house phone number,hand phone number and office phone number.Candidate can be individually or group of staff from a company.Each candidate is identifield by a unique candidate code.
e)Candidate is allows to register on more than one program.
f)Each program 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.Volunteer can articipates on more than one program.Time,dat and date need to be recorded for every participation.
g)All information about facilitator involved in each program need to be recorded such as facilitator code,facilitator’s name, address and phone number.
h)Each facilitator is offered to handle more than one program and each program can be handled by many facilitators.Name of the activity each program handled by the facilitator,time,date and also day need to be recorded.
Answer Question 1
Answer Question 1
- 1. Manufactures
Manufacturer_ID (PK)
Company name
Address
Telephone number
Fax number
- 2. Retailers
Retailer_ID (PK)
Company name
Address
Telephone number
Fax number
- 3. Product
Product Code
Type of product
Product name
Selling price
Retail price
Quantity stock
- 4. Order
Order no
Date of order
Quantity order
Over all total
- 5. Delivering
Manufacturer_ID
Overall total
Delivery no
Date of delivery
- 6. Invoice
Invoice number
Invoice
Overall total
- 7. Purchasing
Product code
Retailer_ID
Quantity
Sub total
