a. Denormalize 1:* or 1:1 by duplicating existing columns in Table Parent v
b. Denormalize the Detail Table (*:*) by duplicating the column “from Table” Parent of the detail table builder.
A Denormalize 1 Or 1 1 By Duplicating Existing Columns In Table Parent V B Denormalize The Detail Table By Dup 1 (53.82 KiB) Viewed 30 times
Logical ERD FooDiary: Memik 1.1 1.1 Menu IDMenu (PK) IDRecto (FK) IDJenis Makanan (FK) NamaMenu Harga Status Summary RatingMenu Resto IDResto (PK) IDDompet (FK) NamaResto SummaryRating Resto AlamatResto Nomor Teleponesto JamBuka Jam Tutup StatusBukaTutup Menyimpan Saldo 1.1 Menerima Mengikalegorik 1.5 Menyimpan Saida IDTransaction (PK) IDMenu (FK) City JenisMakanan DJansMakanan (PK) Jenis Makanan Pelanggan 1.1 DPelanggan(PK) 100met FK) NamaPelanggan Nomor Telepon 1.1 DetailPemesanan RatingMenu Dompet IDDompet (PK) Jumlah Saldo Sal I Melakukan 1.1 Memesan 1.1 Mengantar 1.1 Pemesanan IDTransaction (PK) IDPelanggan (FK) IDPembayaran (FK) IDDeliveryMan (FK) 10Status (FK) Alamat Pemesanan TanggalTransaks RatingResto Status IDStatus StatusDelvery Menyimpan DeliveryMan 10Delvery Man (PK) DDompet (FK) NamaDelivery Man Nomor Motor Nomor Telepon 1. 1.1 Mendeskrekan TipePembayaran DPembayaran (FK) JenisPembayaran Nomorfembayaran Menentukan Pembayaran 1.1
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!