You are designing a database for an application that manages academic papers. The program will handle information about academic papers, authors and their institutes, and application domains. The basic business rules for the data: - A paper is written by one to many authors, and an author writes one to many papers - A paper cites other papers, and can be cited by other papers as well - A paper can have many application domains, and a domain can have many papers o Example: Paper 1 has application domains of database, E/R model, information retrieval; Domain database has 10 papers - An author must belong to one institute, one institute can have multiple authors - An application domain can have zero to many subdomains, a subdomain belongs to zero or one domain o Example: database domain has subdomains of E/R model, RDM model, SQL. Computing domain does not belong to any parent domain. You have come up with the high-level E/R diagram as below Now you will move on to design the EER model for this data. Below are more requirements - Institute should have institute name, department, detailed address - Author should have name, academic degree - Application domain should have the domain name - Paper should have title, abstract, URL, and has three disjoint types: o Proceedings paper is published from a conference with conference name, ordinal number, organizer, and location (e.g. paper 1 is published from IEEE Big Data, 5th, IEEE, Seattle WA US) One conference may have many proceedings papers, one proceedings paper belongs to one conference o Journal paper is published from a journal with journal name, volume, and publisher One journal paper belongs to one journal, a journal may have many papers o White paper is not published, so there is no further information Please draw the detailed EER diagram that - Has all entities, their attributes, and relationships - Resolves all Many-to-Many relationships - Has specialized supertypes into subtypes o Remember to add an attribute in the supertype to represent subtypes This lab does not include contents from module 4 (RDM), so you dont need to include foreign keys in the entities. You can submit an image file, or a document including the diagram. Hints on resolving self-relationships (relationship of an entity to itself) Many-to-many: like other many-to-many relationships, you need to create a new entity - For example, a student can be a tutor to zero to many other students and can have zero to many tutors. We create a TutoringSession entity that include the tutor and student (after module 4, we know these two attributes become foreign keys). One-to-many: we can add an attribute in the entity itself that refer to the parent instance (the instance at the one side) - For example, an employee can be supervised by another employee, and can supervise zero to many other employees. We create a Supervisor attribute that refers to the supervisor ID. This field can be null if the employee does not have a supervisor (if they are CEO?)

You are deping a database for an application that mange academic papers. The program wil handle information about academik papers, authors and their institutes, and application domains. The basic business - A paper is written by one to many than, and an author wronto many pupurs A paper dites other papers and can be cited by other papers as well A peper can be many application domains, and a domain canharmant papers Emple: Paper has application domains of database/R model information real Demain databases 10 papers.. An author must belong to one institute, one Institute an have multiple authors An application domain can have zero to marry subdomains, a subdomain belongs to zero or one domain Esample: dabas domain has subdomains of il model, RDM model, SOL. Computing domain - - You have come up with the high level E/R diagram as below Now you will move on to the model for this data Below are more res mititute hudhnin desarrt detaldade Author should have name, academic degree Paper should have title abstract, URI, and has three difont types Proceedings paper published from a conference with conferenc e, Ordinalumber, errer, and location les paper is published from E Big Data, 5. EFE Seattle WALS) - One conference may hawe en proceedings papers, une proceedingspaper belongs to on corrence Journal paper-is published from a joumal with journal.com, volume and publisher One journal paper belong taon na ajmal may have many pupen White paper-is not published, so there is no further information Please draw the detailed ER dogram that - Has al entities, their attributes, and relationships - vel Mary-to-Many relationships - Has specialized supertypes into subtypes Remember to add an attribute in the superlype to represent subtypes This lab does not include content from mode 4 ADM you don't need to include foreign boys in the entities. You can submit an image file or a document including the diagram Hints on resolving self-relationships (relationship of an entity to sell) Many to any other many-to-many relationships, you need to create - Teresample, a student can be a tutor too many other students and can har to many tutor. We create a TutoringSession entity that include the tunor and student (her module 4. we know these two routes become foreign byl Tutoring