1.1. TechSprint Solutions is a leading software development company specializing in creating
cutting-edge software solutions for businesses worldwide. Established in 2010, the company
has a proven track record of delivering high-quality, scalable software products tailored to
meet the unique needs of the clients. The employees are categorized as developers, designers,
project managers, and quality assurance professionals dedicated to delivering excellence in
every project undertaken. An employee may work on several projects, with each client
initiating many software development projects. A project may be assigned to orie manager.
who is an employee and a manager can manage several projects. There are however,
employees who do not manage any project, but works on those projects as employee. Each
project produces many software products but each software product can only be produced
through one project. Each software must be quality controlled by many quality control
professionals and it is possible for many quality controllers to quality control one software
product. The quality controlled software may be handed over to the client for deployment in
actual environment. Use this description of company's situation and answer the questions
that follow:
(a) What is the role of database life cycle (DBLC) in designing the database? Briefly
discuss steps in DBLC. How can this help in building TechSprint Solutions database?
(b) Create business rules from the description of the company's situation
(c) Create specialization hierarchies from the description above
(d) Create entity relationship diagram (ERD) from business rules in (b) and specialization
hierarchy in (c). For simplicity, only show primary and foreign keys