Make an ERD Pick and Shovel Construction Company is a multi-state building contractor specializing in medium-priced town homes. Assume that Pick and Shovel’s main entities are its customers, employees, projects and equipment. The attributes of customer are its id, name, DOB, age which is derived from DOB, phone and CNIC. Employees can have an address which is saved as a decomposed attribute, more than one skills, employee number and name. A customer can hire the company for more than one project, and employees sometimes work on more than one project at a time. Project can be specified as its duration and scope. Equipment no, details and bought date are the main qualities of equipment. Equipment, however, is assigned to only one project at a time. Draw an ERD showing those entities.
Concepts in Designing Database
A database design is the process of data organization based on a database model. The process deals with identifying what data should be stored in a database and how data elements relate to each other.
Entity Relationship Diagram
Complex real-world applications call for large volumes of data. Therefore, it is necessary to build a great database to store data safely and coherently. The ER data model aids in the process of database design. It helps outline the structure of an organization’s database by understanding the real-world interactions of objects related to the data. For example, if a school is tasked to store student information, then analyzing the correlation between the students, subjects, and teachers would help identify how the data needs to be stored.
Make an ERD
Pick and Shovel Construction Company is a multi-state building contractor specializing in medium-priced town homes. Assume that Pick and Shovel’s main entities are its customers, employees, projects and equipment. The attributes of customer are its id, name, DOB, age which is derived from DOB, phone and CNIC. Employees can have an address which is saved as a decomposed attribute, more than one skills, employee number and name. A customer can hire the company for more than one project, and employees sometimes work on more than one project at a time. Project can be specified as its duration and scope. Equipment no, details and bought date are the main qualities of equipment. Equipment, however, is assigned to only one project at a time. Draw an ERD showing those entities.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
