Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
STAGE 2 - XML/XQueryConstruct XML representations for the following. Express your design using a diagram and/or a schema.1. Composition of courses, i.e. a list of the modules that make up a course. You may assume that the composition of a course does notchange.2. Pre-requisite information for modules, i.e. modules that must be taken before that module can be taken.3. Module enrolment - list of students taking the module.4. Module results. The results field should be optional, to distinguish between the current and completed runs of a module.a. For each module, list of final marks for each student. Marks are in the range 0 -100.b. Other possible results for a module. For these purposes, these are limited to include:i. Medical resitii. Resit - for other reasonsiii. Fail - by virtue of not submitting coursework, or notturning up to exam. This is different to a mark of 0.Then construct XQuery expressions to answer the following questions.1. List the module results for a given student2. List the module results for a given course3. List the student results for a given course4. List any students with an invalid programme - this includes:a. Students enrolled on modules that are not part of their courseb. Students who have not taken the prerequisite required for a particular module.c. Students who have not reached a mark of at least 30 in all the pre-requisite modules for a given module. List the prerequisitemodules concerned.For sample data: a subset of the MSc course structure in the Faculty of Technology, Design and Environment will be used. Some synthetic data are provided (i.e. data not taken from real students) Folder STAGE 2The module structure for the courses CM51, CM79 and CM85 is contained in the spreadsheet "module matrix.xls".Modules acceptable to a course are denoted by "a", compulsory modules are denoted by "c".Modules for which there is a blank entry are not acceptable for that course. 8 The prerequisite structure is contained in the spreadsheet module"prerequisites.xls". Each module has either one or no prerequisites. A prerequisite module must be taken and a mark of at least 30 attained. Enrollment of students in modules is contained in the spreadsheet students_to_modules.csv (in .csv format).Marks for each module taken are in the spreadsheet mark_sheets.csv. This again is in .csv format. Marks are in the range 0 to 100. There are also some non numerical values, fail, resit and medical resit.An XML version of the marks can be found in the file mark_sheets.xmlFor the information that is contained only in spreadsheets, you may represent this in XML however you like.You may use the file new_mark_sheets.xml directly if you wish. Alternatively if you wish to modify the format you are free to do so.You may find it convenient to use XQuery to convert one XML representation into another.Some of the student programmes contained in these files have deliberately been made invalid - for example missing prerequisite modules and modules taken that are invalid for the particular course of study. One of the tasks is to identify these.
The Hi-Fi Modem Company has just designed a new frequency-modulation modem that uses 64 frequencies instead of just 2. How many bits per second can this modem transmit, using synchronous transmission?
1. Is Wireshark open-source or proprietary? 2. What is seen in each of the three panes that display the packets seen on a local area network?
Strategy to upgrade the company's current infrastructure to support the new employees and recommend one strategy to create a high-performance network
What do you think is the "traffic demand information" in this research i.e. what metric is used for traffic demand information and explain briefly how the "polling mechanism" will work to distribute the traffic demand information in this research?
What's a Malformed URL Exception? What is TCP and how does it work? How can I get the real local host IP address in an applet?
first create an abstract of your business recommendations for network solutions for large businesses. an abstract is a
If you have a class B network and want to divide it into subnets, each with 126 hosts, which subnet mask should you use? What are the four addresses (broadcast and network number) for the network starting at 131.204.18?
1. in past jobs i have been able to persuade coworkers to go along withpresenting the ideas in a dynamic exciting
Explain the role of IT in monitoring compliance with the organization's risk management policies and plans when outsourcing the identified IT function.
Describe and implement Virtual Local Area Networks (VLANs) on a computing network. Compare and contrast dynamic routing, distance vector routing, and link-state routing protocols.
write a 1050- to 1750-word paper in which you discuss the content in each site the professionals involved and how the
part aevery home football game for the last 8 years at eastern state university has been sold out. the revenues from
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd