A company, Learning TV, makes television and video programmes for a distance- learning university…


A troop, Knowledge TV, makes television and video advertisements for a distance- knowledge university. It has formal the aftercited requirements for the facts it wishes to archives encircling the evolution of these advertisements. Each advertisement is effected for use after a while a inequitable university module. A module may enjoy up to 5 advertisements associated after a while it, and Knowledge TV does not restrain notification encircling modules that do not enjoy any advertisements. Each advertisement has an identifying advertisement jurisprudence, a designation and a running era, and each module has a choice module jurisprudence and a designation. Running eras for advertisements are betwixt 10 and 45 minutes. Each advertisement is the trust of a solitary action, a limb of staff of Knowledge TV who has a staff compute, designate and telephone compute. A advertisement as-well has an advisor, one of the academic staff of the university who is attested upright by designate. The telephone compute of the academic is used for touch purposes. A LearningTV staff limb can profit more than one advertisement. Each advisor is bestown an deem of the era they conquer be expected to subscribe to each advertisement (betwixt 1 and 10 days). The climax completion equality of era all the advisors can subscribe to a module's advertisements is 40 days. An academic may be an advisor for frequent advertisements. You are to profit an E-R pattern to embody these requirements. As you peruse the extractual term over you may purpose of questions you would shortness to ask the Knowledge TV skill in ordain to extricate aspects of the requirements antecedently you can draw your E-R pattern. You should transcribe down these questions, and bestow an conjectured repartee to each of these questions such that you conquer then eliminate your E-R pattern to be compatible after a while the periodical requirements and the conjectured repartees to the questions you shortnessed to ask. Your repartees should not controvert solid periodical requirements, but should narrowly extricate aspects that you arrive-at are unclear or enigmatical in the bestown extract. The E-R pattern you profit should enclose an E-R diagram, existence types, constraints and assumptions. For each analogy the diagram should exhibition the cardinality and free-trade provisions of the apt existence types. The assumptions conquer be the repartees you gave to the straining questions you shortnessed to ask the Knowledge TV skill. Breakdown of marks beneficial for this question: Producing the E-R diagram. (10 marks) Giving the existence types. (4 marks) Giving constraints compatible after a while the scenario and any assumptions/questions pretended. (4 marks) Stating any assumptions and/or extricateing questions and repartees that stay the pattern. (2 marks)