Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Softcraft Ltd . is a corporation involved in the design, development, and marketing of software products for a family of advanced personal computers. The list
Softcraft Ltd is a corporation involved in the design, development, and
marketing of software products for a family of advanced personal computers. The list of entities and the relationships among them are listed below. DRAW the ER diagram constructs for these entities and the associated relationships. State any assumptions.
The entities that this enterprise would be interested in includes:
Company:
Attributes: CompanyID Primary Key Name, Location, Contact Information
Software Product:
Attributes: ProductID Primary Key Name, Version, Description, Release Date
Development Team:
Attributes: TeamID Primary Key Team Lead, Number of Developers, Projects Assigned
Customer:
Attributes: CustomerID Primary Key Name, Contact Information
Sales Order:
Attributes: OrderID Primary Key Date, CustomerID Foreign Key
Development Project:
Attributes: ProjectID Primary Key Name, Description, Start Date, End Date, Budget
Employee:
Attributes: EmployeeID Primary Key Name, Position, Contact Information
The relationships among these entities are:
Company: Software Product :N because a company can have multiple software products
Development Team: Development Project M:N a development team can work on many projects and a project can have many teams working on it
Sales Order: Customer N:a customer can place multiple orders and a sales order belongs to one customer
Employee: Development Team M:N because an employee can be a part of multiple development teams and a development team can consist of multiple employees
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started