New User? Start here.
Error goes here
Muritiai Publishing wants to create recipe system to organize and manage the information. This recipe system manages and stores the information related to the recipe's books, books' authors, and details of recipes and category of each recipe. Author store all information related to recipe's book authors. Recipe bookstore information related to all recipe books. A book has only one author but an author could write multiple books. Recipe table store all the information related to recipes. A recipe will only come from one book. For each recipe, you need to know what book it comes from and what the page number is in that book. A recipe only comes from one book. Categories table store the information related to recipe category. Each recipe will be put into a category or multiple categories such as pasta, dessert or both. For each recipe, you are to include a picture of the finished recipe for the user to view.
We also create recipe database in MySQL, Oracle, Microsoft SQL etc. but for this purpose, we need to install extra software in our system. If we want to generate reports and create reports in that software then we need the extra tool for that.
In Microsoft access, we can easily create forms, reports and also generate queries. In this recipe system, I create user-friendly forms and also generate reports. I create four forms recipe form, recipe's categories forms, recipe's book forms and author form. Users can easily ass records in recipe database by using these forms. I also generate four reports in Microsoft Access. These reports display information regarding recipe system.
I used Microsoft access to create recipe system. According to me in Microsoft access, we can easily create, manage and manipulate the database.
I design the above database. This relational database full fills all the requirements those define in given case study. The strength of recipe system is User can easily add, save and delete the records from tables by using forms and the weakness of this system one recipe book has only one author. If in case one book has many authors then it creates the problem.
A Testing Plan for recipe system database
I am going to test…..
I will test it by……
What do I expect to happen?
What happened when I tested it?
How did I fix it?
Add picture name in recipe table Picture column
Add picture name in picture column instead of the picture
This column only add pictures not any other type of data
Not add picture name
Add the picture in this column instead of picture name
Insert new author
Create new author
Successfully add the new author
Not add new author with same primary key
Add new author with the different primary key.
Insert R101 recipe in the recipe table
Create the new recipe with primary key R101
Not add text data as primary key in Recipe table
Not add the new recipe with primary key "R101"
I CHANGE THE PRIMARY KEY “R101” TO “101”
Insert new recipe book with the author in recipe book table
Create the new book in recipe book table
Successfully add the new book
Not add new recipe book with the author that not present in author table
Firstly add the author in author table then add recipe book in recipe book table
Insert “ABC" text instead of the date in the date column
Create “ABC" date
Not add “ABC" date
Add the actual date in date format.
Table name of the foreign key
the unique id of recipe book author
unique define recipe's category
unique define the recipe
one recipe has one book
one recipe has one category
Name of recipe
a picture of the finished recipe for the user to view
recipe Book page number
the unique number of the recipe book
recipe book name
book Publisher name
recipe book publisher date
foreign key from author table because one book has one author
Comments on the Development Process Undertaken:
· Firstly I designed ERD according to given case study.
· Then designed tables in Microsoft Access.
· After that, I established the relationship between the tables.
· Then I designed user-friendly forms to add the data in tables.
· Then I added the data/ records in tables by using forms.
· At last, I create reports.
Strengths of the Final Product:
The user can easily add, save and delete the records from tables by using forms.
Weaknesses of the Final Product:
In given case study one author has many books and one book has only one author. I create database according to this relationship. But if one book has one or many authors then it creates the problem.
What I would do Differently Next Time:
I will create the database that removes weakness my present database. Next time recipe database able to store information related to one author has one or more books and one book has one or more authors.
I learn many things about this assignment. I learn how to create tables, forms and reports in Microsoft Access in the efficient and effective way.
Belloc, H. (1967). On. Freeport, N.Y.: Books for Libraries Press.
Cronan, J. (2010). Microsoft Office Access 2010. New York: McGraw-Hill.
Griffith, G., Bradly, T., Long, C., Ranlett, C., & Marshall, K. (2011). Microsoft Access 2010 24-hour trainer. Indianapolis, Ind.: Wrox/Wiley Pub.
Helmers, S. (2015). Microsoft Visio 2013. [Redmond (WA)]: Microsoft Press.Parker, D. (2013). Microsoft Visio 2013 Business Process Diagramming and Validation. Packt Publishing.
Knottingham, E. (2001). How to do everything with Microsoft Visio 2002. Berkeley, Calif.: Osborne/McGraw-Hill.
Microsoft Press. (2001). Microsoft Visio version 2002 step by step. Redmond (WA).
O'Leary, T., & O'Leary, L. (2011). Microsoft Access 2010. New York, NY: McGraw-Hill.
Parker, D. (2007). Visualizing information with Microsoft Office Visio 2007. New York: McGraw Hill.
Tremblay, D. (2011). Access 2010. [Fairport, NY]: Axzo Press.
Walker, M., & Eaton, N. (2004). Microsoft Office Visio 2003 inside out. Redmond, Wash.: Microsoft Press.
Wright, A., & Roth, C. (2014). Visio 2013. Indianapolis (IN): Que.
To View this & another 50000+ free samples. Please put
your valid email id.
Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.
Get Moneyinto Your Wallet
Total 6 pages, 1 USD Per Page
*The content must not be available online or in our existing Database to qualify as
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2021). Applied Computing. Retrieved from https://myassignmenthelp.com/free-samples/nzdb650-applied-computing/recipe-database.html.
"Applied Computing." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/nzdb650-applied-computing/recipe-database.html.
My Assignment Help (2021) Applied Computing [Online]. Available from: https://myassignmenthelp.com/free-samples/nzdb650-applied-computing/recipe-database.html[Accessed 28 September 2021].
My Assignment Help. 'Applied Computing' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/nzdb650-applied-computing/recipe-database.html> accessed 28 September 2021.
My Assignment Help. Applied Computing [Internet]. My Assignment Help. 2021 [cited 28 September 2021]. Available from: https://myassignmenthelp.com/free-samples/nzdb650-applied-computing/recipe-database.html.
The respective sample has been mail to your register email id
* $5 to be used on order value more than $50. Valid for
We have sent login details on your registered email.
Your dream of finding a place in the best college will become true when you avail our services for your personal statement writing. The writers at MyAssignmenthelp.com follow the appropriate personal statement template. They know how to start or conclude a personal statement perfectly. The efficiency of our writers is reflected in the personal statement examples or samples. The writers will customize your personal statement as per your requirements. If you have any doubts about what is a personal statement, you can reach out to our experts. Hire us today to prepare your personal statement for admission in colleges.
Analysis of the Remuneration System Along With Disclosure by Insurance Companies In Australia
Measuring Executive Performance
We have often heard that the employees are the life blood of the business and they need to be kept and treated as an asset of the organization, but it is very important to recognize the hands behind the success of the organization, the people who use their skills and experience to take the business at hei...
The MA research can be traced to 1950 in the U.S and was a response to the Ford Foundation work to enhance the business schools. This contained more specification on the concept of social science. There has been many cases of MA research based on social science and was done by the non accounting faculty because the accounting faculty were not experienced in the conduct of social science research. Over the years, experts ha...
Commercialization can be considered as one of the most critical steps in the concept of the technological innovation. It can be stated that it is one of the most little well managed active of the whole process of the innovation process. The launch stage can be seen to be particularly crucial in the market of high technology. This is due to the factor that it is interconnectedness, volatility and the proliferation of...
Engineering leaders need to possess certain traits such that they can achieve their strategic outfits (Reeve, 2010). While there are several traits of good leadership skills, an effective engineering leader needs to include an action mindset. Emotional intelligence including empathy, social skills, self-awareness and confidence, self-management skills, communicating ideas and directions in a capable manner and being sel...
This report presents the different strategies for developing new product and services. It also evaluates the background of the company and defines the mission of developing new products. It explains the product and service offering by the Woolworths. It also discusses the porter five forces model to analysis the food retail industry. Moreover, it defines the competition between competitors in food retail market. It also illu...
Are you confident that you will achieve the grade? Our best Expert will help you improve your grade
ACC702 Managerial Accounting
CO5103 Management Accounting
CS 1010 Computer Science
MOD003398 Innovation And Technology Management
H700 Manufacturing Engineering
SEB724 Engineering Leadership
PH311 Employee Law And Relations
PROJ6006 Marketing Communication
GRAD 695 Research Methodology And Writing
BN606 The Mental Health Context
NZDB650 Applied Computing
BN710712-Chronic Conditions And Person Centred Care
Just refer 5 friends to earn more than $2000.
After the successfull payment you will be redirected to the detail page where you can see download full answer button over blur text.You can also download from there.
Or you can also download from My Library section once you login.Click on the My Library icon
My Library page open there you can see all your purchased sample and you can download from there.
That's our welcome gift for first time visitors
It is too easy to create or access your own library, just enter your email and make your search
MyAssignmenthelp.com stores a huge
COLLECTION OF QUESTIONS AND SAMPLES, which you can refer to any time you want.
Every time you find something useful, you can save that using the bookmark tool. From the next time,
can access that from your personalized library.
With this feature, you get to create your own collection of documents. You get free
choose and bookmark any document you wish.
Accessing the collection of documents is absolutely easy. Once you bookmark a sample,
access its content with a few clicks on your mouse.
This personalized library allows you to get faster access to the necessary documents.
longer need to spend hours to locate the sample you need.
Finding a sample from a list of thousands is nothing less than spotting a needle in a
Personalizing your own library relieves you from that stress.
On APP - grab it while it lasts!
*Offer eligible for first 3 orders ordered through app!
ONLINE TO HELP YOU 24X7
OR GET MONEY BACK!
OUT OF 33845 REVIEWS
Received my assignment before my deadline request, paper was well written. Highly