my selection is student union but i did it completely wrong so in order to do ca 2 i have to show where i went wrong with ca1
i have a diagram that you say is an ERD but it is not even 1% looking like an ERD. You need to decide what data you want to capture and then categorise it into entity’s, i.e student can be one and society can be another plus another 3 entity’s but then how are they linked in relation to data, not real life but data, these are two completely different things.CA Project 1 Specification Databases for Business CA Project 1 Requirements : Overall course value: 20% Due Date : Sunday 12th March 11.55pm Team Rules • The Class should form itself into teams of 2. No higher number of 2 will be accepted. • Anyone having difficulty finding a team member will have to complete the project on their own. I will not be creating any teams so please do not ask. • Teams must select an option for their database project from a list provided in Moodle under CA Project Selection. The list provided allows the selection of 2 teams per project. Once an option in the list is labelled full then you cannot select it and you will have to select another option. • Teams may agree by consensus to award a percentage of the final grade to each team member based on the effort and performance of respective team members. For example, if one member was not a significant contributor, the team may decide to award that person only 80% of the final grade achieved. If the team were awarded 70% then that person would receive 80% of 70% i.e. 56%. If no effort breakdown is submitted, all team members will receive 100% of the final grade awarded. It should be noted that this can only be arrived at by consensus. i.e. with the consent of all of the Team members. 50% shall be the minimum that can be awarded to any Team member. Submission • Projects should be submitted via moodle as MS Word or PDF versions only. No paper copy of the project will be accepted. • The submission document should be written in Business English. • Late projects will be penalised at the rate of 20% per day of your final mark past the deadline. This will be strictly enforced. • The final project submission should run to at least 2,000 words. Teams should understand that this is the MINIMUM requirement. Penalty for under word count is 20%. The Project The project should be an analysis of a business process used within a real world organisation. You must design a database for a small company/service/group based only on the option you have accepted from the list provided in Moodle. DO NOT create a system for the entire running of a company, just a small section of it. The following needs to be included and in this order: • Analysis ❖ Similar to the labs 1-3, an analysis of how the company/service/group currently or will operate the system you will build. ❖ Keep it simple, select a small element of the company/service/group. For example, a company wishes to do online trade/delivery’s or a booking system. • Objectives ❖ Discuss any assumptions, discuss the entity’s you have selected and why. ❖ The purpose of your selection, what you intend to do, what information is required to be stored in the database and what functionality you intend to build into the database. • Entity Relationship Diagram ❖ Similar to the labs, build an ERD based on your analysis, 5-8 Entity's required (5 being the minimum, 8 maximum). • Data Dictionary ❖ Based on the ERD, include PK, FK & data types for each entity/attribute. • Process Maps ❖ One main process map based on the analysis and Two sub process maps based on the main process map. ❖ One cross functional (Swimlane) diagram based on main process map. • Critical Success Factors ❖ At least 5 CSF on the running of the system you created and an explanation for each. Grades will be awarded in the following categories: • Analysis (20%) • Objectives (10%) • Entity Relationship Diagram (25%) • Data Dictionary (15%) • Process Maps (20%) • Critical Success Factors (5%) • Presentation of document (5%) Student Union Name School affiliation Instructor Course Date Student Union Analysis How student union operate Every university or college has a student-run government called the "Student Union" (or "Union"). As a registered student at Heriot-Watt, you are automatically a full-fledged member of the Heriot-Watt University Student Union (that's us!) Student unions may be found at almost every university or college, however they may go by various names such as Students Association or Guild. Yay. We are part of the National Union of Students, which is separate from the University itself, as are many other student unions. Our primary goal is to speak out for students on any and all matters (whether on-campus or beyond) that affect them. Often, present or recent graduates of the Uni serve as elected student leaders of student unions. Although receiving substantial funding from the University, student unions must occasionally rely on fundraising activities and the sale of merchandise and food services in order to survive. Whilst it's common to refer to the "Student Union building" when discussing the Union itself, it's crucial to remember that the Union would continue to function even if the building were no longer in use. People, not the physical structure, are what make our student union special. The Student Union is there to assist you in any way they can. Even if your issue isn't related to your coursework, such as a disagreement with your landlord, the student union may be able to assist. If you have an idea on how things should be changed at your university, a Student Union is also a terrific place to start! This group is really attentive. Objectives Assumptions in student union The goal is to foster moral development and a productive work environment among its members. Motivating children to learn to control their own destinies while being free. Foster the growth of initiative, independence, and leadership. To further education by means of member-led activities (such as debates, talks, lectures, contests, etc.) aimed at honing their analytical skills. Motivated by a desire to cultivate an appreciation for the arts among the club's ranks. Every member of the union must abide by the College's current regulations and any future ones that may be announced by the Principal. It will not pretend to have authority over matters that are really the Principal's purview. It shall take no part in any kind of political action. Membership Every College student is an ordinary member of the College Union and has the right to vote and run for office in Union elections. All College Instructors will be considered honorary members of the Union without voting privileges. The Dean of Students shall serve as the Union's Patron. The Union's Honorary Treasurer position will be filled by the Vice Principal. College Union Executive The College Union Executive should include the Principal (Patron), Vice Principal (Honorary Treasurer), two Staff Advisers, and the Arts Club Director in addition to the student representatives. To choose who should represent their respective classes in the College Union, students will vote for class representatives to serve on an electoral college. Students in the electoral college vote on who among them will serve as chairperson, general secretary, arts club secretary, student editor, two councillors to the Mahatma Gandhi University Union, and representatives for the first, second, and third years of undergraduate study as well as the first and second years of graduate study. The Union executive meetings shall be called by the Chairperson or Secretary with the approval of the Patron and shall be presided over by the Patron or the Honorary Treasurer, or in their absence, by the Student Chairperson. When members of the Union Council have conflicting opinions, a vote is held to settle the issue. In the event of a tie, the deciding vote will be the chairperson's. The Student Chairman is expected to take personal responsibility for the order, decorum, and dignity of all College events. Without the permission of the Principal, neither the Student Chairperson nor the Secretary(s) shall invite any guests from outside the College to any College event. Entity relationship diagram ERD on student Union Data dictionary PK on student union With the goal of making student life easier, UWE and The Students' Union have signed a data sharing agreement. Sharing your information with The Students' Union allows them to better serve you and the other students at UWE who are also members by default. Your full name, DOB, gender, and country, as well as your email and phone numbers, as well as your term-time and permanent addresses and information about the specific course you are enrolled in, will be made public. Pre-registering with The Students' Union requires your data to be sent from UWE to the company that hosts their website in a safe and secure manner. You may skip entering this data again when creating an account on the Students' Union's website. This should make it less of a hassle for you to join the available sports, cultural, and extra-curricular activities, as well as other online membership services, vote in Students' Union elections, and run for student government. This document details the data that will be shared with UWE. If you are curious as to whether or whether The Students' Union (Registered name UWE Students' Union) has collected and stored any information on you, you may do so by filling out the Subject Access Request Form provided below. Data Subject Access Requests will no longer incur a charge under the General Data Protection Regulation (GDPR), unless the request is manifestly unjustified, disproportionate, or repeated. After we get your request, we'll get back to you in a month. Process maps Critical success factors As CSF was one of the first introduced topics in ISs, it has been the subject of much study. As a result, businesses need to narrow their attention to a few of critical areas to avoid being overwhelmed. and Bullen, who added to the original work. They describe critical success factors (CSF) as the few areas in which success is guaranteed in a competitive environment for a person, a group, or an entire company. The Critical Success Factors (CSF) are the few critical areas where "things must go right" for the firm to thrive and the manager's objectives to be reached. Alternatively, define CSF as "those features, circumstances or factors that when correctly sustained, maintained, or controlled may have a major influence on the performance of a corporation competing in certain industry" . There has been a lot of work done on CSF in many different contexts, including general IT projects, ERP installation projects, BPM, and education. The CSF isn't the only study approach or theory that explains user behavior and the success of technology. For instance, we utilized the IS success model to categorize the detected CSF and issues. examined the vast body of literature to determine the most important aspects of IS success (a taxonomy). This taxonomy revision communication model distinguished between technical, semantic, and effective tiers of data, with technical referring to the precision and efficiency of the system producing the data, semantic to its ability to convey the intended message, and effective to its impact on the recipient. Mason extended this idea for the IS community, expanding the effectiveness level into three categories: information reception, receiver impact, and system influence. By allocating a single characteristic of IS success to each of Mason's effectiveness levels, the group working around Masson classified systems in terms of their degrees of success. There were six factors found to be significant in determining IS success, including system quality, information quality, usage, user satisfaction, individual impact, and organizational impact; the latter two were obtained after the initial model had been modified by other researchers for their own research ten years later in 2003. The quality of the system was analogous to the degree of technical communication, while the quality of the information was analogous to the level of semantic communication. The efficacy level was broken down into four subcategories, which were reflected in the remaining variables. Usage was associated with receiving the information; user satisfaction and personal effect were associated with how the information affected the receiver; and organizational impact was associated with how the information affected the system. As the IS success model has already been widely adopted, we may use it to properly categorize CSF. This model illustrates how the various factors are interconnected. Several attributes, including system quality, information quality, service quality, and the net effect assessed by these, must be in place and performing optimally for the IS to provide incentives for its usage and satisfy the prospective user. The term "system quality" refers to the "desirable features of an information system." With IS enhancement, system quality variability is reduced. As a result, this factor has less of an impact on the results, and user expectations may be addressed more effectively. Yet, it