Design an ERD representing the database for a car Doctor who needs it to supports its operations in its three locations in central Illinois.(see problem)
click to see ERD
Project Description this is a continuation of Phase 1 project (see problem)
- Relational Schema
click to see the schema
click to see explanation
- This is a relation with no multivalued attributes and each row is unique, hence it is in 1NF .
- Even though they are bridge entities with composite keys for PARTUSED and INVENTORY however there is no Partial dependency because in these two entities the values of the non-key attributes for each entity is determine by the respective composite key , hence functional dependencies.
- There is no transitive dependency in any of the table. Since the table is in 1NF ,2NF and no transitive dependency, we conclude that the table is in 3NF. (It is also important to see that the License plate number does not identify the license state rather it will be the plate number only that is why no transitivity here.)
click
qestion 3, 5, 6, 7 refer to Phase 2 querry.sql
Problem description (see problem)
- Querry solutions are in phase 3 querry.sql
Problem description (see problem)
- Querry for all problems in above link are in the Joins Asg8.sql file
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent