SQL Data models

by

for 1.2 you will need one more table which will hold task and items relation ship for example

Table : Task_Item_Rel {TaskID,ItemID}

whenver you want item related to a particular task simply have a query with joins between task,item and Task_Item_Rel

More Related Contents:

  1. Why is SELECT * considered harmful?
  2. How to check if a table exists in a given schema
  3. How do I reset a sequence in Oracle?
  4. Synchronizing client-server databases
  5. ORA-00904: invalid identifier
  6. How to create multiple one to one’s
  7. How to select unique records by SQL
  8. Fastest way to count exact number of rows in a very large table?
  9. Key value pairs in relational database
  10. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  11. Splitting the string in sql server
  12. Need to list all triggers in SQL Server database with table name and table’s schema
  13. What is the purpose of constraint naming
  14. How can I do a BEFORE UPDATED trigger with sql server?
  15. Drop all tables command
  16. How to find a table having a specific column in postgresql
  17. can we list all tables in msaccess database using sql?
  18. INSERT COMMAND :: ERROR: column “value” does not exist
  19. Comma separated values in a database field
  20. Can SQL Server Express LocalDB be connected to remotely?
  21. What can cause an Oracle ROWID to change?
  22. SQL: Using NULL values vs. default values
  23. Why don’t DBMS’s support ASSERTION
  24. How do I change db schema to dbo
  25. What is the best way to implement soft deletion?
  26. PostgreSQL how to create a copy of a database or schema?
  27. Historical / auditable database
  28. Postgres: convert single row to multiple rows (unpivot)
  29. How to store a list in a db column
  30. Copy table structure to new table in sqlite3

Leave a Comment