Database Project Proposal
Database Project Proposal
Proposal Title:Grocery Store Database Management Project Proposal
Title:
H-Soft Software Solutions
List of project leader and project members withinstitutional affiliations
Devaraj Tadishetty, *+1 (610) 864-2763, 26241 Lakeshore Blvd Euclid Ohio, USA. 44132. devaraj.tadishetty555@gmail.com
Submitted to:Dr. Cheng for IST 634 (Enterprise Databases) Summer Term 2022 Project
Proposal date: 07/10/2022
Topic Research and Executive Summary
The grocery management system is an application aimed at increasing the efficiency of running small to medium-sized grocery stores. This system consists of a database and an application that allows the user to enter all the records that they have received. Upon reception of items and entering into the system as an inventory, whenever there is a purchase made that takes items out of the store, it is also recorded by the system. This allows the store owner to keep track of items that come in and out of the store.
The system can separate users based on the hierarchical levels of system privilege. There are three levels of privilege available in the system. The administrator, the manager, and the clerk. A user, such as another administrator, manager, or clerk, may be created by the administrator and assigned a fitting security clearance or authentication. The manager, on the other hand, has only the privilege to read data system-wide and limited writing access. The manager can create new clerk accounts with limited privileges and cannot create new manager accounts or delete existing manager accounts as those are the domains of the administrator. The clerk on the other hand has very limited access to reading and writing data, limited to interactions with the customer only. Such may be serving customers in storefront operations.
The benefit of this system is an enhancement of accountability and service delivery in a seamless time and energy-efficient way. We invite you to try our systems for a week as a part of a pilot program and if you are happy with it, we would be happy to install the systems for you as well as offer you a half-price system lifetime support to ensure that your business runs as smoothly as possible and maximizes on profit.
Statement of work
Project Description:
H-Soft is a software company that deals with the creation of business and database operations software that aids in the running and maintenance of various small to mid-size business operations. H-Soft has several customers and software in its portfolio, such as the grocery management system which is our flagship project aimed at small to mid-size grocery stores. The purpose of this software is to ensure that the grocery stores have an easy time running their systems and turn a profit most efficiently. The mission of our company is to ease business operations and maximize profits. This is done by streamlining business operations to the point of minimizing losses by employing quality software products that are built on efficiency. This is in line with our vision of making human work easier by leveraging our software products and practices to make the running of your business as smooth and hassle-free as possible. Achievement of such goals is watch keeps us motivated and striving to provide the best software experiences to the customer which in turn eases the business operations and life of the business owner and the consumer. The grocery store system is an application combining a front end and a database to assist in the management and operations of a small to medium-sized store. The system is aimed at these types of businesses as they are the most in need of systems that ensure that there is no proliferation. The main of time and resources in terms of money or goods lost from the inventory. In the achievement of such a goal, we must look at why such a problem exists in the first place. Within most small businesses, there is the assumption that, since we are a relatively small operation, there is no need to have systems in place, as they are an unnecessary complication of matters. However, this is the problem as without proper problems, you cannot track what goes in or out of the business easily. Taking down things by hand only does not help you to build a proper inventory with all the data that you need, nor will a mere cash register help you keep track of every single dollar that flows through your business. That is why the store management system comes in handy to eliminate such problems, by assisting you to take in inventory as well as note every purchase or outgoing movement of both cash and cargo. To provide a system that will increase throughput, employ a high-efficiency level and a user-friendly system to access users. This will ensure a profitable and competitive advantage tool for most businesses.
Challenges:
However, every unique customer presents a unique set of challenges to be dealt with accordingly to ensure that their business runs well. The main challenge that we usually face as a business that develops software systems is the customization of the software as most times, a one size fits all approach does not work and the software needs to be tailored to the needs of the customer. This is important as it helps the customer work better at operating their business. Luckily for us, as we are skilled at what we do, we have developed different strategies to deal with these situations in ways that ensure maximum results for the software and the customer that will use it to run their business. The main strategy is constant communication with the customer, to make sure that we are on the same page and that we understand each other perfectly and work towards the same goals. This helps in ensuring that what was planned and communicated is what is delivered.
Project Management Approaches, Schedule, and Milestones
Another strategy pertains to our preferred software development mechanism, which is the agile method. Agile methodology is where the system has taken into consideration the user requirements and iteration criteria to accomplish the objectives of the system. To ensure that the system enables the users to accomplish their tasks and goals as it uses the user input and developed on the iteration as testing is done severally from the user requirements and iteration.
The agile development process is dominated by the iterative process. Iterations are usually two or four weeks in length and have affixed completion time to enhance the scope of the system. Due to its time-bound nature, the iteration process is methodical and the scope of iterations is only as broad as the allotted time allows.
The multiple iterations took place during the agile development life-cycle and each followed its workflow. During iteration, the customers and business stakeholders must provide feedback to ensure that the features meet their needs.
For the success of the project, it is important that is scheduled in a way that favors all the parties that are working on it. To achieve proper project scheduling, we have always employed the use of division of labor and specialization as well as the use of smart tools such as the Gantt chart to make sure that we can quantify our daily progress and hit our targets and milestones, which are essential for project success [2]. Each member of our team has a specific role to play within the development period of the system, with each taking a lead at different times of the system development lifecycle.
Below is the roadmap for the development and deployment of the software.
Aside from the roadmap, we are also highly organized in development of our plans, as can be seen by the Gantt chart below that we use to develop and plan the work needed to be done over the time period that we have.
Methodology and Implementation Plan
During this time of the development process, we study the business in question for two weeks in its operations without the use of our software. Studying the business model and its operations allow us to understand better the needs of the business and the niche within which it exists. This understanding allows us to know the requirements for the system and how we can customize it further, ensuring that the business will perform at its optimum using the software. After the studying the business model employed by the said business, we go on to the second period of development
In order to have enough information to develop the system, collection of data is important. As we directly observe the companys operations, our main sources of data collection is through observation. I surveyed the store that requires the system to observe the challenges of the current system that helped me design a system that solved various problems facing current system. I also checked on the security and user interfaces of the current system through observation method. This was achieved by recording events that perform and check on the guide and protocols applied in the institution.
I had to interview both the customers or users and the staff using the system because they are the entities involved in the daily tasks of the system. I also interviewed the stakeholders to gather more information on the system they propose to have so as I could meet their requirements too during my design.
In terms of the system development methodology, we had chosen to use agile methodology. Agile methodology has multiple iterations taking place during the agile development life-cycle and each follows its own work-flow. During iteration, it is important that the customers and business stakeholders provide feedback to ensure that the features meet their needs.
The iteration process flow;
Requirements: defining requirements for the iteration based on studying the business model, customer and stakeholder feedback.
Development: designing and developing the system based on the requirements from both users and stakeholders.
Testing: this is by checking on Quality Assurance (QA) testing, internal and external training and documentation development of the system as a whole.
Delivery: integrate and deliver the working iteration into production for the functionalities in the organization or institution.
Feedback: accept customer and stakeholder feedback and work it into the requirements of the next iteration.
In this agile methodology I implemented live demonstrations, daily testing on functionalities, sharing of feed-backs and in all I had to remain agile that means that I was making changes to my process based on the feedback of customers and stakeholders to ensure each iteration improves the last to ensure system functions as required from the users and stakeholders. I had also employed testing of system until an acceptable income was achieved from which I developed the store management system. This method had allowed me to interact with end user that is customers and administration as this system requires a lot of interactions with end users on interfaces.
I used agile methodology because its more flexible, productive, transparent, optimization and reduced risks on the system being developed [3]. In agile methodology there is faster implementation of solutions, minimization of resources, adaptable to changes and optimized development processes. With the use of iteration and testing in each case it provides a system that satisfies both users and stakeholders as a better output is achieved.
The logical development phase commences after the studying of the business, and we have developed specifications for the software. In this regard, we have elected to go with the Microsoft Access database as it would be the most convenient for use in this scenario. The reasons for use of the MS Access database are as below.
Portability is a characteristic that many users appreciate. Similar to an Excel file, portability refers to how easily something can be moved or copied [1]. It is simple to duplicate the database for other needs, as in a project, or to copy to different places because an Access application is in one file (but need not be). Although this function may make IT staff cringe, users often appreciate it because it offers a lot of freedom. Many people appreciate how easy Access is to comprehend and how flexible it is once they start using it.
There have been more than 25 years of MS Access. Predictions of Microsoft's collapse have been vastly overblown, even though the product hasn't improved much throughout the past ten years. It continues to be the sixth most well-liked relational database, according to DB-engines.com. I still provide support for numerous deployed Access databases at client locations, and they continue to fulfill their intended function.
Expected Results: The Deliverables
The expectation for the system is that the business will meet the main and specified objectives laid out. In meeting this objective, we treat the system as a mature system and it is released to the business owner for operations.
Personnel
Project Manager: Devaraj Tadishetty
Email: devaraj.tadishetty555@gmail.com.
This is Devaraj Tadishetty, and this project was done by myself, I have done my tasks by myself dividing it according to my strengths and weak areas. It helped me to complete the project in a good manner.
As the project lead, I am skilled in database creation and operations in Microsoft Access. Creation of software application based on Visual Basic is also a staple of what I do. I can be reached through my personal email, devaraj.tadishetty555@gmail.com.
Supporting Facilities
The completion of this project was aided by both development and documentation tools. Visual Studio, Microsoft Access, and Microsoft Word for the documentation of the project. We used Windows Operating System 10 for the development and documentation of the system.
References
[1] M. Alexander and D. Kusleika, Access 2019 bible. Indianapolis, IN: John Wiley & Sons, Inc., 2019.
[2] R. Murch, Project Management: Best practices for IT professionals. Upper Saddle River, NJ: Prentice Hall, 2011.
[3] M. Fishpool and B. Fishpool, Software development in practice. British Computer Society, 2020.
Report 1
Project Manager: Devaraj Tadishetty
Address & Contact NO.: +1 (610) 864-2763, 26241 Lakeshore Blvd Euclid Ohio, USA. 44132.
Email: devaraj.tadishetty555@gmail.com
Research detail
The Grocery Store Database Management research project aims to research the viability and application of a database system to grocery stores in a way that will help the grocery store owners streamline their operations to minimize resources used and maximize profits accrued. The database system in question that is chosen by the researcher is the Microsoft Access database management system. Microsoft Access is an application that is bundled alongside Microsoft Office Suite. The Microsoft Access system is the most desirable for this system for its following characteristics and advantages over other database systems.
Simplicity. Microsoft Access is fairly simple to use as compared to other database management systems. As long as you have Microsoft Access installed, you can create and manage your database systems with ease. Its learning curve is fairly gentle and well-explained walkthroughs and tutorials available from the official Microsoft sites.
Support. As a product of Microsoft office suites, Microsoft access enjoys long-term support employed by Microsoft itself. This means that your database will be fairly stable and well supported by the manufacturer for a long time to come. It also has a great online community that helps in troubleshooting issues.
Portability. Portability refers to how easily something can be moved or copied. It is simple to duplicate the database for other needs, as in a project, or to copy to different places because an Access application is in one file.
After the database has been developed, we seek to test it by exposing it to a real-life scenario in the operation of the business to confirm its viability to the business. There is also the development of an accompanying application which will assist the business in creating an interface that the user can interact with easily and manipulate or access data.
Mission Statement (7/12/2022)
Regarding this current project, our mission statement of quality and efficiency shines through as we seek to deliver software that works to expectations while being light enough and less resource intensive.Support DialogueDeveloper: What is your current system and how do you operate it on a normal day to day business basis? What functions does it serve?
Grocery Manager: On normal days, we have the cash register that helps us keep track of purchases from the store, while we have a ledger book to record our inventory, as it is delivered to us.
Developer: Is your current system serving you well enough? Would you consider an upgrade? And what kind of flaws does it have that most affect your business?
Grocery Manager: Our biggest challenge is on the human error side as some items do not get recorded or go missing totally. The calculations are also difficult and time consuming and we would prefer a more digital or automatic system.
Mission Objectives (7/14/2022)
The mission objectives for the database system are as follows:
Allow recording of inventory
Allow report features to know purchases made on daily basis
Show different trends in products
Allow different users and permissionsSupport Dialogue
Developer: What kind of data would you want the system to keep track of?
Grocery Manager: Basically, the shops daily operations, purchases going out and inventory coming in. We would also want to know how much stock we have and at least maybe get warnings or alerts if our stock is running low
Developer: Anything else you can think of to be added to the database
Grocery Manager: We would appreciate having various types of reports over time to have a way of predicting and forecasting on the business. So we would appreciate a report generation feature
List of subjects (7/18/2022)
Employee
Customer
Product
Supplier
Sales
Users
Receipt
Registers
List of characteristics (7/18/2022)
Employee Address
Employee name
Employee ID
Customer ID
Customer name
Customer order
Product Manufacturer
Product ID
Product Name
Supplier Name
Supplier Address
Supplier ID
Sales Report
Sales ID
Sales Tax
User First Name
User ID
User Last Name
Receipt ID
Receipt Amount
Receipt Time
Register Number
Register ID
Register Name
Support Dialogue
Developer: How do you update your records to reflect the most recent transactions
Grocery Manager: Given our ledger book, we take half an hour after we close down to recap all that we had done that day and correct errors. Although this method is time consuming and not convenient, we have no other options
Preliminary Field List (7/19/2022)
Employee Address
Employee name
Employee ID
Customer ID
Customer name
Customer order
Product Manufacturer
Product ID
Product Name
Supplier Name
Supplier Address
Supplier ID
Sales Report
Sales ID
Sales Tax
User First Name
User ID
User Last Name
Receipt ID
Receipt Amount
Receipt Time
Register Number
Register ID
Register Name
Final Preliminary Field List (7/20/2022)
Product Sales
Employee name
Employee ID
Employee Address
Employee Rank
Customer ID
Customer name
Customer last
Customer Shipping Address
Product ID
Product Name
Product Quantity
Customer Shipping Address
Sales total amount
Supplier Address
Supplier Product
Calculate Field List (7/21/2022)
Quantity Stock
Total Amount
Sub total Amount
Total Taxes
Maximum sales
Minimum sales
Value Field list (7/21/2022)
Stock
Register
Computer
Coolers
Preliminary table list (7/22/2022)
Employee
Customer
Product
Supplier
Sales
Users
Final Table List (7/22/2022)
Name Type Description
Employee Data Details pof the people who work within the store including names, Ids, addresses
Customer Data Details of people who are served by the store, may include names, ids, addresses, phone numbers
Product Data Items that are delivered to the store and stored as inventory or sold as products
Supplier Data Companies or people that serve the store by delivering products to the store
Sales Data Collection of all the items that have already been sold by the store
Users Data Collection of all the people who have permission to access various levels of the store or database system
Permissions data Attributes that define which user can access which part of the database and which parts are out of bounds for them
Database Table Structure (7/23/2022)
Employee
Employee address
Employee ID (PK)
Employee Name
Customer
Customer ID (PK)
Customer Name
Customer Order
Sales
Sales Report
Sales ID (PK)
Sales Tax
Product
Product ID (PK)
Product Name
Product Quantity
Supplier
Supplier ID (PK)
Supplier Name
Supplier Address
Receipt
Receipt Time
Receipt Amount
Receipt ID (PK)
User
User ID (PK)
User First Name
User Last Name
Support Dialogue
Developer: Who works in the store and how do you record their data and who they have served
Grocery Manager: As stated earlier, we make use of a cash register, as we have one available. It prints out who has been serving the customers, although that is not fool proof. It has its disadvantages. The ledger book also helps in recording movement of inventory.
Implementation details (7/23/2022)
Research implementation has been done through data collection methods. Direct data collection is favored over indirect data collections as we are on site which allows us to be the firsthand interaction or entry point for the preferred data. The chosen data collection method is the performance of interviews and observations. Observation was chosen as it allows us to monitor the business in its natural surrounding without us creating any interferences that would hinder the observation process or creating any pretenses in the environment that would bias or mislead the data. The method of observation is chosen because of the following reasons.
Independent of People's Desire to Report:
Observation does not depend on people's willingness to divulge personal details. Many people find it difficult to talk about themselves with an outsider. Some folks don't have the time or the necessary abilities to give the researcher crucial information. Even if observation cannot always solve these issues, it nevertheless demands less active participation and willingness from the subjects. It is always feasible to observe without the subjects' awareness.
Very Accurate:
The researcher must rely on the data that have been collected when using alternative methods, such as an interview or questionnaire. These are therefore indirect approaches, and the investigator is unable to check the veracity of the information they have provided. However, during observation, the observer can immediately verify the observers correctness. He can use a variety of tools to check the consistency of their behavior. The data gathered through observation is frequently more accurate than that gathered through questionnaire or interview.
The observation was carried out by arrival at the business and set up of our equipment and personnel to observe how the business runs and to record their observations as appropriately. Observation included looking at what times the business is most busy and what times it is least busy and how it affects the running of the store and its database. Questions answered were whether the business would slow down upon being busy and loads subjected to the database or it would still operate as optimum.
The second method of data collection employed was the use of interviews. Interviews are mostly one on one discussions with various individuals to know how they feel about a particular subject matter, in this case, the existing system and business methodology in service at the store. This method was chosen to allow us read more into the interviewees feelings, as in line with the advantage of using interviews below.
Observe your feelings and actions:
Without a doubt, face-to-face interviews can document an interviewee's feelings and actions. Online and mobile polls cannot accurately capture unfiltered emotions and behavior, much like verbal and nonverbal questions cannot be captured.
Precise screening:
The screening process is made more accurate through in-person interviews. The interviewee is unable to give false answers in response to screening inquiries about gender, age, or ethnicity. In web and mobile surveys, screening questions can be avoided. Offering rewards in online and mobile polls may inadvertently encourage answer fabrication. In order to finish the survey and receive the reward, people could input false demographic data. Even if the individual's responses are all accurate, the data will still be unreliable and deceptive when used for data analysis.
Interviews conducted with all business stakeholders shed light on what each considers important in the business and helped us determine priority areas of the system. Given this information, we wrote a requirements specification document to guide us through the development phase of the database.
Application Implementation (7/24/2022)
Environment setup:
The application needs to run on Windows operating system as it is the operating system used in store. It is also a versatile and popular operating system which ensures that if there are hardware changes, the application will still be able to run with minimal issues. To this requirement, we elect to use C# as the language of choice to build the application with. In order to build the application, there is need to correctly set up the environment with which we will use, which is Microsoft Visual Studio Community. We download the application from official Microsoft sources and add components that allow us to build the application efficiently.
Building the GUI:
We have chosen to use Windows forms as the method of building our graphical user interface for the application. Windows Forms, a controlled framework that was first introduced in 2002, is the oldest and most popular desktop technology based on the Windows graphical device interface (GDI) engine. It provides a fluid drag-and-drop environment for Visual Studio user interface development. Making visual components from code isn't simple because Windows Forms relies on the Visual Studio Designer as the primary tool for UI development. The key features of Windows Forms are enumerated in the list below:
It is mature technology with a ton of documentation and code samples, which makes development that much easier as you are bound to get sufficient support and troubleshooting.
Effective and powerful designer. Designing UI "from code" is not very practical. This allows you to envision the UI as you need it be and drag and drop features in a way that makes it easier to accomplish the UI goals
Because of the drag-and-drop capabilities of the designer, it is simple and easy to learn.on any Windows version supported.
Field Specification Document (7/24/2022)
A field specification document defines a field specification for each field in the database. It helps to establish field-level integrity by ensuring that the data is consistent, valid, and as free from errors as possible
Table Matrix (7/30/2022)
The Table Matrix helps us identify various tables and how they relate with each other within the database and its intended daily operation in the system. In the table matrix, relationships are represented as below:
1:1 One to One
1: N One to Many
N:1 Many to One
Relationships, Public Key and Table Structure (7/31/2022)
The public and foreign keys existing in the table structures below can be denoted with the symbols as:
PK-Primary Key:
A primary keys main features are:
It must contain a unique value for each row of data.
It cannot contain null values.
Every row must have a primary key value.
A primary key might use one or more fields already present in the underlying data model, or a specific extra field can be created to be the primary key.
FK-Foreign Key:
A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables
View Specifications
113775129484General Information
00General Information
Name: Type: Data Aggregate Validation
Description:
1136651795569Basic Table
00Basic Table
11366550165Calculated Field Expression
00Calculated Field Expression
Field Name Expression
11303054822Filter
00Filter
Field Name Condition
Business Rule Specifications
113775129484Rule Information
00Rule Information
Statement:
Constraint:
Type:
Database Oriented
Application Oriented Category:
Field Specific
Relationship Specific
Test On:
Insert
Update
Delete
1137751905939Structures affected
00Structures affected
Field Name:
Table Name:
11377576448Field elements affected
00Field elements affected
Physical elements
Data Type Length Character Support
Logical elements
Key Type
Key Structure
Uniqueness Null Support
Values Entered By
Required Value Range of Values
Edit Rules
11377550607Relationship Characteristics allowed
00Relationship Characteristics allowed
Deletion Rule Type of Participation Degree of Participation
11272646686Action Taken
00Action Taken
Database Project Proposal
Proposal Title:Grocery Store Database Management Project Proposal
Title:
H-Soft Software Solutions
List of project leader and project members withinstitutional affiliations
Devaraj Tadishetty, *+1 (610) 864-2763, 26241 Lakeshore Blvd Euclid Ohio, USA. 44132. devaraj.tadishetty555@gmail.com
Submitted to:Dr. Cheng for IST 634 (Enterprise Databases) Summer Term 2022 Project
Proposal date: 07/10/2022
Topic Research and Executive Summary
The grocery management system is an application aimed at increasing the efficiency of running small to medium-sized grocery stores. This system consists of a database and an application that allows the user to enter all the records that they have received. Upon reception of items and entering into the system as an inventory, whenever there is a purchase made that takes items out of the store, it is also recorded by the system. This allows the store owner to keep track of items that come in and out of the store.
The system can separate users based on the hierarchical levels of system privilege. There are three levels of privilege available in the system. The administrator, the manager, and the clerk. A user, such as another administrator, manager, or clerk, may be created by the administrator and assigned a fitting security clearance or authentication. The manager, on the other hand, has only the privilege to read data system-wide and limited writing access. The manager can create new clerk accounts with limited privileges and cannot create new manager accounts or delete existing manager accounts as those are the domains of the administrator. The clerk on the other hand has very limited access to reading and writing data, limited to interactions with the customer only. Such may be serving customers in storefront operations.
The benefit of this system is an enhancement of accountability and service delivery in a seamless time and energy-efficient way. We invite you to try our systems for a week as a part of a pilot program and if you are happy with it, we would be happy to install the systems for you as well as offer you a half-price system lifetime support to ensure that your business runs as smoothly as possible and maximizes on profit.
Statement of work
Project Description:
H-Soft is a software company that deals with the creation of business and database operations software that aids in the running and maintenance of various small to mid-size business operations. H-Soft has several customers and software in its portfolio, such as the grocery management system which is our flagship project aimed at small to mid-size grocery stores. The purpose of this software is to ensure that the grocery stores have an easy time running their systems and turn a profit most efficiently. The mission of our company is to ease business operations and maximize profits. This is done by streamlining business operations to the point of minimizing losses by employing quality software products that are built on efficiency. This is in line with our vision of making human work easier by leveraging our software products and practices to make the running of your business as smooth and hassle-free as possible. Achievement of such goals is watch keeps us motivated and striving to provide the best software experiences to the customer which in turn eases the business operations and life of the business owner and the consumer. The grocery store system is an application combining a front end and a database to assist in the management and operations of a small to medium-sized store. The system is aimed at these types of businesses as they are the most in need of systems that ensure that there is no proliferation. The main of time and resources in terms of money or goods lost from the inventory. In the achievement of such a goal, we must look at why such a problem exists in the first place. Within most small businesses, there is the assumption that, since we are a relatively small operation, there is no need to have systems in place, as they are an unnecessary complication of matters. However, this is the problem as without proper problems, you cannot track what goes in or out of the business easily. Taking down things by hand only does not help you to build a proper inventory with all the data that you need, nor will a mere cash register help you keep track of every single dollar that flows through your business. That is why the store management system comes in handy to eliminate such problems, by assisting you to take in inventory as well as note every purchase or outgoing movement of both cash and cargo. To provide a system that will increase throughput, employ a high-efficiency level and a user-friendly system to access users. This will ensure a profitable and competitive advantage tool for most businesses.
Challenges:
However, every unique customer presents a unique set of challenges to be dealt with accordingly to ensure that their business runs well. The main challenge that we usually face as a business that develops software systems is the customization of the software as most times, a one size fits all approach does not work and the software needs to be tailored to the needs of the customer. This is important as it helps the customer work better at operating their business. Luckily for us, as we are skilled at what we do, we have developed different strategies to deal with these situations in ways that ensure maximum results for the software and the customer that will use it to run their business. The main strategy is constant communication with the customer, to make sure that we are on the same page and that we understand each other perfectly and work towards the same goals. This helps in ensuring that what was planned and communicated is what is delivered.
Project Management Approaches, Schedule, and Milestones
Another strategy pertains to our preferred software development mechanism, which is the agile method. Agile methodology is where the system has taken into consideration the user requirements and iteration criteria to accomplish the objectives of the system. To ensure that the system enables the users to accomplish their tasks and goals as it uses the user input and developed on the iteration as testing is done severally from the user requirements and iteration.
The agile development process is dominated by the iterative process. Iterations are usually two or four weeks in length and have affixed completion time to enhance the scope of the system. Due to its time-bound nature, the iteration process is methodical and the scope of iterations is only as broad as the allotted time allows.
The multiple iterations took place during the agile development life-cycle and each followed its workflow. During iteration, the customers and business stakeholders must provide feedback to ensure that the features meet their needs.
For the success of the project, it is important that is scheduled in a way that favors all the parties that are working on it. To achieve proper project scheduling, we have always employed the use of division of labor and specialization as well as the use of smart tools such as the Gantt chart to make sure that we can quantify our daily progress and hit our targets and milestones, which are essential for project success [2]. Each member of our team has a specific role to play within the development period of the system, with each taking a lead at different times of the system development lifecycle.
Below is the roadmap for the development and deployment of the software.
Aside from the roadmap, we are also highly organized in development of our plans, as can be seen by the Gantt chart below that we use to develop and plan the work needed to be done over the time period that we have.
Methodology and Implementation Plan
During this time of the development process, we study the business in question for two weeks in its operations without the use of our software. Studying the business model and its operations allow us to understand better the needs of the business and the niche within which it exists. This understanding allows us to know the requirements for the system and how we can customize it further, ensuring that the business will perform at its optimum using the software. After the studying the business model employed by the said business, we go on to the second period of development
In order to have enough information to develop the system, collection of data is important. As we directly observe the companys operations, our main sources of data collection is through observation. I surveyed the store that requires the system to observe the challenges of the current system that helped me design a system that solved various problems facing current system. I also checked on the security and user interfaces of the current system through observation method. This was achieved by recording events that perform and check on the guide and protocols applied in the institution.
I had to interview both the customers or users and the staff using the system because they are the entities involved in the daily tasks of the system. I also interviewed the stakeholders to gather more information on the system they propose to have so as I could meet their requirements too during my design.
In terms of the system development methodology, we had chosen to use agile methodology. Agile methodology has multiple iterations taking place during the agile development life-cycle and each follows its own work-flow. During iteration, it is important that the customers and business stakeholders provide feedback to ensure that the features meet their needs.
The iteration process flow;
Requirements: defining requirements for the iteration based on studying the business model, customer and stakeholder feedback.
Development: designing and developing the system based on the requirements from both users and stakeholders.
Testing: this is by checking on Quality Assurance (QA) testing, internal and external training and documentation development of the system as a whole.
Delivery: integrate and deliver the working iteration into production for the functionalities in the organization or institution.
Feedback: accept customer and stakeholder feedback and work it into the requirements of the next iteration.
In this agile methodology I implemented live demonstrations, daily testing on functionalities, sharing of feed-backs and in all I had to remain agile that means that I was making changes to my process based on the feedback of customers and stakeholders to ensure each iteration improves the last to ensure system functions as required from the users and stakeholders. I had also employed testing of system until an acceptable income was achieved from which I developed the store management system. This method had allowed me to interact with end user that is customers and administration as this system requires a lot of interactions with end users on interfaces.
I used agile methodology because its more flexible, productive, transparent, optimization and reduced risks on the system being developed [3]. In agile methodology there is faster implementation of solutions, minimization of resources, adaptable to changes and optimized development processes. With the use of iteration and testing in each case it provides a system that satisfies both users and stakeholders as a better output is achieved.
The logical development phase commences after the studying of the business, and we have developed specifications for the software. In this regard, we have elected to go with the Microsoft Access database as it would be the most convenient for use in this scenario. The reasons for use of the MS Access database are as below.
Portability is a characteristic that many users appreciate. Similar to an Excel file, portability refers to how easily something can be moved or copied [1]. It is simple to duplicate the database for other needs, as in a project, or to copy to different places because an Access application is in one file (but need not be). Although this function may make IT staff cringe, users often appreciate it because it offers a lot of freedom. Many people appreciate how easy Access is to comprehend and how flexible it is once they start using it.
There have been more than 25 years of MS Access. Predictions of Microsoft's collapse have been vastly overblown, even though the product hasn't improved much throughout the past ten years. It continues to be the sixth most well-liked relational database, according to DB-engines.com. I still provide support for numerous deployed Access databases at client locations, and they continue to fulfill their intended function.
Expected Results: The Deliverables
The expectation for the system is that the business will meet the main and specified objectives laid out. In meeting this objective, we treat the system as a mature system and it is released to the business owner for operations.
Personnel
Project Manager: Devaraj Tadishetty
Email: devaraj.tadishetty555@gmail.com.
This is Devaraj Tadishetty, and this project was done by myself, I have done my tasks by myself dividing it according to my strengths and weak areas. It helped me to complete the project in a good manner.
As the project lead, I am skilled in database creation and operations in Microsoft Access. Creation of software application based on Visual Basic is also a staple of what I do. I can be reached through my personal email, devaraj.tadishetty555@gmail.com.
Supporting Facilities
The completion of this project was aided by both development and documentation tools. Visual Studio, Microsoft Access, and Microsoft Word for the documentation of the project. We used Windows Operating System 10 for the development and documentation of the system.
References
[1] M. Alexander and D. Kusleika, Access 2019 bible. Indianapolis, IN: John Wiley & Sons, Inc., 2019.
[2] R. Murch, Project Management: Best practices for IT professionals. Upper Saddle River, NJ: Prentice Hall, 2011.
[3] M. Fishpool and B. Fishpool, Software development in practice. British Computer Society, 2020.
Report 1
Project Manager: Devaraj Tadishetty
Address & Contact NO.: +1 (610) 864-2763, 26241 Lakeshore Blvd Euclid Ohio, USA. 44132.
Email: devaraj.tadishetty555@gmail.com
Research detail
The Grocery Store Database Management research project aims to research the viability and application of a database system to grocery stores in a way that will help the grocery store owners streamline their operations to minimize resources used and maximize profits accrued. The database system in question that is chosen by the researcher is the Microsoft Access database management system. Microsoft Access is an application that is bundled alongside Microsoft Office Suite. The Microsoft Access system is the most desirable for this system for its following characteristics and advantages over other database systems.
Simplicity. Microsoft Access is fairly simple to use as compared to other database management systems. As long as you have Microsoft Access installed, you can create and manage your database systems with ease. Its learning curve is fairly gentle and well-explained walkthroughs and tutorials available from the official Microsoft sites.
Support. As a product of Microsoft office suites, Microsoft access enjoys long-term support employed by Microsoft itself. This means that your database will be fairly stable and well supported by the manufacturer for a long time to come. It also has a great online community that helps in troubleshooting issues.
Portability. Portability refers to how easily something can be moved or copied. It is simple to duplicate the database for other needs, as in a project, or to copy to different places because an Access application is in one file.
After the database has been developed, we seek to test it by exposing it to a real-life scenario in the operation of the business to confirm its viability to the business. There is also the development of an accompanying application which will assist the business in creating an interface that the user can interact with easily and manipulate or access data.
Mission Statement (7/12/2022)
Regarding this current project, our mission statement of quality and efficiency shines through as we seek to deliver software that works to expectations while being light enough and less resource intensive.Support DialogueDeveloper: What is your current system and how do you operate it on a normal day to day business basis? What functions does it serve?
Grocery Manager: On normal days, we have the cash register that helps us keep track of purchases from the store, while we have a ledger book to record our inventory, as it is delivered to us.
Developer: Is your current system serving you well enough? Would you consider an upgrade? And what kind of flaws does it have that most affect your business?
Grocery Manager: Our biggest challenge is on the human error side as some items do not get recorded or go missing totally. The calculations are also difficult and time consuming and we would prefer a more digital or automatic system.
Mission Objectives (7/14/2022)
The mission objectives for the database system are as follows:
Allow recording of inventory
Allow report features to know purchases made on daily basis
Show different trends in products
Allow different users and permissionsSupport Dialogue
Developer: What kind of data would you want the system to keep track of?
Grocery Manager: Basically, the shops daily operations, purchases going out and inventory coming in. We would also want to know how much stock we have and at least maybe get warnings or alerts if our stock is running low
Developer: Anything else you can think of to be added to the database
Grocery Manager: We would appreciate having various types of reports over time to have a way of predicting and forecasting on the business. So we would appreciate a report generation feature
List of subjects (7/18/2022)
Employee
Customer
Product
Supplier
Sales
Users
Receipt
Registers
List of characteristics (7/18/2022)
Employee Address
Employee name
Employee ID
Customer ID
Customer name
Customer order
Product Manufacturer
Product ID
Product Name
Supplier Name
Supplier Address
Supplier ID
Sales Report
Sales ID
Sales Tax
User First Name
User ID
User Last Name
Receipt ID
Receipt Amount
Receipt Time
Register Number
Register ID
Register Name
Support Dialogue
Developer: How do you update your records to reflect the most recent transactions
Grocery Manager: Given our ledger book, we take half an hour after we close down to recap all that we had done that day and correct errors. Although this method is time consuming and not convenient, we have no other options
Preliminary Field List (7/19/2022)
Employee Address
Employee name
Employee ID
Customer ID
Customer name
Customer order
Product Manufacturer
Product ID
Product Name
Supplier Name
Supplier Address
Supplier ID
Sales Report
Sales ID
Sales Tax
User First Name
User ID
User Last Name
Receipt ID
Receipt Amount
Receipt Time
Register Number
Register ID
Register Name
Final Preliminary Field List (7/20/2022)
Product Sales
Employee name
Employee ID
Employee Address
Employee Rank
Customer ID
Customer name
Customer last
Customer Shipping Address
Product ID
Product Name
Product Quantity
Customer Shipping Address
Sales total amount
Supplier Address
Supplier Product
Calculate Field List (7/21/2022)
Quantity Stock
Total Amount
Sub total Amount
Total Taxes
Maximum sales
Minimum sales
Value Field list (7/21/2022)
Stock
Register
Computer
Coolers
Preliminary table list (7/22/2022)
Employee
Customer
Product
Supplier
Sales
Users
Final Table List (7/22/2022)
Name Type Description
Employee Data Details pof the people who work within the store including names, Ids, addresses
Customer Data Details of people who are served by the store, may include names, ids, addresses, phone numbers
Product Data Items that are delivered to the store and stored as inventory or sold as products
Supplier Data Companies or people that serve the store by delivering products to the store
Sales Data Collection of all the items that have already been sold by the store
Users Data Collection of all the people who have permission to access various levels of the store or database system
Permissions data Attributes that define which user can access which part of the database and which parts are out of bounds for them
Database Table Structure (7/23/2022)
Employee
Employee address
Employee ID (PK)
Employee Name
Customer
Customer ID (PK)
Customer Name
Customer Order
Sales
Sales Report
Sales ID (PK)
Sales Tax
Product
Product ID (PK)
Product Name
Product Quantity
Supplier
Supplier ID (PK)
Supplier Name
Supplier Address
Receipt
Receipt Time
Receipt Amount
Receipt ID (PK)
User
User ID (PK)
User First Name
User Last Name
Support Dialogue
Developer: Who works in the store and how do you record their data and who they have served
Grocery Manager: As stated earlier, we make use of a cash register, as we have one available. It prints out who has been serving the customers, although that is not fool proof. It has its disadvantages. The ledger book also helps in recording movement of inventory.
Implementation details (7/23/2022)
Research implementation has been done through data collection methods. Direct data collection is favored over indirect data collections as we are on site which allows us to be the firsthand interaction or entry point for the preferred data. The chosen data collection method is the performance of interviews and observations. Observation was chosen as it allows us to monitor the business in its natural surrounding without us creating any interferences that would hinder the observation process or creating any pretenses in the environment that would bias or mislead the data. The method of observation is chosen because of the following reasons.
Independent of People's Desire to Report:
Observation does not depend on people's willingness to divulge personal details. Many people find it difficult to talk about themselves with an outsider. Some folks don't have the time or the necessary abilities to give the researcher crucial information. Even if observation cannot always solve these issues, it nevertheless demands less active participation and willingness from the subjects. It is always feasible to observe without the subjects' awareness.
Very Accurate:
The researcher must rely on the data that have been collected when using alternative methods, such as an interview or questionnaire. These are therefore indirect approaches, and the investigator is unable to check the veracity of the information they have provided. However, during observation, the observer can immediately verify the observers correctness. He can use a variety of tools to check the consistency of their behavior. The data gathered through observation is frequently more accurate than that gathered through questionnaire or interview.
The observation was carried out by arrival at the business and set up of our equipment and personnel to observe how the business runs and to record their observations as appropriately. Observation included looking at what times the business is most busy and what times it is least busy and how it affects the running of the store and its database. Questions answered were whether the business would slow down upon being busy and loads subjected to the database or it would still operate as optimum.
The second method of data collection employed was the use of interviews. Interviews are mostly one on one discussions with various individuals to know how they feel about a particular subject matter, in this case, the existing system and business methodology in service at the store. This method was chosen to allow us read more into the interviewees feelings, as in line with the advantage of using interviews below.
Observe your feelings and actions:
Without a doubt, face-to-face interviews can document an interviewee's feelings and actions. Online and mobile polls cannot accurately capture unfiltered emotions and behavior, much like verbal and nonverbal questions cannot be captured.
Precise screening:
The screening process is made more accurate through in-person interviews. The interviewee is unable to give false answers in response to screening inquiries about gender, age, or ethnicity. In web and mobile surveys, screening questions can be avoided. Offering rewards in online and mobile polls may inadvertently encourage answer fabrication. In order to finish the survey and receive the reward, people could input false demographic data. Even if the individual's responses are all accurate, the data will still be unreliable and deceptive when used for data analysis.
Interviews conducted with all business stakeholders shed light on what each considers important in the business and helped us determine priority areas of the system. Given this information, we wrote a requirements specification document to guide us through the development phase of the database.
Application Implementation (7/24/2022)
Environment setup:
The application needs to run on Windows operating system as it is the operating system used in store. It is also a versatile and popular operating system which ensures that if there are hardware changes, the application will still be able to run with minimal issues. To this requirement, we elect to use C# as the language of choice to build the application with. In order to build the application, there is need to correctly set up the environment with which we will use, which is Microsoft Visual Studio Community. We download the application from official Microsoft sources and add components that allow us to build the application efficiently.
Building the GUI:
We have chosen to use Windows forms as the method of building our graphical user interface for the application. Windows Forms, a controlled framework that was first introduced in 2002, is the oldest and most popular desktop technology based on the Windows graphical device interface (GDI) engine. It provides a fluid drag-and-drop environment for Visual Studio user interface development. Making visual components from code isn't simple because Windows Forms relies on the Visual Studio Designer as the primary tool for UI development. The key features of Windows Forms are enumerated in the list below:
It is mature technology with a ton of documentation and code samples, which makes development that much easier as you are bound to get sufficient support and troubleshooting.
Effective and powerful designer. Designing UI "from code" is not very practical. This allows you to envision the UI as you need it be and drag and drop features in a way that makes it easier to accomplish the UI goals
Because of the drag-and-drop capabilities of the designer, it is simple and easy to learn.on any Windows version supported.
Field Specification Document (7/24/2022)
A field specification document defines a field specification for each field in the database. It helps to establish field-level integrity by ensuring that the data is consistent, valid, and as free from errors as possible
Table Matrix (7/30/2022)
The Table Matrix helps us identify various tables and how they relate with each other within the database and its intended daily operation in the system. In the table matrix, relationships are represented as below:
1:1 One to One
1: N One to Many
N:1 Many to One
Relationships, Public Key and Table Structure (7/31/2022)
The public and foreign keys existing in the table structures below can be denoted with the symbols as:
PK-Primary Key:
A primary keys main features are:
It must contain a unique value for each row of data.
It cannot contain null values.
Every row must have a primary key value.
A primary key might use one or more fields already present in the underlying data model, or a specific extra field can be created to be the primary key.
FK-Foreign Key:
A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables
Business Rule Specifications
113775129484Rule Information
00Rule Information
Statement:
Constraint:
Type:
Database Oriented
Application Oriented Category:
Field Specific
Relationship Specific
Test On:
Insert
Update
Delete
1137751905939Structures affected
00Structures affected
Field Name:
Table Name:
11377576448Field elements affected
00Field elements affected
Physical elements
Data Type Length Character Support
Logical elements
Key Type
Key Structure
Uniqueness Null Support
Values Entered By
Required Value Range of Values
Edit Rules
11377550607Relationship Characteristics allowed
00Relationship Characteristics allowed
Deletion Rule Type of Participation Degree of Participation
11272646686Action Taken
00Action Taken
View Specifications
113775129484General Information
00General Information
Name: Type: Data Aggregate Validation
Description:
1136651795569Basic Table
00Basic Table
11366550165Calculated Field Expression
00Calculated Field Expression
Field Name Expression
11303054822Filter
00Filter
Field Name Condition
Project Progressive Report Specification
Format
Its format should be single space, Times New Roman font type, 12 font size, fully justify on text, and one-line space between the section.
Section Requirements
Title: Project Progressive Report, which must be located at the center of first line.
Reporter: Students Name.
Progressive Description & Milestones (with Date information):
Analysis:
Identify the Business Models. (Analysis topic business)
Business Investigation (describe your investigation here)
Defining the Mission Statement
Dialogue to support Mission Statement.
Defining the Mission Objectives
Dialogue to support Mission Objectives
Logical Design:
Identify the DB Application. (Design database structure with Microsoft Access)
The List of Subjects (Date)
The List of Characteristics (Date)
The Preliminary Field List (Date update)
Final Preliminary Field List, Value Field List, Calculate Field List (Date)
The Preliminary Table List (Date update)
Final Table List (Date update)
Table Structure List (Date update)
Physical Design:
Identify Issues Pertaining to Collecting & Managing Data and Identify the Types of Data Stores in the DB. (Microsoft Access)
Field Specification Sheet
Analyzing Table Relationship in Database:
Identify Relationship Table Matrix
Identify all of keys (primary key and foreign key) in the tables
Analyzing Business Rules in Database:
Identify Business rule in Database
Identify relationship characteristics for each table
Analyzing View in Database:
Technical Background (Methodology and Implementation Plan)
Date
Microsoft ACCESS DBMS for implementation
Date
Requirements Analysis: activity diagram, data flow, use cases/scenarios, forms, transactions,queries, etc.(you should show a few example of your current and proposedsystem activity diagram)
Date
Conceptual Design: ER Diagram
Logical Design: (relational) design approach you would use Physical Design: discuss issues for the system you are to design
Application Implementation: Design Application with C# programming language. (Visual Studio)
Date
Programming coding
Prototype:plan for form design, report design, web-DB connection
Date
ER Diagram for whole database
Performance evaluation:Plan for testing
Reference (if necessary)
Use IEEE format for the reference list.
IEEE format: [number] Full name of the Authors. Title of the paper. Source, page number, publish date. URL address.
Example of IEEE reference:
[1] S. Warfield, F. Jolesz, and R. Kikinis. A high performance computing approach to the registration of medical imaging data. Parallel Computing, 24(9-10):1345 1368, 1998.
IST 634 Enterprise Database
Section 300, Summer 2022
Department of Information Systems
Monte Ahuja College of Business Administration
INSTRUCTOR NAME:Dr. Cheng, Wei-Hung (Wayne)
OFFICE:BU 342
PHONE NUMBER:(216)687-3911
E-MAIL:w.h.cheng@csuohio.edu (preferred)
Class Location:BH 017A
Class Time:TTH 1:50PM ~ 5:00PM, 7/5 ~ 8/12 (6W2)
OFFICE HOURS:Tuesday/Thursday 10:00 am ~ 1:00 pm
During office hours, we can meet virtually by appointment and you can, as always, email me with any questions and I will get back to you as soon as possible.
Prerequisites: IST 604 or equivalent
Course Description and Objectives
Catalog Description: Detailed study of modern relational database systems and non-relational database systems for Enterprise Business Analytics. First, the course studies core components of relational database systems with the query processing concept and execution techniques, query optimization strategies of modern relational databases. Then the course advances with the study of semi-structured databases and non-structured data processing. The course continues with the study of the advanced features of modern Business Intelligence systems with Parallel Data Warehouse (PDW) and data mining algorithms. Finally, the course will explore current database industry research papers on big data processing and cloud computing.
Key Concepts: Introduction how to design modern databases that are soundly structured, reliable, and flexible, even in the latest online application. It from planning to defining tables, fields, keys, table relationships, business rules, and views. - Learning practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules.
Expected Outcomes: Upon successful course completion, a student will be able to:
Understand database types, models, and design terminology.
Perform interviews to efficiently capture requirements-even if everyones working remotely.
Set clear design objectives and transform them into effective designs.
Analyze a current database so you can identify ways to improve it.
Establish table structures and relationships, assign primary keys, set field specifications, and set up views.
Ensure the correct level of data integrity for each database.
Identify and establish business rules.
Preview and prepare for the future of relational databases.
Resources
Textbook (required): DATABASE DESIGN For MERE MORTALS by Michael J. Hernandez. Publish by Pearson Addison-Wesley. ISBN: 978-0-13-678804-1.
Reference Textbook: Practical Database Programming With Visual C#.NET by Ying Bai. Publish by WILEY/IEEE PRESS. ISBN: 978-0-470-46727-5
Blackboard: The course will be administered using Blackboard Learn 9.1. The syllabus and other pertinent links are available from the homepage.
eLearning: Course content will be delivered via the Blackboard Learn 9.1 course management system. The instructor will communicate with students via a variety of interactive tools including discussions, announcements, email, and chat. There will be no required face-to-face meetings for this course, but students will be expected to make weekly progress online. A computer and access to the internet are required.
Student Expectations and Policies
Written and Oral Communications: Being able to communicate effectively is critical in the business world. All materials are expected to be of professional quality.
Attendance: Attending web class in Zoom meeting room, participating in discussions, and access Blackboard.
Project Policy: Database Project is including documentation (5 reports, application instruction and PowerPoint) and final Database product. Each week has one project report due at the end of Sunday. It will not make-up option. Project report will be submitted at Blackboard.
Late Assignments: Late assignments will receive no credit.
Grading
The course grade is based on a student's overall performance through the entire Semester. The final grade is distributed among the following components:
Requirement Percent
Database Project Proposal Reports 50
Database (Microsoft Access) 20
Application 10
Application Instruction (Manual) 5
PowerPoint Presentation 10
Attendant 5
TOTAL 100
Final letter grade determinations will be assigned according to the following percentages:
A 90 + A: Outstanding (student's performance is genuinely excellent)
B+ 87 89.9 B 80 86.9 B: Very Good (student's performance is clearly commendable but not necessarily outstanding)
C+ 77 79.9 C 70 76.9 C: Good (student's performance meets every course requirement and is acceptable; not distinguished)
D 60 69.9 D: Below Average (student's performance fails to meet course objectives and standards)
F < 60 F: Failure (student's performance is unacceptable)
Official Calendar and Important Dates
Please consult the page https://www.csuohio.edu/registrar/summer-semester-2021Important Dates to Remember
Class begins July 5, 2022
Last day to add the class July 8, 2022 (Campus Net Registration)
Last day to drop the class July 11, 2022
Course withdrawal period begins July 12, 2022 (with W grade)
Last day to withdraw from courses August 2, 2022
Project Progressive Reports Due at Sunday Midnight every week.
Database Project Due August 12, 2022
Last Day of Classes: August 12, 2022
What is expected of you and IThis course is in person course with Blackboard. Please check for regular updates in Blackboard.
Students who miss weekly activities are responsible for bringing themselves up to date on class material, evaluation schedule, Blackboard postings, and assignments.
Students are responsible for submitting their assignments properly, per instructions, and in complete/gradable format. If you do not understand how to submit assignments, ask before the due date/due deadline. I will not reach out to students to re-submit assignments, and I will not accept late assignments unless there is an extreme, documented need.
All students are expected to read the assigned chapters or supplemental materials each week.
Exams will be a combination of material presented in lectures, covered in the textbook and additional notes, homework problems, and lab experiences.
Each week assignments should be completed at the end of Sunday.
Any class information will be announced on the Blackboard course announcement.
You are responsible for regularly checking Blackboard, along with completing any material assigned to you.
Tentative Course Schedule
Week Chapter Topic Project Progressive Report
Week 1 Chapter 1 Relational Database
Chapter 2 Design Objectives
Chapter 3 Terminology Database Project Proposal V1
Week 2 Chapter 4 Conceptual Overview
Chapter 5 Starting the Process
Chapter 6 Analyzing the Current Database Database Progressive Report V2
Week 3 Chapter 7 Establishing Table Structures
Chapter 8 Keys
Chapter 9 Field Specifications Database Progressive Report V3
Week 4 Chapter 10 Table Relationship
Chapter 11 Business Rules
Chapter 12 - Views Database Progressive Report V4
Week 5 Chapter 13 Reviewing Data Integrity
Chapter 14 Bad Design What Not to Do Database Progressive Report V5
Week 6 Chapter 15 Bending or Breaking the Rules
Chapter 16 In Closing Database Project Due.
NOTE: The instructor reserves the right to retain, for pedagogical reasons, either the original or a copy of your work submitted for this class. Student names will be deleted from any retained items.
Database Project Proposal
Proposal Title:Grocery Store Database Management Project Proposal
Title:
H-Soft Software Solutions
List of project leader and project members withinstitutional affiliations
Devaraj Tadishetty, *+1 (610) 864-2763, 26241 Lakeshore Blvd Euclid Ohio, USA. 44132. devaraj.tadishetty555@gmail.com
Submitted to:Dr. Cheng for IST 634 (Enterprise Databases) Summer Term 2022 Project
Proposal date: 07/10/2022
Topic Research and Executive Summary
The grocery management system is an application aimed at increasing the efficiency of running small to medium-sized grocery stores. This system consists of a database and an application that allows the user to enter all the records that they have received. Upon reception of items and entering into the system as an inventory, whenever there is a purchase made that takes items out of the store, it is also recorded by the system. This allows the store owner to keep track of items that come in and out of the store.
The system can separate users based on the hierarchical levels of system privilege. There are three levels of privilege available in the system. The administrator, the manager, and the clerk. A user, such as another administrator, manager, or clerk, may be created by the administrator and assigned a fitting security clearance or authentication. The manager, on the other hand, has only the privilege to read data system-wide and limited writing access. The manager can create new clerk accounts with limited privileges and cannot create new manager accounts or delete existing manager accounts as those are the domains of the administrator. The clerk on the other hand has very limited access to reading and writing data, limited to interactions with the customer only. Such may be serving customers in storefront operations.
The benefit of this system is an enhancement of accountability and service delivery in a seamless time and energy-efficient way. We invite you to try our systems for a week as a part of a pilot program and if you are happy with it, we would be happy to install the systems for you as well as offer you a half-price system lifetime support to ensure that your business runs as smoothly as possible and maximizes on profit.
Statement of work
Project Description:
H-Soft is a software company that deals with the creation of business and database operations software that aids in the running and maintenance of various small to mid-size business operations. H-Soft has several customers and software in its portfolio, such as the grocery management system which is our flagship project aimed at small to mid-size grocery stores. The purpose of this software is to ensure that the grocery stores have an easy time running their systems and turn a profit most efficiently. The mission of our company is to ease business operations and maximize profits. This is done by streamlining business operations to the point of minimizing losses by employing quality software products that are built on efficiency. This is in line with our vision of making human work easier by leveraging our software products and practices to make the running of your business as smooth and hassle-free as possible. Achievement of such goals is watch keeps us motivated and striving to provide the best software experiences to the customer which in turn eases the business operations and life of the business owner and the consumer. The grocery store system is an application combining a front end and a database to assist in the management and operations of a small to medium-sized store. The system is aimed at these types of businesses as they are the most in need of systems that ensure that there is no proliferation. The main of time and resources in terms of money or goods lost from the inventory. In the achievement of such a goal, we must look at why such a problem exists in the first place. Within most small businesses, there is the assumption that, since we are a relatively small operation, there is no need to have systems in place, as they are an unnecessary complication of matters. However, this is the problem as without proper problems, you cannot track what goes in or out of the business easily. Taking down things by hand only does not help you to build a proper inventory with all the data that you need, nor will a mere cash register help you keep track of every single dollar that flows through your business. That is why the store management system comes in handy to eliminate such problems, by assisting you to take in inventory as well as note every purchase or outgoing movement of both cash and cargo. To provide a system that will increase throughput, employ a high-efficiency level and a user-friendly system to access users. This will ensure a profitable and competitive advantage tool for most businesses.
Challenges:
However, every unique customer presents a unique set of challenges to be dealt with accordingly to ensure that their business runs well. The main challenge that we usually face as a business that develops software systems is the customization of the software as most times, a one size fits all approach does not work and the software needs to be tailored to the needs of the customer. This is important as it helps the customer work better at operating their business. Luckily for us, as we are skilled at what we do, we have developed different strategies to deal with these situations in ways that ensure maximum results for the software and the customer that will use it to run their business. The main strategy is constant communication with the customer, to make sure that we are on the same page and that we understand each other perfectly and work towards the same goals. This helps in ensuring that what was planned and communicated is what is delivered.
Project Management Approaches, Schedule, and Milestones
Another strategy pertains to our preferred software development mechanism, which is the agile method. Agile methodology is where the system has taken into consideration the user requirements and iteration criteria to accomplish the objectives of the system. To ensure that the system enables the users to accomplish their tasks and goals as it uses the user input and developed on the iteration as testing is done severally from the user requirements and iteration.
The agile development process is dominated by the iterative process. Iterations are usually two or four weeks in length and have affixed completion time to enhance the scope of the system. Due to its time-bound nature, the iteration process is methodical and the scope of iterations is only as broad as the allotted time allows.
The multiple iterations took place during the agile development life-cycle and each followed its workflow. During iteration, the customers and business stakeholders must provide feedback to ensure that the features meet their needs.
For the success of the project, it is important that is scheduled in a way that favors all the parties that are working on it. To achieve proper project scheduling, we have always employed the use of division of labor and specialization as well as the use of smart tools such as the Gantt chart to make sure that we can quantify our daily progress and hit our targets and milestones, which are essential for project success[2]. Each member of our team has a specific role to play within the development period of the system, with each taking a lead at different times of the system development lifecycle.
Below is the roadmap for the development and deployment of the software.
Aside from the roadmap, we are also highly organized in development of our plans, as can be seen by the Gantt chart below that we use to develop and plan the work needed to be done over the time period that we have.
Methodology and Implementation Plan
During this time of the development process, we study the business in question for two weeks in its operations without the use of our software. Studying the business model and its operations allow us to understand better the needs of the business and the niche within which it exists. This understanding allows us to know the requirements for the system and how we can customize it further, ensuring that the business will perform at its optimum using the software. After the studying the business model employed by the said business, we go on to the second period of development
In order to have enough information to develop the system, collection of data is important. As we directly observe the companys operations, our main sources of data collection is through observation. I surveyed the store that requires the system to observe the challenges of the current system that helped me design a system that solved various problems facing current system. I also checked on the security and user interfaces of the current system through observation method. This was achieved by recording events that perform and check on the guide and protocols applied in the institution.
I had to interview both the customers or users and the staff using the system because they are the entities involved in the daily tasks of the system. I also interviewed the stakeholders to gather more information on the system they propose to have so as I could meet their requirements too during my design.
In terms of the system development methodology, we had chosen to use agile methodology. Agile methodology has multiple iterations taking place during the agile development life-cycle and each follows its own work-flow. During iteration, it is important that the customers and business stakeholders provide feedback to ensure that the features meet their needs.
The iteration process flow;
Requirements: defining requirements for the iteration based on studying the business model, customer and stakeholder feedback.
Development: designing and developing the system based on the requirements from both users and stakeholders.
Testing: this is by checking on Quality Assurance (QA) testing, internal and external training and documentation development of the system as a whole.
Delivery: integrate and deliver the working iteration into production for the functionalities in the organization or institution.
Feedback: accept customer and stakeholder feedback and work it into the requirements of the next iteration.
In this agile methodology I implemented live demonstrations, daily testing on functionalities, sharing of feed-backs and in all I had to remain agile that means that I was making changes to my process based on the feedback of customers and stakeholders to ensure each iteration improves the last to ensure system functions as required from the users and stakeholders. I had also employed testing of system until an acceptable income was achieved from which I developed the store management system. This method had allowed me to interact with end user that is customers and administration as this system requires a lot of interactions with end users on interfaces.
I used agile methodology because its more flexible, productive, transparent, optimization and reduced risks on the system being developed [3]. In agile methodology there is faster implementation of solutions, minimization of resources, adaptable to changes and optimized development processes. With the use of iteration and testing in each case it provides a system that satisfies both users and stakeholders as a better output is achieved.
The logical development phase commences after the studying of the business, and we have developed specifications for the software. In this regard, we have elected to go with the Microsoft Access database as it would be the most convenient for use in this scenario. The reasons for use of the MS Access database are as below.
Portability is a characteristic that many users appreciate. Similar to an Excel file, portability refers to how easily something can be moved or copied[1]. It is simple to duplicate the database for other needs, as in a project, or to copy to different places because an Access application is in one file (but need not be). Although this function may make IT staff cringe, users often appreciate it because it offers a lot of freedom. Many people appreciate how easy Access is to comprehend and how flexible it is once they start using it.
There have been more than 25 years of MS Access. Predictions of Microsoft's collapse have been vastly overblown, even though the product hasn't improved much throughout the past ten years. It continues to be the sixth most well-liked relational database, according to DB-engines.com. I still provide support for numerous deployed Access databases at client locations, and they continue to fulfill their intended function.
Expected Results: The Deliverables
The expectation for the system is that the business will meet the main and specified objectives laid out. In meeting this objective, we treat the system as a mature system and it is released to the business owner for operations.
Personnel
Project Manager: Devaraj Tadishetty
Email: devaraj.tadishetty555@gmail.com.
This is Devaraj Tadishetty, and this project was done by myself, I have done my tasks by myself dividing it according to my strengths and weak areas. It helped me to complete the project in a good manner.
As the project lead, I am skilled in database creation and operations in Microsoft Access. Creation of software application based on Visual Basic is also a staple of what I do. I can be reached through my personal email, devaraj.tadishetty555@gmail.com.
Supporting Facilities
The completion of this project was aided by both development and documentation tools. Visual Studio, Microsoft Access, and Microsoft Word for the documentation of the project. We used Windows Operating System 10 for the development and documentation of the system.
References
[1] M. Alexander and D. Kusleika, Access 2019 bible. Indianapolis, IN: John Wiley & Sons, Inc., 2019.
[2] R. Murch, Project Management: Best practices for IT professionals. Upper Saddle River, NJ: Prentice Hall, 2011.
[3] M. Fishpool and B. Fishpool, Software development in practice. British Computer Society, 2020.
Report 1
Project Manager: Devaraj Tadishetty
Address:+1 (610) 864-2763, 26241 Lakeshore Blvd Euclid Ohio, USA. 44132.
Email: devaraj.tadishetty555@gmail.com
Research detail
The Grocery Store Database Management research project aims to research the viability and application of a database system to grocery stores in a way that will help the grocery store owners streamline their operations to minimize resources used and maximize profits accrued. The database system in question that is chosen by the researcher is the Microsoft Access database management system. Microsoft Access is an application that is bundled alongside Microsoft Office Suite. The Microsoft Access system is the most desirable for this system for its following characteristics and advantages over other database systems.
Simplicity. Microsoft Access is fairly simple to use as compared to other database management systems. As long as you have Microsoft Access installed, you can create and manage your database systems with ease. Its learning curve is fairly gentle and well-explained walkthroughs and tutorials available from the official Microsoft sites.
Support. As a product of Microsoft office suites, Microsoft access enjoys long-term support employed by Microsoft itself. This means that your database will be fairly stable and well supported by the manufacturer for a long time to come. It also has a great online community that helps in troubleshooting issues.
Portability. Portability refers to how easily something can be moved or copied. It is simple to duplicate the database for other needs, as in a project, or to copy to different places because an Access application is in one file.
After the database has been developed, we seek to test it by exposing it to a real-life scenario in the operation of the business to confirm its viability to the business. There is also the development of an accompanying application which will assist the business in creating an interface that the user can interact with easily and manipulate or access data.
Mission Statement
In regards to this current project, our mission statement of quality and efficiency shines through as we seek to deliver software that works to expectations while being light enough and less resource intensive.Support DialogueDeveloper: What is your current system and how do you operate it on a normal day to day business basis? What functions does it serve?
Grocery Manager: On normal days, we have the cash register that helps us keep track of purchases from the store, whle we have a ledger book to record our inventory, as it is delivered to us.
Developer: Is your current sysem serving you well enough? Would you consider an upgrade? And what kind of flaws does it have that most affect your business?
Grocery Manager: Our biggest challenge is on the human error side as some items do not get recorded or go missing totally. The calculations are also difficult and time consuming and we would prefer a more digital or automatic system.
Mission Objectives
The mission objectives for the database system are as follows:
Allow recording of inventory
Allow report features to know purchases made on daily basis
Show different trends in products
Allow different users and permissionsSupport Dialogue
Developer: What kind of data would you want the system to keep track of?
Grocery Manager: Basically, the shops daily operations, purchases going out and inventory coming in. We would also want to know how much stock we have and at least maybe get warnings or alerts if our stock is running low
Developer: Anything else you can think of to be added to the database
Grocery Manager: We would appreciate having various types of reports over time to have a way of predicting and forecasting on the business. So we would appreciate a report generation feature
List of subjects
Employee
Customer
Product
Supplier
Sales
Users
Support Dialogue
Developer: Who works in the store and how do you record their data and who they have served
Grocery Manager: As stated earlier, we make use of a cash register, as we have one available. It prints out who has been serving the customers, although that is not fool proof. It has its disadvantages. The ledger book also helps in recording movement of inventory.
List of characteristics
Address Name
Sales
Purchases
Totals amount
Product Name
Shipping address
Support Dialogue
Developer: How do you update your records to reflect the most recent transactions
Grocery Manager: Given our ledger book, we take half an hour after we close down to recap all that we had done that day and correct errors. Although this method is time consuming and not convenient, we have no other options
Preliminary Field List
Product Sales
Supplier Name
Supplier Address
Employee Address
Product ID
Product Name
Quantity
Total Amount
Date
Customer Shipping Address
Sales total amount
Final Preliminary List
Product Sales
Employee Address
Product ID
Product Name
Product Quantity
Customer Shipping Address
Sales total amount
viii.Supplier Address
ix.Supplier Product
Calculate List
Quantity Stock
Total Amount
Value list
Date
Implementation details
Research implementation has been done through data collection methods. Direct data collection is favored over indirect data collections as we are on site which allows us to be the first hand interation or entry point for the preferred data. The chosen data collection method is the performance of interviews and observations. Observation was chosen as it allows us to monitor the business in its natural surrounding without us creating any interferences that would hinder the observation process or creating any pretences in the environment that would bias or mislead the data. The method of observation is chosen because of the following reasons.
Independent of People's Desire to Report
Observation does not depend on people's willingness to divulge personal details. Many people find it difficult to talk about themselves with an outsider. Some folks don't have the time or the necessary abilities to give the researcher crucial information. Even if observation cannot always solve these issues, it nevertheless demands less active participation and willingness from the subjects. It is always feasible to observe without the subjects' awareness.
Very Accurate
The researcher must rely on the data that have been collected when using alternative methods, such as an interview or questionnaire. These are therefore indirect approaches, and the investigator is unable to check the veracity of the information they have provided. However, during observation, the observer can immediately verify the observed's correctness. He can use a variety of tools to check the consistency of their behavior. The data gathered through observation is frequently more accurate than that gathered through questionnaire or interview.
The observation was carried out by arrival at the business and set up of our equipment and personnel to observe how the business runs and to record their observations as appropriately. Observation included looking at what times the business is most busy and what times it is least busy and how it affects the running of the store and its database. Questions answered were whether the business would slow down upon being busy and loads subjected to the database or it would still operate as optimum.
The second method of data collection employed was the use of interviews. Interviews are mostly one on one discussions with various individuals to know how they feel about a particular subject matter, in this case, the existing system and business methodology in service at the store. This method was chosen to allow us read more into the interviewees feelings, as in line with the advantage of using interviews below.
Observe your feelings and actions.
Without a doubt, face-to-face interviews can document an interviewee's feelings and actions. Online and mobile polls cannot accurately capture unfiltered emotions and behavior, much like verbal and nonverbal questions cannot be captured.
Precise screening.
The screening process is made more accurate through in-person interviews. The interviewee is unable to give false answers in response to screening inquiries about gender, age, or ethnicity. In web and mobile surveys, screening questions can be avoided. Offering rewards in online and mobile polls may inadvertently encourage answer fabrication. In order to finish the survey and receive the reward, people could input false demographic data. Even if the individual's responses are all accurate, the data will still be unreliable and deceptive when used for data analysis.
Interviews conducted with all business stakeholders shed light on what each considers important in the business and helped us determine priority areas of the system. Given this information, we wrote a requirements specification document to guide us through the development phase of the database.
Database Project Proposal
Proposal Title:Grocery Store Database Management Project Proposal
Title:
H-Soft Software Solutions
List of project leader and project members withinstitutional affiliations
Devaraj Tadishetty, *+1 (610) 864-2763, 26241 Lakeshore Blvd Euclid Ohio, USA. 44132. devaraj.tadishetty555@gmail.com
Submitted to:Dr. Cheng for IST 634 (Enterprise Databases) Summer Term 2022 Project
Proposal date: 07/10/2022
Topic Research and Executive Summary
The grocery management system is an application aimed at increasing the efficiency of running small to medium-sized grocery stores. This system consists of a database and an application that allows the user to enter all the records that they have received. Upon reception of items and entering into the system as an inventory, whenever there is a purchase made that takes items out of the store, it is also recorded by the system. This allows the store owner to keep track of items that come in and out of the store.
The system can separate users based on the hierarchical levels of system privilege. There are three levels of privilege available in the system. The administrator, the manager, and the clerk. A user, such as another administrator, manager, or clerk, may be created by the administrator and assigned a fitting security clearance or authentication. The manager, on the other hand, has only the privilege to read data system-wide and limited writing access. The manager can create new clerk accounts with limited privileges and cannot create new manager accounts or delete existing manager accounts as those are the domains of the administrator. The clerk on the other hand has very limited access to reading and writing data, limited to interactions with the customer only. Such may be serving customers in storefront operations.
The benefit of this system is an enhancement of accountability and service delivery in a seamless time and energy-efficient way. We invite you to try our systems for a week as a part of a pilot program and if you are happy with it, we would be happy to install the systems for you as well as offer you a half-price system lifetime support to ensure that your business runs as smoothly as possible and maximizes on profit.
Statement of work
Project Description:
H-Soft is a software company that deals with the creation of business and database operations software that aids in the running and maintenance of various small to mid-size business operations. H-Soft has several customers and software in its portfolio, such as the grocery management system which is our flagship project aimed at small to mid-size grocery stores. The purpose of this software is to ensure that the grocery stores have an easy time running their systems and turn a profit most efficiently. The mission of our company is to ease business operations and maximize profits. This is done by streamlining business operations to the point of minimizing losses by employing quality software products that are built on efficiency. This is in line with our vision of making human work easier by leveraging our software products and practices to make the running of your business as smooth and hassle-free as possible. Achievement of such goals is watch keeps us motivated and striving to provide the best software experiences to the customer which in turn eases the business operations and life of the business owner and the consumer. The grocery store system is an application combining a front end and a database to assist in the management and operations of a small to medium-sized store. The system is aimed at these types of businesses as they are the most in need of systems that ensure that there is no proliferation. The main of time and resources in terms of money or goods lost from the inventory. In the achievement of such a goal, we must look at why such a problem exists in the first place. Within most small businesses, there is the assumption that, since we are a relatively small operation, there is no need to have systems in place, as they are an unnecessary complication of matters. However, this is the problem as without proper problems, you cannot track what goes in or out of the business easily. Taking down things by hand only does not help you to build a proper inventory with all the data that you need, nor will a mere cash register help you keep track of every single dollar that flows through your business. That is why the store management system comes in handy to eliminate such problems, by assisting you to take in inventory as well as note every purchase or outgoing movement of both cash and cargo. To provide a system that will increase throughput, employ a high-efficiency level and a user-friendly system to access users. This will ensure a profitable and competitive advantage tool for most businesses.
Challenges:
However, every unique customer presents a unique set of challenges to be dealt with accordingly to ensure that their business runs well. The main challenge that we usually face as a business that develops software systems is the customization of the software as most times, a one size fits all approach does not work and the software needs to be tailored to the needs of the customer. This is important as it helps the customer work better at operating their business. Luckily for us, as we are skilled at what we do, we have developed different strategies to deal with these situations in ways that ensure maximum results for the software and the customer that will use it to run their business. The main strategy is constant communication with the customer, to make sure that we are on the same page and that we understand each other perfectly and work towards the same goals. This helps in ensuring that what was planned and communicated is what is delivered.
Project Management Approaches, Schedule, and Milestones
Another strategy pertains to our preferred software development mechanism, which is the agile method. Agile methodology is where the system has taken into consideration the user requirements and iteration criteria to accomplish the objectives of the system. To ensure that the system enables the users to accomplish their tasks and goals as it uses the user input and developed on the iteration as testing is done severally from the user requirements and iteration.
The agile development process is dominated by the iterative process. Iterations are usually two or four weeks in length and have affixed completion time to enhance the scope of the system. Due to its time-bound nature, the iteration process is methodical and the scope of iterations is only as broad as the allotted time allows.
The multiple iterations took place during the agile development life-cycle and each followed its workflow. During iteration, the customers and business stakeholders must provide feedback to ensure that the features meet their needs.
For the success of the project, it is important that is scheduled in a way that favors all the parties that are working on it. To achieve proper project scheduling, we have always employed the use of division of labor and specialization as well as the use of smart tools such as the Gantt chart to make sure that we can quantify our daily progress and hit our targets and milestones, which are essential for project success[2]. Each member of our team has a specific role to play within the development period of the system, with each taking a lead at different times of the system development lifecycle.
Below is the roadmap for the development and deployment of the software.
Aside from the roadmap, we are also highly organized in development of our plans, as can be seen by the Gantt chart below that we use to develop and plan the work needed to be done over the time period that we have.
Methodology and Implementation Plan
During this time of the development process, we study the business in question for two weeks in its operations without the use of our software. Studying the business model and its operations allow us to understand better the needs of the business and the niche within which it exists. This understanding allows us to know the requirements for the system and how we can customize it further, ensuring that the business will perform at its optimum using the software. After the studying the business model employed by the said business, we go on to the second period of development
In order to have enough information to develop the system, collection of data is important. As we directly observe the companys operations, our main sources of data collection is through observation. I surveyed the store that requires the system to observe the challenges of the current system that helped me design a system that solved various problems facing current system. I also checked on the security and user interfaces of the current system through observation method. This was achieved by recording events that perform and check on the guide and protocols applied in the institution.
I had to interview both the customers or users and the staff using the system because they are the entities involved in the daily tasks of the system. I also interviewed the stakeholders to gather more information on the system they propose to have so as I could meet their requirements too during my design.
In terms of the system development methodology, we had chosen to use agile methodology. Agile methodology has multiple iterations taking place during the agile development life-cycle and each follows its own work-flow. During iteration, it is important that the customers and business stakeholders provide feedback to ensure that the features meet their needs.
The iteration process flow;
Requirements: defining requirements for the iteration based on studying the business model, customer and stakeholder feedback.
Development: designing and developing the system based on the requirements from both users and stakeholders.
Testing: this is by checking on Quality Assurance (QA) testing, internal and external training and documentation development of the system as a whole.
Delivery: integrate and deliver the working iteration into production for the functionalities in the organization or institution.
Feedback: accept customer and stakeholder feedback and work it into the requirements of the next iteration.
In this agile methodology I implemented live demonstrations, daily testing on functionalities, sharing of feed-backs and in all I had to remain agile that means that I was making changes to my process based on the feedback of customers and stakeholders to ensure each iteration improves the last to ensure system functions as required from the users and stakeholders. I had also employed testing of system until an acceptable income was achieved from which I developed the store management system. This method had allowed me to interact with end user that is customers and administration as this system requires a lot of interactions with end users on interfaces.
I used agile methodology because its more flexible, productive, transparent, optimization and reduced risks on the system being developed [3]. In agile methodology there is faster implementation of solutions, minimization of resources, adaptable to changes and optimized development processes. With the use of iteration and testing in each case it provides a system that satisfies both users and stakeholders as a better output is achieved.
The logical development phase commences after the studying of the business, and we have developed specifications for the software. In this regard, we have elected to go with the Microsoft Access database as it would be the most convenient for use in this scenario. The reasons for use of the MS Access database are as below.
Portability is a characteristic that many users appreciate. Similar to an Excel file, portability refers to how easily something can be moved or copied[1]. It is simple to duplicate the database for other needs, as in a project, or to copy to different places because an Access application is in one file (but need not be). Although this function may make IT staff cringe, users often appreciate it because it offers a lot of freedom. Many people appreciate how easy Access is to comprehend and how flexible it is once they start using it.
There have been more than 25 years of MS Access. Predictions of Microsoft's collapse have been vastly overblown, even though the product hasn't improved much throughout the past ten years. It continues to be the sixth most well-liked relational database, according to DB-engines.com. I still provide support for numerous deployed Access databases at client locations, and they continue to fulfill their intended function.
Expected Results: The Deliverables
The expectation for the system is that the business will meet the main and specified objectives laid out. In meeting this objective, we treat the system as a mature system and it is released to the business owner for operations.
Personnel
Project Manager: Devaraj Tadishetty
Email: devaraj.tadishetty555@gmail.com.
This is Devaraj Tadishetty, and this project was done by myself, I have done my tasks by myself dividing it according to my strengths and weak areas. It helped me to complete the project in a good manner.
As the project lead, I am skilled in database creation and operations in Microsoft Access. Creation of software application based on Visual Basic is also a staple of what I do. I can be reached through my personal email, devaraj.tadishetty555@gmail.com.
Supporting Facilities
The completion of this project was aided by both development and documentation tools. Visual Studio, Microsoft Access, and Microsoft Word for the documentation of the project. We used Windows Operating System 10 for the development and documentation of the system.
References
[1] M. Alexander and D. Kusleika, Access 2019 bible. Indianapolis, IN: John Wiley & Sons, Inc., 2019.
[2] R. Murch, Project Management: Best practices for IT professionals. Upper Saddle River, NJ: Prentice Hall, 2011.
[3] M. Fishpool and B. Fishpool, Software development in practice. British Computer Society, 2020.
Report 1
Project Manager: Devaraj Tadishetty
Address:+1 (610) 864-2763, 26241 Lakeshore Blvd Euclid Ohio, USA. 44132.
Email: devaraj.tadishetty555@gmail.com
Research detail
The Grocery Store Database Management research project aims to research the viability and application of a database system to grocery stores in a way that will help the grocery store owners streamline their operations to minimize resources used and maximize profits accrued. The database system in question that is chosen by the researcher is the Microsoft Access database management system. Microsoft Access is an application that is bundled alongside Microsoft Office Suite. The Microsoft Access system is the most desirable for this system for its following characteristics and advantages over other database systems.
Simplicity. Microsoft Access is fairly simple to use as compared to other database management systems. As long as you have Microsoft Access installed, you can create and manage your database systems with ease. Its learning curve is fairly gentle and well-explained walkthroughs and tutorials available from the official Microsoft sites.
Support. As a product of Microsoft office suites, Microsoft access enjoys long-term support employed by Microsoft itself. This means that your database will be fairly stable and well supported by the manufacturer for a long time to come. It also has a great online community that helps in troubleshooting issues.
Portability. Portability refers to how easily something can be moved or copied. It is simple to duplicate the database for other needs, as in a project, or to copy to different places because an Access application is in one file.
After the database has been developed, we seek to test it by exposing it to a real-life scenario in the operation of the business to confirm its viability to the business. There is also the development of an accompanying application which will assist the business in creating an interface that the user can interact with easily and manipulate or access data.
Mission Statement
In regards to this current project, our mission statement of quality and efficiency shines through as we seek to deliver software that works to expectations while being light enough and less resource intensive.Support DialogueDeveloper: What is your current system and how do you operate it on a normal day to day business basis? What functions does it serve?
Grocery Manager: On normal days, we have the cash register that helps us keep track of purchases from the store, whle we have a ledger book to record our inventory, as it is delivered to us.
Developer: Is your current sysem serving you well enough? Would you consider an upgrade? And what kind of flaws does it have that most affect your business?
Grocery Manager: Our biggest challenge is on the human error side as some items do not get recorded or go missing totally. The calculations are also difficult and time consuming and we would prefer a more digital or automatic system.
Mission Objectives
The mission objectives for the database system are as follows:
Allow recording of inventory
Allow report features to know purchases made on daily basis
Show different trends in products
Allow different users and permissionsSupport Dialogue
Developer: What kind of data would you want the system to keep track of?
Grocery Manager: Basically, the shops daily operations, purchases going out and inventory coming in. We would also want to know how much stock we have and at least maybe get warnings or alerts if our stock is running low
Developer: Anything else you can think of to be added to the database
Grocery Manager: We would appreciate having various types of reports over time to have a way of predicting and forecasting on the business. So we would appreciate a report generation feature
List of subjects
Employee
Customer
Product
Supplier
Sales
Users
Preliminary table list
Employee
Customer
Product
Supplier
Sales
Users
Final Table List
Name Type Description
Employee Data Details pof the people who work within the store including names, Ids, addresses
Customer Data Details of people who are served by the store, may include names, ids, addresses, phone numbers
Product Data Items that are delivered to the store and stored as inventory or sold as products
Supplier Data Companies or people that serve the store by delivering products to the store
Sales Data Collection of all the items that have already been sold by the store
Users Data Collection of all the people who have permission to access varuious levels of the store or database system
Permissions data Attributes that define which user can access which part of the database and which parts are out of bounds for them
Table Structure
Tables shall consists of columns of various elements, such as ID and Name and be populated by the items on the rows.
Final table structure of table would involve no calculate, duplicate or redundant values, and can be seen as an example below in the employee table.
Support Dialogue
Developer: Who works in the store and how do you record their data and who they have served
Grocery Manager: As stated earlier, we make use of a cash register, as we have one available. It prints out who has been serving the customers, although that is not fool proof. It has its disadvantages. The ledger book also helps in recording movement of inventory.
Table Structure list
Employee ID
Employee name
Employee rank
Employee address
Product ID
Product name
Product price
Product quantity
Supplier ID
Supplier name
Supplier address
Customer ID
Customer name
Customer address
List of characteristics
Address
Name
Sales
Purchases
Totals amount
Product Name
Shipping address
Product ID
Supplier name
Employee name
Employee ID
Supplier name
Supplier ID
Customer name
Customer ID
Support Dialogue
Developer: How do you update your records to reflect the most recent transactions
Grocery Manager: Given our ledger book, we take half an hour after we close down to recap all that we had done that day and correct errors. Although this method is time consuming and not convenient, we have no other options
Preliminary Field List
Product Sales
Supplier first Name
Supplier last Name
Supplier ID
Supplier Address
Employee ID
Employee first name
Employee last name
Employee Address
Product ID
Product Name
Quantity
Total Amount
Date
Customer ID
Customer first name
Customer last
Customer Shipping Address
Sales total amount
Final Preliminary Field List
Product Sales
Employee Address
Product ID
Product Name
Product Quantity
Customer Shipping Address
Sales total amount
Supplier Address
Supplier Product
Calculate List
Quantity Stock
Total Amount
Customer Full name
Employee full name
Supplier full name
Value list
Date
Currency($)
Implementation details
Research implementation has been done through data collection methods. Direct data collection is favored over indirect data collections as we are on site which allows us to be the first hand interation or entry point for the preferred data. The chosen data collection method is the performance of interviews and observations. Observation was chosen as it allows us to monitor the business in its natural surrounding without us creating any interferences that would hinder the observation process or creating any pretences in the environment that would bias or mislead the data. The method of observation is chosen because of the following reasons.
Independent of People's Desire to Report :Observation does not depend on people's willingness to divulge personal details. Many people find it difficult to talk about themselves with an outsider. Some folks don't have the time or the necessary abilities to give the researcher crucial information. Even if observation cannot always solve these issues, it nevertheless demands less active participation and willingness from the subjects. It is always feasible to observe without the subjects' awareness.
Very Accurate :The researcher must rely on the data that have been collected when using alternative methods, such as an interview or questionnaire. These are therefore indirect approaches, and the investigator is unable to check the veracity of the information they have provided. However, during observation, the observer can immediately verify the observed's correctness. He can use a variety of tools to check the consistency of their behavior. The data gathered through observation is frequently more accurate than that gathered through questionnaire or interview.
The observation was carried out by arrival at the business and set up of our equipment and personnel to observe how the business runs and to record their observations as appropriately. Observation included looking at what times the business is most busy and what times it is least busy and how it affects the running of the store and its database. Questions answered were whether the business would slow down upon being busy and loads subjected to the database or it would still operate as optimum.
The second method of data collection employed was the use of interviews. Interviews are mostly one on one discussions with various individuals to know how they feel about a particular subject matter, in this case, the existing system and business methodology in service at the store. This method was chosen to allow us read more into the interviewees feelings, as in line with the advantage of using interviews below.
Observe your feelings and actions :Without a doubt, face-to-face interviews can document an interviewee's feelings and actions. Online and mobile polls cannot accurately capture unfiltered emotions and behavior, much like verbal and nonverbal questions cannot be captured.
Precise screening :The screening process is made more accurate through in-person interviews. The interviewee is unable to give false answers in response to screening inquiries about gender, age, or ethnicity. In web and mobile surveys, screening questions can be avoided. Offering rewards in online and mobile polls may inadvertently encourage answer fabrication. In order to finish the survey and receive the reward, people could input false demographic data. Even if the individual's responses are all accurate, the data will still be unreliable and deceptive when used for data analysis.
Interviews conducted with all business stakeholders shed light on what each considers important in the business and helped us determine priority areas of the system. Given this information, we wrote a requirements specification document to guide us through the development phase of the database.
Application Implementation
Environment setup :The application needs to run on Windows operating system as it is the operating system used in store. It is also a versatile and popular operating system which ensures that if there are hardware changes, the application will still be able to run with minimal issues. To this requirement, we elect to use C# as the language of choice to build the application with. In order to build the application, there is need to correctly set up the environment with which we will use, which is Microsoft Visual Studio Community. We download the application from official Microsoft sources and add components that allow us to build the application efficiently.
Building the GUI :We have chosen to use Windows forms as the method of building our graphical user interface for the application. Windows Forms, a controlled framework that was first introduced in 2002, is the oldest and most popular desktop technology based on the Windows graphical device interface (GDI) engine. It provides a fluid drag-and-drop environment for Visual Studio user interface development. Making visual components from code isn't simple because Windows Forms relies on the Visual Studio Designer as the primary tool for UI development. The key features of Windows Forms are enumerated in the list below:
It is mature technology with a ton of documentation and code samples, which makes development that much easier as you are bound to get sufficient support and troubleshooting.
Effective and powerful designer. Designing UI "from code" is not very practical. This allows you to envision the UI as you need it be and drag and drop features in a way that makes it easier to accomplish the UI goals
Because of the drag-and-drop capabilities of the designer, it is simple and easy to learn.on any Windows version supported.
Database Design with Application Project
Database Design with Application
Your assigned topic for develop database design with application, which is standalone application, for your term project. The project progressive report should be update and turn in every week. Its format should be single space, Times New Roman font, 12 font size, and fully justify on text. The project progressive report should be at least one page for each report, which will add to previous week repots to turn in. At the end of semester, your project progressive report will be at least 6 pages. Each progressive report will due at Sunday midnight every week. The project progressive report should include both technical and managerial aspects of your project. You are also needed to market your project in a technical project proposal (so your proposal will be selected over other competing proposals). Make sure you provide a Road Map in each section and make sure you have transition paragraphs in the proposal.
Database development requirements:
At least 3 Interface for application (Service/Product, HR, Vendor.etc. for the application).
ER Diagram
Database should design in Microsoft Access
Database Application requirement:
The project documentation that including project proposal and project progressive report.
The database application (Whole project program, which is Visual Studio project folder.)
The instruction manual for how to use your designed database application.
PowerPoint Presentation for sale your application on the market.
Project Proposal (see Database Project Proposal file)
Title section
Topic Research and Executive Summary
Statement of work
Project Management Approaches, Schedule and Milestones
Methodology and Implementation Plan
Expected Results: The Deliverables
Personnel (Students Information)
Supporting Facilities (Tools)
Timeline for Term Project:
Assigned Topic: 7/5/2022
Database Project Proposal due: 7/10/2022 midnight
Project Progressive Report: 7/11/2022 ~ 8/12/2022 (Due at Sunday every weeks)
Project Presentation: Write in PPT slide note section.
Database Project due : 8/12/2022 midnight.
