Normalize ගැන දන්න කවුරු හරි හෙල්ප් එකක් දියල්ලා කොල්ලනෙ. ER Diagram එකක් Normalize කරන්නේ කොහොමද?
දන්න කවුරු හරි කෙනෙක් ඉන්නවා නම් පී ඇම් එකක් දාන්න.
දන්න කවුරු හරි කෙනෙක් ඉන්නවා නම් පී ඇම් එකක් දාන්න.
Latest ads
-
USA Linux OpenVZ VPS අඩු මිලකට
- Nadun26
- Updated:
-
Shared Hosting වාර්ෂිකව රු 2200 සිට!
- Nadun26
- Updated:
-
හොඳ, දැන්වීම්-රහිත (ad-free) ආයුර්වේද ඇප් එකක් සොයා ගැනීමට නොහැකි වූ නිසා, මමම එකක් නිර්මාණය කළා- kitchen_discussions
- Updated:
-
ZTE MF283U 4G Unlocked Router (Used)
- ayanthamaxi
- Updated:
Normalize/ER Diagram help
- Thread starter JohnSnow
- Start date
diagram eka bn...dalane tyenne
1NF ekedi, data 2k ekama cell eke tiawa nan ewa kadaganna ona, Ex, library ekaka ekkenek gatta poth 2k, book1, boo2k kyala dala tianwa nan e 2 rows dekakata daganna ona.
2nf eke di, repeat wena data hoyagena tables walata wen karaganna ona. Ara books walata wenama table ekk dala, book_id eka members la ekka link krnna ona.
3nf ekedi oka tawa durata wen karana eka krnne, main table eke tiana data tawa tables walata, foreign key dala wen karanawa, data repeat wena eka adu wenawa.
real case scenario ekakadi wenas wenawa owa itn. relationships ena widihata, apita data ganna ona widihat ekka.
mn danna tharamin qwwe.
ER Diagram - https://ibb.co/hfLhtkg
Q - Normalize all the relations which extracted from the above Entity Relationship diagram
seen eka therenwa eth meka kraganna theren ne ne.
ER Diagram - https://ibb.co/hfLhtkg
Q - Normalize all the relations which extracted from the above Entity Relationship diagram
------ Post added on Sep 12, 2021 at 4:42 PM
Last edited:
ER Diagram - https://ibb.co/jDrbmxd
Q - Normalize all the relations which extracted from the above Entity Relationship diagram
seen eka therenwa eth meka kraganna theren ne ne.
ER Diagram - https://ibb.co/jDrbmxd
Q - Normalize all the relations which extracted from the above Entity Relationship diagram
------ Post added on Sep 12, 2021 at 4:42 PM
meka explain karala mkt wistaryk nadda? process eka khmada wenne kyala
Oka simple wedak. Oya ER eke square type eken eliyata lines gahala connect karala thiyena ewwa relations kiyala hithagena e hama ekatama dummy data 1k daa gaththama therenava mokadda karann oni kiyala. Hama ekak ekkama shipped items ekka relation ekak thiyenava, habei e connect una hama ekama wenama table kiyala hithanna. Mewwagen oyata kemathi tharamak table data oyata shipped item ekata genna puluvan, habei optimal ma mona tables shipped ekata genawoth da kiyan eka nm data wala gathi sobhavaya matha decide karnna wenne..ER Diagram - https://ibb.co/jDrbmxd
Q - Normalize all the relations which extracted from the above Entity Relationship diagram
seen eka therenwa eth meka kraganna theren ne ne.
ER Diagram - https://ibb.co/jDrbmxd
Q - Normalize all the relations which extracted from the above Entity Relationship diagram
------ Post added on Sep 12, 2021 at 4:42 PM
Oya explin kale eka part ekak gawitharai eth normalize karannem total er diagram eka gana ekata hithala.
UPS company prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the heart of the UPS product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the UPS system at a single retail center. Retail centers are characterized by their type, uniqueID, and address. Shipped items make their way to their destination via one or more standard UPS transportation events (i.e., flights, truck deliveries). These transportation events are characterized by a unique scheduleNumber, a type (e.g, flight, truck), and a deliveryRoute
Last edited:
