Question

database management

4.6u Dental Office Data Model For each of the following problems, create a conceptual data model, consisting of object sets, relationships, attributes, and so on, that can be used to answer questions similar to the questions given. Indicate cardinalities. PLEASE NOTE YOU WILL SUBMIT YOUR COPY USING ONE OF THE FOLLOWING METHODS Your Choice) to me USING THE UPLOAD LINK! Possible options include: 1. Hand drawn solutions can be a paper submission or scanned and uploaded as a pdf file. 2. Computer based drawing tool - can be a printed submission, or saved as a pdf file or as jpg images and inserted into a Word Document- and uploaded. 2.1 A powerful and free diagramming tool that runs in a browser is available at Lucid Chart: Saves the data in Lucid Chart Cloud. https://www.lucidchart.com/ 2.2 A popular Chrome App Plug-In drawing tool called Gliffy (Requires Chrome) Can save data on local drive. https://chrome.google.com/webstore/detail/gliffy- diagrams/bhmicilclplefnflapjmnngmkkkkpfad?hl=en 2.3 Some teachers prefer Microsoft Visio. You can get a trial version here: Not web based. All work and data saved locally. https://products.office.com/en-us/visio/visio-professional-free-trial-flowchart-software 1 Create a conceptual data model for a dentist's office. What is patient John Jacobs' address and phone number? Has he had tooth #25 pulled? What other procedures (such as root canals, crowns, bridges, etc.) have we performed for him? At the date of that appointment? which appointment did he have tooth #25 pulled? What was Were any other procedures performed during that appointment? During which appointments was the crown for tooth number 18 done? Has patient Jenifer Broward ever had a molar removed? 1 Select File... Please upload 1 file(s). Prev Next Submit Assessment

Answer 1

There are total 4 classes. Student class is inherited and publicly accessed by 2 more classesFirstYearStudent and SecondYearStudent and there is 1 more School class. So total 4 classes

In main function when School object is called 100 constructors from FirstYearStudent of Student and 100constructors from SecondYearStudent of Student and 1 of school constructor and 100 constructor of FirstYearStudent itself and 100 constructors of SecondYearStudent which means s a total of 401 objects will be created because 401 will be created.