Suppose the Victoria University, International Office (IO) needs a database to assist simple and fast data entry and print reports. The key information is collected from the students during their enrolment. In order to make this process fast and easy for the students, the data entry has to be as capable as possible. If the data entry takes too long the student may become unconcerned in joining the university.
The director at IO requires reporting features to facilitate them to help with rostering, roles and membership email lists. Some such reports include: organising a roster for the volunteers, finding all of the people interested in organizing a social function, printing a list of contacts etc. This will be achieved by creating a database using PhPMyAdmin and WordPress (for forms and reports design) and making use of supporting features like: forms, queries and reports. A user manual is necessary to this project as the managers are novice computer users and will require assistance for using the database.
IO, as the acronym recommends, is planned to help the students by providing a friendly place where they can meet other part-time or full-time students. Facilities and services include: a pool table, tea and coffee, a kitchen, few games and a number of social events for the students to attend. If the students have an hour break among classes then they can come to the IO lounge and relax on the couches, play pool, chat over a coffee and so on. In regard for these facilities to stay hygienic and well maintained, certain rosters are set up for the student members. These rosters are generated from the database of students wishing to volunteer for a particular job or jobs. From time to time notices and documents are sent out to the members to remind them of their allocated duties and to inform them of upcoming events and activities.
A range of jobs that need to be accomplished at the IO lounge require volunteers to complete certain tasks like, washing windows, vacuuming floors, mopping etc, and these may need to be done at certain times of the day and/or week. IO would like the database to keep track of the tasks required in each job. They would also like a record of who does what job on what day and whether it was completed or not. Moreover, University faculties, schools and the course, that students are in, are very significant to IO so that they can categorize people into study groups and for mentoring purposes. A new member can be introduced to people doing the same course or in the same faculty or school. IO would like the database entry screens to be designed for simple and easy navigation of information in the database. The first screen should contain contact details. The second screen should be about what IO can do for them, and the third screen should be what the student can do for IO.
At the time of enrolment, the interested students fill out a form giving their contact details to IO. They also indicate whether they would like to help out in the duties involved within the university. The databases are updated with new members every year. This guarantees that the current database is up-to-date. Reports are then generated from the database that helps the IO team synchronize and locate volunteers.
The database reports make it easy and simple to generate rosters, mailing lists, organise social functions and meet nutritional needs of the students. IO would like the make the data entry as simple and easy as possible for the student enrolment. They would like the reports to be easy to produce. They also recommended that each school in the university should be linked to its associated Faculty. So that somebody cannot enter “Faculty of Information Technology” and “School of Law” as this is incorrect.
Develop an Entity Relationship (ER) model to characterize the information requirements of business illustrates in the case study mentioned above. The diagram of your ER model must:
Discovered business rules for your ERD
Map the Entity Relationship Diagram (ERD) into a set of relations in at least Third Normal Form (3NF). You should show that each relation satisfies the rules for 1NF, 2NF, and 3NF.
Your report you must also include a data dictionary. You should briefly describe all entities and attributes are included, descriptions are clear, reasonable field formats, etc.
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2020). Database Analysis And Design. Retrieved from https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/develop-an-entity-relationship.html.
"Database Analysis And Design." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/develop-an-entity-relationship.html.
My Assignment Help (2020) Database Analysis And Design [Online]. Available from: https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/develop-an-entity-relationship.html
[Accessed 24 November 2020].
My Assignment Help. 'Database Analysis And Design' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/develop-an-entity-relationship.html> accessed 24 November 2020.
My Assignment Help. Database Analysis And Design [Internet]. My Assignment Help. 2020 [cited 24 November 2020]. Available from: https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/develop-an-entity-relationship.html.
From choosing the most interesting topic, writing your assignments to cite the sources, MyAssignmenthelp.com has got everything covered for you. We are the one-stop destination for any kind of assignment help Sydney solution you need in Australia. We have over 5000 professional experts who are experienced enough to deliver top assignment solution before the actual deadline. So what are you waiting for? Hurry up and order now!
Answer: Introduction The hotel business is increasing at a rapid speed and this is because of the rising requirement for the services as well as the increasing opportunities for travel. Because of this the hotels are facing demanding customers as the requirements of the quality of growth with an increase in the use of hotel services for increase in the competitive ability of the hotel with respect to the customer loyalty is ext...Read More
Answer: Introduction: The aim of the assessment is to prepare an adequate investment portfolio, which could help in improving the level of returns from investment. In addition, the created portfolio also helps in understanding risk and return attributes of the investors, where 75% of the investment is conducted in Austrian equity,20% in ETP and LIC, and 15% in cash holdings. Moreover, with the help of portfolio income from investment would ev...Read More
Answer: This structure will be the best case because when searching for a number such as 7 we are going through three steps as shown in the diagram. The worst case In the worst case there will be six move as we search for the lowest number as shown in the diagram below. The linear search algorithm is a less efficient algorithm as compare to the binary search tree. In this algorithm we sequentially go through the entire list and goes on un...Read More
Answer: Business Communication Article One: 4 Things You Need to know about Group Dynamics in the Workplace The article’s main point is to help one understand group dynamics in the workplace. It gives a further understanding of why group dynamics is important and is critical to the success of the company. In the findings, the article verifies that poor workplace dynamic can greatly affect performance leading to a negative outcome o...Read More
Answer: Purposes of E-R-Diagram and Techniques to secure databases The purpose to create an ER Diagram before the database is built The database design process requires the use of the ER diagrams as it is the database implementation foot prints that show the clear image of the resultant database that is required to be implemented, below are some of the purposes of E.R diagram in database design process. Due to its’ excellent visual ...Read More
Just share requirement and get customized Solution.
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
it was really helpful. i got my asssignment on time even before the deadline.it was written really well i am glad that I came to Myassignmenthelp.
very professional i got it before the due time i set, the sheet that was sent to me was very neat and very well done.
Great work! Really appreciate the help and efficiency. Very well organized. Thank you for your help.
given on time. well presented. and very helpful, trust these guys for all your work