NZDB650 Applied Computing For the Development Process

Describe about the Applied Computing For the Development Process.

Answer:

Requirements identification:

Introduction

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.

An alternative solution

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.

Additional features which are available within Microsoft Access: -

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.

Database design

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.

Test plans: -

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	Not add “ABC" date	Add the actual date in date format.

Data dictionary: -

Table Name	Attribute Name	Data type		Length	Key (P/F)	Table name of the foreign key	description	Validation Requirements	Default value
Author	Author_No	Text	255		PK	-	the unique id of recipe book author	required	-
Author	Author_Name	text	255		-	-	author name	required	-
Categories	Category_No	Number	Long integer		PK	-	unique define recipe's category	Required	-
Categories	Name	text	255		-	-	Category name	required	-
Recipe	Recipe_No	Number	Long integer		PK	-	unique define the recipe	required	-
Recipe	Book_No	number	Long integer		FK	Recipe_Book	one recipe has one book	required	-
Recipe	Category_No	Number	Long integer		FK	Categories	one recipe has one category	required	-
Recipe	Recipe_Name	text	255		-	-	Name of recipe	required	-
Recipe	Ingredients	text	255		-	-	recipe's ingredients	required	-
Recipe	Instruction	text	255		-	-	Recipe’s instruction	required	-
Recipe	Picture	OLE object	-		-	-	a picture of the finished recipe for the user to view	required	-
Recipe	Book_Page_No	Number	Long integer		-	-	recipe Book page number	required	-
Recipe_Book	Book_No	number	Long integer		PK	-	the unique number of the recipe book	required	-
Recipe_Book	Book_Name	text	255		-	-	recipe book name	required	-
Recipe_Book	Publisher	text	255		-	-	book Publisher name	required	-
Reciepe_Book	Publisher_Date	Date	date		-	-	recipe book publisher date	required	-
Recipe_Book	Author_No	Text	255		FK	Author	foreign key from author table because one book has one author	Required	-

Self-Evaluation Report

Student Name/ID:

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.

General Comments:

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.

Basic User Documentation: -

Firstly open this database in Microsoft Access.
After that you see on the left side there are many tables, forms and reports are available.
Just double-click on any table. You will see the tables. You can also add the records in tables.
If you want open forms then double-click on any form. You can also add/ save/ delete information by using these forms. If you want to close form then click on form close button.
If you want to view reports then double click. It will display the reports. You can also print those reports.
If you want to see the relationship between the tables then click on database- tool option and then click on relationships option. It will show you relationship between the tables.

Bibliography

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.

Buy NZDB650 Applied Computing For the Development Process Answers Online

Talk to our expert to get the help with NZDB650 Applied Computing For the Development Process Answers to complete your assessment on time and boost your grades now

The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks.Â The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.

Get Online Support for NZDB650 Applied Computing For the Development Process Assignment Help Online

); }

Not the Exact Question you were looking for ? Post your question for assignment help and get instant help on your homework and assignment questions from our experts