[solved]-University Creating Smartphone App Allows Students Form Well Matched Project Groups Availa Q39060880
A university is creating a smartphone app that allows studentsto form wellͲmatched project groups. It is only available to the500 students doing the ‘Database Design’ assignment. Groups mustcontain either 2 or 3 students. Each individual student begins bysetting up a user profile, which must include their student number,first and last name, a short bio (no longer than 200 characters),and whether the student is full or part time. After a userregisters, they are presented with a sequence of profiles of otherusers. As each profile is displayed, the student either swipes itto the right to indicate they are interested in grouping with thatstudent, or swipes it to the left to indicate that they are notinterested in grouping with that student. Students should not bepresented with the same fellow student more than once. The serverperiodically runs software which searches for sets of 2 or 3students who have all “swiped right” on each other. When such apotential group is found, an offer is sent to each prospectivemember, checking whether they are interested in setting up thisgroup. Each recipient of the offer can respond “accept” or“reject”. If anyone responds “reject”, the offer is cancelled andthe group is not formed. If the members all “accept”, the group isregistered. Students can then give their group a name. We recordgroups in the system. While the group is working on theirassignment, the members can send messages to each other. A messagecontains 140 characters or less, and is sent by one member and seenby all the others. It is important to store these messages forlater auditing in case there are disputes among the group.Eventually, groups submit their work. They may submit severalversions, and these must all be stored, though only the most recentwill be marked. An assignment consists of an EͲR diagram (submittedas a JPEG) and a piece of text up to 3,000 words, both of which arestored in the database, not as files. After the project is over,each group member can rate each of the other members (1 to 5 stars)and if they wish, can write short testimonials about them (no morethan 100 characters). These ratings are voluntary. A student canrate another only once.
Question 1 instructions: For the above scenario, draw a physicaldata model. (You must show the dataͲtypes of columns.) UsecrowsͲfoot notation for relationships, and join the lines to therelated columns. Show the cardinalities of relationships andwhether they are optional or mandatory. There is no need to addnames to relationships. You do not need to write a data dictionary.If you wish, you may explain the reasoning behind any designdecisions or assumptions you made. Note that marks are largelybased on a workable model that enforces all the constraints statedin the case. Marks may be lost for incorrect entities,relationships, cardinalities, attributes, data types or notation,lack of detail or internal contradictions.
Expert Answer
Answer to A university is creating a smartphone app that allows students to form wellͲmatched project groups. It is only availabl… . . .
OR
