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 Domain Name System provides services critical to the operation of the network. And yet there have historically been problems with the DNS. What are these problems, and how can they be addressed?
Depict a network topology graphical model of the initial environment of 10 employees using Visio or its open source alternative software. Note: The graphically depicted solution is not included in the required page length.
A satisfactory assignment document has been prepared; a network has been created and is depicted in a diagram in the assignment document and graphs which explain the behavior of the network in its original setup are presented including the throughp..
question youve been hired to be part of the team building a mission control and reporting system for a new uav system
Describe the difference between MAC Destination Address in Ethernet header and one found in ARP payload.
Assess illustrate why technical means to guarantee data confidentiality depend upon trust.
Discuss how may two routers be used to give separation of a LAN from the outside world?
What are the two main types of ACLs in Cisco - Name two types of network devices that an ACL can be applied to.
Research both legacy and VoIP telecommunications. Determine which one is more secure and why.Define what it is and how it will be used in the telecommunications model. Provide 3 sources for your ideas.
In Lipner's model consider moving the program from development into production. Write down the starting and ending security and integrity levels of this object.
What are IPv6 Unique Local Addresses the addresses which can be used inside an enterprise company at multiple sites.
Write a two to three page proposal addressing each of the stakeholder concerns. Use the technologies below for the areas of concern
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