Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

IT IS VERY IMPORTANT TO READ THE INSTRUCTIONS!!! THIS IS DOCTORAL WORK. Turnitin and Waypoint are being used to check for plagiarism, and please use APA format. Please pay close attention I NEED...

1 answer below »
Jeremy Hudson
Marcus,
 
Thank for your post.  Keep with the Risk management theme scrum team fail that do not Plan Risk Response. In a recent study majority of respondents (57 %) think that this step is done during sprint planning. In sprint planning, the team through its knowledge contributes to the choice of optimal option for project risk, and then a risk implementation should be executed. 34% assert that daily scrum opens an interval where we can plan the newly identified and analyzed risk responses during the sprint(Chaouch et al., 2019).
 
Reference:
Chaouch, S., Mejri, A., & Ghannouchi, S. A XXXXXXXXXXA framework for risk management in scrum development process. Procedia Computer Science, 164, XXXXXXXXXX. https:
doi.org/10.1016/j.procs XXXXXXXXXX171Links to an external site.
Ho Choi
Marcus,
Good post.
I agree that the Scrum methodology would have help tremendously if the team followed it wholeheartedly. One thing that caught my attention was in your last paragraph, you mentioned the importance of the Scrum Master. That his/her role is "essential in removing obstacles". I believe this is the crux of the problem for ByteNinja. The Scrum Master or Project Manager in this case is the leader that directs the project. He is the one that oversees everything and makes sure that it will be completed on time and within budget and that the final outcome is met. If within the team, there is someone slacking off, it is the job of the project manager to go after that person and make sure that the slacking off stops and that the project gets back on track. That's why this role is so critical to the overall project. When the Project Manager does not live up to his duty, then for sure the project will not succeed.
I would not put all the burden on the Project Manager, but in the end, he will be liable for the final outcome. 
Martin Rock
Nowadays the rise and fall of software companies is common. Those who learned lessons from their previous failures succeed…The software industry also adopts new approaches with the change in technology and techniques. Agile methodology is one of the methods that help lead to the success of any software ( P. Emam Hossain, XXXXXXXXXXScrum is the framework of agile methodology as it focuses on day-to-day project management. For the ByteNinja team, adopting Scrum could significantly improve the delivery of the Kartastic Bites POS system project by addressing past issues and cu
ent objectives.
Scrum methodology provides a framework for achieving high-quality products by
eaking down the project into manageable pieces or sprints. Each sprint focuses on delivering a set of features or functionalities that meet the quality standards established by the team. At the end of each sprint, the team conducts a review to assess the quality of the deliverables and identify areas for improvement. Given the challenges faced by the team. 
Effective communication is essential as well for the success of the project. Effective communication involves generating, collecting, disseminating, and storing project information. It ensures that all team members and stakeholders are aware of project status, requirements, and changes. Effective communication also helps to identify and resolve issues early on, preventing them from escalating into major problems.
"Lack of communication or poor communication will invariably cause your Scrum team to fall apart…Team members must have clarity about their roles, responsibilities, their team's Sprint capacity, and the scope of the problem that needs to be solved. Having a clear idea about the dates that are important for the success of the product, the purpose of the product, the customer feedback, the action items from the Sprint Retrospective, etc. helps the entire team take shared ownership of the team's results" (Ravlani, 2019).
Adopting Scrum will not only help ByteNinja manage the development of Kartastic Bites' POS system more efficiently but also ensure the final product closely aligns with Sarah's needs through improved communication, transparency, and iterative evaluation. This approach positions ByteNinja to overcome previous challenges and achieve a successful project outcome.
 
Reference
2009. A. B. H.-y. P. Emam Hossain, "Using Scrum in Global Software Development: A Systematic Literature Review", 4rth IEEE International conference on Global Software Engineering, July 2009.
Ravlani, K. (2019, May XXXXXXXXXXways the scrum master can improve scrum team communication. Scrum Certification Training and Agile Coaching. https:
agileforgrowth.com
log/scrumteam-communication

Marcus Mccall
Integrating Scrum principles and practices includes solutions that describe the struggles in the software development teams. Scrum in the team can address challenges by highlighting Business Problem Scenarios and Programming Team Scenarios. As highlighted in the project, Communication is an essential aspect of Scrum and can help mitigate misalignment and ineffective collaboration. Daily Scrum meetings can help team members synchronize activities (Paul & Behjat, 2019). This will help discuss progress and provide a platform for transparent Communication. It ensures all stakeholders know about tasks, progress, and potential obstacles to create a collaborative environment. Task management can help in the development of Sprint Planning of Scrum. Sprint Planning in a team requires the selection of tasks from the product backlog. It includes clearly understanding priorities and achievable goals for upcoming sprints. The Sprint Review allows regular inspection of completed work. It provides opportunities to adapt and reprioritize tasks-based feedback from stakeholders. Quality assurance challenges must be addressed through the implementation of sprint retrospectives. It helps the team to reflect on past sprints to identify areas for improvement and implementation of solutions. This includes the implementation of refining processes and incorporating feedback loops.
The team can enhance quality assurance practices to reduce the occu
ence of software bugs and defects. Roles included in Scrum are Product Owner, Scrum Master, and Development Team. It can help establish responsibilities and accountabilities. It ensures a sense of ownership and empowerment in the team (Bhavsar, Shah & Gopalan, XXXXXXXXXXThe Scrum Master is essential in removing obstacles that can hamper progress. This ensures that the team can focus on delivering value. ByteNinja can transform the software development approach, which will help implement better Communication, task management, and quality assurance practices. It includes regular iterations and feedback loops that allow the team to overcome challenges. It will help the project develop a POS system for Kartastic Bites.
 
References:
Bhavsar, K., Shah, V., & Gopalan, S XXXXXXXXXXScrum: An agile process reengineering in software engineering. International Journal of Innovative Technology and Exploring Engineering, 9(3), XXXXXXXXXX.
Paul, R., & Behjat, L. (2019, June). I am using principles of SCRUM project management in an integrated design project. In The 15th International CDIO Conference.
Answered 3 days After Oct 06, 2024

Solution

Shubham answered on Oct 10 2024
6 Votes
Running head: ConstructCo Database Design Project
ConstructCo Database Design Project
ISM641
Database Design and Management
Student Name
Date
Table of Contents
3Document History
4Executive Summary
5Conceptual design (ERD creation)
6Normalization
7Physical Design
8Data Retrieval
9Stored Procedures and functions
10References
    Document History
    Version #
    Date
    Revised By
    Reason for change
    1.0
    Initial draft
    
    Initial draft
Executive Summary
The purpose of the report is to present design and development of database system. It describes about needs of ConstructCO for tracking and managing workstations, software installations and licenses. This can manage employee-related information. The project aims to improve ability of company to manage its IT assets. It will ensure use of resources and compliance with software licensing policies. The database system has been designed to meet set of defined business rules. This requires focusing on management of hardware assignments, configuration tracking, employee information and license management. The database system will track assignment of workstations to employees. It will ensure that every employee is assigned only one workstation that includes desktop PC and laptop. The tracking is important for effective resource management. It will allow ConstructCO to keep record of employees that are using hardware that has been assigned and located in the organization. It is important for maintaining operational efficiency for ensuring that each department is equipped with the necessary hardware. The study also describes about workstations. The database can track critical hardware specifications like memory, disk space and CPU speed for each workstation. The capability enables company to maintain accurate inventory of workstation configurations. It includes timely hardware upgrades and replacements that are requires. As hardware gets old and the ability of system to track the date of purchase will help company plan for future IT needs. This will ensure that older workstations are replaced and upgraded to meet changing demands of employees and departments.
The system is also designed to track detailed employee information including employee ID, names, titles, hire dates, salaries and department affiliations. The roles of employees that are categorized by titles such as associate, lead and manager. This will determine workstation needs and the type of software that require to perform the jobs. This requires integrating employee data with workstation and software tracking system. The company can ensure that hardware and software resources are distributed based on job requirements and departmental needs that will help in improving overall productivity. The major feature of the database is the tracking of software installations and the types of licenses associated with the software. The system monitors that software is installed on workstations and captures the type of license used. This is named user license, volume license and concu
ent license. This feature ensures that company remains compliant with software license agreements that will help in preventing unauthorized usage and overuse of licensed software. The system keeps track of expiration dates of licenses that will allowing ConstructCO to manage renewals proactively and avoid inte
uptions in software availability. The design also focuses on need for accurate and up-to-date tracking of workstation assignments that may differ from purchase date of workstation. In tracking workstations are assigned to employees. The company can better manage allocation of hardware resources and avoid situations for workstations that are underutilized and assigned inappropriately.
In supporting efficient operations and the database design includes ability to generate reports that help managers. Department heads make informed decisions regarding hardware and software usage. The report includes details like age of workstations, workstation assignments to specific employees and departments along with software license usage and distribution of IT resources in the company. In the conclusion, the database design presented in the report is the solution that will improve ability of ConstructCO to manage its IT assets. This will ensure proper workstation allocation, software compliance and hardware configuration tracking. The capabilities of system will enhance operational efficiency and reduce risk of hardware obsolescence and software non-compliance. It can help in supporting long-term goals of company for growth and technological advancement. This is well-integrated solution is expected to
ing about efficient IT resource management and better alignment of hardware and software resources with employee roles and departmental needs.
Conceptual design (ERD creation)
In the development of robust conceptual model and entity-relationship diagram for database design project. It is based on business rules provided and it is important to identify key entities, attributes, primary keys and relationships. The goal is to ensure the design and follows specifications, tracks necessary information and maintains referential integrity.
Identifying the Entities and Attributes
Based on business rules and this includes entities that includes:
1. Employee: Captures employee information.
· Attributes: EmployeeID (Primary Key), Firstname, Lastname, Title, DateOfHire, Salary, Department.
· Notes: The Title attribute is important to determine if an employee is an associate, lead and manager. The Department attribute will store values like accounting, research, QA, operations, HR, and administration.
2. Workstation: Represents the workstations that are desktop PCs and laptops in the organization.
· Attributes: WorkstationID (Primary Key), Type (Desktop or Laptop), Location, DateOfPurchase, Memory, DiskSpace, CPUSpeed.
· Notes: This entity captures the technical specifications and location of the workstation.
3. Software: Tracks software installed on a workstation.
· Attributes: SoftwareID (Primary Key), Name, Version, InstallationDate, LicenseType, ExpirationDate.
· Notes: LicenseType is critical and includes named user, volume and concu
ent licenses. The ExpirationDate ensures system tracks license validity (Bjeladinovic, 2018).
4. Assignment: Tracks which workstation is assigned to when employee and when the assignment occu
ed.
· Attributes: AssignmentID (Primary Key), EmployeeID (Foreign Key), WorkstationID (Foreign Key), DateOfAssignment.
· Notes: This entity connects employees with workstations. It ensures that only one workstation is assigned to an employee and that the assignment date is recorded.
5. License: Captures information about software licenses.
· Attributes: LicenseID (Primary Key), LicenseType, NumberOfInstallationsAllowed, NumberOfInstallationsInUse, ExpirationDate.
· Notes: This entity ensures the system tracks license usage.
Identifying Primary Keys
Primary keys are used to uniquely identify each record in the table:
· Employee: EmployeeID
· Workstation: WorkstationID
· Software: SoftwareID
· Assignment: AssignmentID
· License: LicenseID
Defining Relationships Between Entities
1. Employee and Assignment:
· Relationship: One-to-One.
· Explanation: Each employee is assigned only one workstation but workstation can be reassigned to another employee over time. The Assignment entity manages this relationship.
· Keys: EmployeeID is a foreign key in the Assignment entity that can help in establishing a relationship between an employee and the assigned workstation.
2. Workstation and Assignment:
· Relationship: One-to-Many.
· Explanation: A workstation can be reassigned to multiple employees over time, but at any given time and it is only assigned to one employee. The Assignment entity tracks the history (Khan et al. 2023).
· Keys: WorkstationID is the foreign key in the Assignment entity that helps in linking workstation to the employee is assigned.
3. Workstation and Software:
· Relationship: One-to-Many.
· Explanation: The workstation can have multiple software programs installed. The Software entity tracks which software is installed on the workstation.
· Keys: WorkstationID is the foreign key in the Software entity and this can help in linking software record to specific workstation.
4. Software and License:
· Relationship: Many-to-One.
· Explanation: Multiple software installations can share the same license. The License entity manages information about different types of licenses and the usage limits.
· Keys: LicenseID is the foreign key in the Software entity that requires linking each software installation to co
esponding license.
5. Workstation and License:
· Relationship: Many-to-Many (via Software entity).
· Explanation: This relationship is established through the Software entity. This helps in connects with workstation to license used for the installed software.
Additional Considerations
· License Expiration Tracking: The system should include mechanisms to monitor license expiration through ExpirationDate attribute in both the License and Software entities. This ensures that...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Looking For Homework Help? Get Help From Best Experts!

Copy and Paste Your Assignment Here