Contoh Masalah
You want to design a database for insurance companies. Data will include information about customers (name, address, and phone numbers), information about the insured cars (make, model, year, vehicle_ID #, license #, and insurance rates), information about insured homes (address, insured value, and insurance rate), and information about claims made on insured cars and homes (date of the claim, date of sattlement, and amount of settlement).You may assume that all insured cars and homes are owned by a single customer, but you should allow a customer to own several cars and homes
You want to design a database for insurance companies. Data will include information about customers (name, address, and phone numbers), information about the insured cars (make, model, year, vehicle_ID #, license #, and insurance rates), information about insured homes (address, insured value, and insurance rate), and information about claims made on insured cars and homes (date of the claim, date of sattlement, and amount of settlement).You may assume that all insured cars and homes are owned by a single customer, but you should allow a customer to own several cars and homes
draw E / R design for your database. Don’t forget to underline key attributes for entity sets and indicate the multiplicity of relationship sets using arrowheads or by labeling them 1:1, 1: M, or M: N as appropriate. if there is a weak entity sets or "is-a" relationships, make sure to notate them appropriately.
Download Contoh Jawabannya
(Maaf kalau seandainya masih terdapat kesalahan)
Tugas Basis Data (Tipe 1)
Tugas Basis Data (Tipe 2)
Tugas Basis Data (Tipe 3)
Posts
0 Comments:
Post a Comment