Logical Data Model Database

Question: Describe about the Logical Data Model for Database. Answer: Logical data model Data dictionary Name PatientID Firstname Lastname Address Contact number CVisitID DOB synonym Patient serial number Patient name Patient Surname The location of patient Phone number Serial number data of birth Definition serial number for identify a Patient Name of the patient Surname of the patient Detail address of the patient Emergency contact Keep the track of all visit This field is used to calculate age of the patient field type Numeric Alphabetic Alphabetic Alphabetic Numeric Numeric date length 20 100 100 250 12 20 Name Doctor ID Firstname Lastname Address Contact number Specialization Patient ID synonym Doctor serial number Doctor name Doctor Surname The location of Doctor Phone number expertise in a department Patient serial number Definition serial number for identify a Doctor Name of the Doctor Surname of the Doctor Detail address of the Doctor Emergency contact Name of a particular medical section serial number for identify a Patient field type Numeric Alphabetic Alphabetic Alphabetic Numeric Alphabetic Numeric length 20 100 100 250 12 250 20 Bibliography Ashley, F. (2013). Database management system 39 success secrets - 39 most asked questions on. [Place of publication not identified]: Emereo Publishing. Chen, J. Stanley-Brown, J. (2015). RELATIONAL DATABASE LOGICAL DESIGN A CASE STUDY IN TOURISM DEVELOPMENT AND CUSTOMER RELATIONSHIP MANAGEMENT. Journal Of International Management Studies, 15(3), 19-26. https://dx.doi.org/10.18374/jims-15-3.3 Ide, M., Kavurucu, Y., Mutlu, A. (2015). Graph Representation of Relational Database for Concept Discovery. Procedia - Social And Behavioral Sciences, 195, 1981-1989. https://dx.doi.org/10.1016/j.sbspro.2015.06.212 Lee, S. (2012). Database systems for advanced applications. Heidelberg: Springer. Lee, S., Peng, Z., Zhou, X., Moon, Y., Unland, R., Yoo, J. (2012). Database Systems for Advanced Applications. Berlin, Heidelberg: Springer Berlin Heidelberg. Mondal, S., Gold, B., Mohamed, R., Alabugin, I. (2015). ChemInform Abstract: Design of Leaving Groups in Radical C-C Fragmentations: Through-Bond 2c-3e Interactions in Self-Terminating Radical Cascades. Cheminform, 46(4), no-no. https://dx.doi.org/10.1002/chin.201504031 Mglich, D., Sinn-Behrendt, A., Schaub, K., Bruder, R. (2015). Development of a database for capability-appropriate workplace design in the manufacturing industry. Occupational Ergonomics, 12(3), 109-118. https://dx.doi.org/10.3233/oer-150228 Pan, J., Chen, S., Nguyen, N. (2012). Intelligent information and database systems. Berlin: Springer. Pan, J., Chen, S., Nguyen, N. (2012). Intelligent Information and Database Systems. Berlin, Heidelberg: Springer Berlin Heidelberg. Zhao, J., Plagge, R., Ramos, N., Lurdes Simes, M., Grunewald, J. (2015). Concept for development of stochastic databases for building performance simulation A material database pilot project. Building And Environment, 84, 189-203. https://dx.doi.org/10.1016/j.buildenv.2014.10.030