a. Denormalize 1:* or 1:1 by duplicating existing columns in Table Parent v b. Denormalize the Detail Table (*:*) by dup
Posted: Tue Jul 12, 2022 8:21 am
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.
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
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 31 times