Embedded Files
Client - Project (1- many Relationship)
Client - Project (1- many Relationship)
A second 1-many relationship in out personnel system is Client to Project.
- Relationship rules
Projects that are created for a client
Clients may have 0, 1 or many (∞) Projects.
Each Project is allocated 1 Client.
(Note this means a client must exist before a project is created )
2. Entity Relationship Diagram (ERD)
2. Entity Relationship Diagram (ERD)
3. Fully attributed ERD (Extended/ Enhanced ERD)
3. Fully attributed ERD (Extended/ Enhanced ERD)
3. Resolve any many-many relationships
3. Resolve any many-many relationships
This is a 1-many relationship so you don't need to add any additional "joining" tables.
4. Data Dictionary (Project)
4. Data Dictionary (Project)
Activity
Activity
Create the Project Table (tblProject)
Activity
Activity
Create the Relationship and enforce referential integrity
Activity
Activity
Add some data to the Project table. You can use the following test data.
Google Sites
Report abuse