Database Design Development - 2919 Words

MODULE: DATABASE DESIGN DEVELOPMENT ASSIGNMENT TITLE: VETERINARY SURGERY DATABASE DEVELOPMENT Table of Content Task 1 Page 2 Task 2 Page 5 Task 3 Page 14 Task 4 Page 28 Task 5 Page 30 Reference Page 32 Bibliography Page 33 Task 1 Question: AIM: Draw an Entity Relationship Data Model that describes the content and structure of the data held by Petcare. Specify the cardinality ratio and participation constraint of each relationship type. Answer: I have prepared this assignment to demonstrate an understanding of applying data modeling and analysis techniques to the design and development of database solutions. I am as a sub-contracted to design the database system supporting the Veterinary Doctor for the Petcare.†¦show more content†¦Ã¢â„¢ £ Transform second normal form table to third normal form. Un-Normalized data set: [pic] List all the data contain in the database. Un-normalized data set to first normal form. [pic] The data set represented in to be an un-normalized data set. This can be seen, for instance, if I choice the data â€Å"Animal ID† and â€Å"Owner ID† as the key of this data set and underline it to indicate the realistically and I remove redundant information. A given cell of the table for the attributes, Appointment ID, Appointment date, Appointment time, Branch name, Branch address, Branch telephone number, Branch emergency telephone number, opening hour, Doctor name, Doctor address, Doctor home telephone number, Doctor mobile telephone number, Prescription, Diagnosis made, Period of drug, Name of drug, cost of drug, Charge made, Animal ID, Animal type, Animal breed, Animal name, age and sex contains multiple values. â€Å"The relation is in first normal form if and only if every non-key attribute is functionally dependent upon the primary key.† The attributes, Appointment ID, Appointment date, Appointment time, Branch name, Branch address, Branch telephone number, Branch emergency telephone number, opening hour, Doctor name, Doctor address, Doctor home telephone number, Doctor mobile telephone number, Prescription, Diagnosis made, Period of drug, Name of drug, cost of drug and Charge made are clearly not functionally dependent on my chosen primary keyShow MoreRelatedThe Development And Design Of A Database1429 Words   |  6 PagesABSTRACT The use of agile in database development has grown over the years with the goal of improving the quality of the final product. This, however, has not always been the case. The development and design of a database doesn’t follow simple or single approach; it connects multiple processes and individuals who collectively play key roles in the process. In some instances, database development using agile methods engage in rushed deployments, neglecting the importance of testing. There are dailyRead MoreDatabase Development Life Cycle ( Ddlc )1231 Words   |  5 PagesIntroduction The database development life cycle (DDLC) is the steps involved from the start to finish of a database s life. Typically, a database’s life end when its functionality to a user is no longer applicable to the users needs. The DDLC consists of seven interdependent steps: database planning, database analysis, logical database design, physical database design, implementation and data mapping, integration and testing, operation and maintenance, and disposition (Gupta, Mata-Toledo,Read MoreEssay The Role of Database Administrator1418 Words   |  6 Pagestake the head of a database administrator of an IT department whether the size of the company is small or enormous. In larger organizations, there will most likely be an information technology group that contains the management information system department and data processing group. They are responsible not only for ensuring that the computers are available but also having reliable data on the computer and making sure the company has what it needs to meet its obligation. Database managers usuallyRead MoreDatabase Development Life Cycle ( Ddlc )1230 Words   |  5 PagesThe database development life cycle (DDLC) is the steps involved from the start to finish of a database s life. Typically, a database’s life end when its functionality to a user is no longer applicable to the users needs. The DDLC consists of seven interdependent steps: database planning, database analysis, logical database design, physical database design, implementation and data mapping, integration and testing, operation and maintenance, and disposition (Gupta, Mata-Toledo, and Monger 2011)Read MoreOnline Registration 3963 Words   |  16 PagesDESIGN AND IMPLEMENATION OF A WEB BASED ONLINE STUDENT REGISTRATION SYSTEM WITH SMS FEEDBACK. CASE STUDY: KAMPALA INTERNATIONAL UNIVERSITY . BY OTAJEREHA KENNETH ONORIODE BIT/42017/91/DF A PROJECT PROPOSAL SUBMITTED TO THE SCHOOL OF COMPUTER STUDIES IN PARTIAL FULLFILMENT OF THE REQUIREMENT FOR THE AWARD OF DEGREE OF BACHELOR OF INFORMATION TECHNOLOGY OF KAMPALA INTERNATIONAL UNIVERSITY DECLARATION I OTAJEREHE KENNETH ONORIODE, BIT/42017/91/DF declares that thisRead MoreDatabase Design and Implementation38677 Words   |  155 PagesPhyloInformatics 7: 1-66 - 2005 Relational Database Design and Implementation for Biodiversity Informatics Paul J. Morris The Academy of Natural Sciences 1900 Ben Franklin Parkway, Philadelphia, PA 19103 USA Received: 28 October 2004 - Accepted: 19 January 2005 Abstract The complexity of natural history collection information and similar information within the scope of biodiversity informatics poses significant challenges for effective long term stewardship of that information in electronicRead MoreDad (Data Analysis and Design)1117 Words   |  5 PagesData Analysis And Design BTEC HIGHER NATIONAL DIPLOMA Assignment Institute Name : IDM Computer Studies Pvt. Ltd. Unit Name : Data Analysis and Design Unit : Unit 13 Assignment Title : Understanding and Analysis, Design and Implementation of Database system. Date given : 10th May 2010 Date to be submitted : 20th July 2010 Lecturer : Mr. T. Shanakr Rational The objective of this assignment is to assure that theRead MoreDevry Bis 245 All Ilabs Week 1 - 7 - Latest If You Want to Purchase a+ Work Then Click the Link Below , Instant Download Http: //Www.Hwspeed.Com/Devry-Bis-245-All-Ilabs-Week-1-7-Latest-49449044.Htm?Categoryid=-1 If You1403 Words   |  6 Pagesbusiness situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the requirements. 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. Scenario: You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gainRead MoreDatabase Design Concept1054 Words   |  5 PagesApply the database development cycle to a given data set Database development creates enterprise data modeling, which forms the range and wide-ranging contents of organizational databases. There are 5 phases in Database Development Cycle: Planning; Analysis; Design; Implementation and Maintenance. Planning In Planning Stage, the organization needs to know why do they need the database; what do they want the database to do; and how are they going to make the database. This is also where theRead MoreData Modeling Concepts1133 Words   |  5 Pagesdata models and the importance of data model. Building a good data model helps organizations in software development, data base design and product maintenance. The document explains the theory, even if it looks like the organizations are spending substantial amount of resources on developing data models, but still it helps organization, keeping the costs low and build a better product. Database constitutes of data structures and is represented by conceptual data structures. Data models are abstract