Embedded Files
Entity/Attributes notation showing keys
Entity/Attributes notation showing keys
When we describe the entities and attributes we can also show the PKs and FK by underlining the PKs and putting a * next to the FKs.
tblEmployee ( EmployeeID, Name, Salute, Addr, AddrTownCity, Mobile, IRDNumber, Comments)
tblClients ( ClientID, Name, Address, Mobile, GSTNumber, Comments)
tblCarpark (CarparkID, EmpID*, CarparkLocation)
tblAssets (AssetID, ClientID*, Description, PurchaseDate, Value)
tblTimesheet (TimesheetID, EmployeeID*, ClientID*, Date, Time, Description)
In MS-Access this would be
Google Sites
Report abuse