Running head: DATABASE PROJECT 1
DATABASE PROJECT 6
Need Help Writing an Essay?
Tell us about your assignment and we will find the best writer for your project.
Write My Essay For MeName of the database
The Pet Database
The Purpose of the database
Name of the database
The Pet Database
The Purpose of the database
When it comes to the purpose of a database, the consideration made is mainly the kind of data that need to be collected. A vet doctor may need to run a database that identifies the pets and their owners whenever they visit the clinic. The pet database will collect data on various aspects of the pets and their owners. The data collection details will include details such as pet type, color, age, Pet ID, owner email, phone number, location, and membership categories. An entity refers to a place, person, or other things about which data can be collected.
The database entities
The entities are the building blocks that of the database. For this design, the entity will only be two and will have various attributes as follows. The attributes used will help distinguish one pet from the other.
1. Pet [ pet type, age, color, pet ID]
2. Owner [ Owner ID, email, phone number, location, membership]
It means that tables in the pet database will include:
i. PET table
ii. OWNER table
Due to the fact that there will be many pets that visit the clinic, the pet table will include numerous records of all types (rows) and their attributes, which will be represented by the columns the database holds. A table will look like shown below.
Pet Type
Color
Age
Pet ID
Rabbit
White
7 months
P31
Hedgehog
Brown
9 months
P32
Ferret
Grey
11 months
P33
Dog
Black
23 months
P34
As was noted in the text, the primary function of a database is to enable the search through data and gather important information. The search process usually involves sifting through bunches of information and in the event that such items cannot be differentiated from the other, it means there is no way important information will be extracted (Connolly & Begg, 2015). The database tables should contain records, referred to as rows, which must be differentiated from each other as shown in the table above. On the other hand, identifying a particular column that is able to uniquely differentiate rows in the able is considered a key element. The attribute is commonly referred to as a primary key. In this database, the pet type is considered the primary key as the other two columns cannot be considered as unique identifiers.
The Question to be Processed by the Database
The data question that the database should be able to run is:
i. “Phone Number for Pet ID.”
The goal of the question is to enable the vet find the details of the owner of a particular pet. Already, all pets will have tags with IDs on them, hence the vet will only need to run the ID on the database, and find the details about the owner.
Users and Administrators
The vet will be the administrator, meaning he will have the central control of the database. He will be responsible for the creation of new tables depending on the changing needs of the organization. Also, the administrator will carry out different types of authorization in a bid to regulate which parts of the database, the users can have an access to. The authorization is important in ensuring key information is not accessed by the users. On the other hand, the vet’s assistants are considered the users. They will interact with the system without writing any programs. However, they can write requests that will be run by the database, and the required results provided.
How Information would be Recorded and Used without a Database
Without a database, the information can be collected through the use of spreadsheets where information is fed in the columns and rows. This information will be in a table format, and will identify the attributes of the pets, and the owner. However, it means that any searches will be done manually where the spreadsheet content is searched through to find the required information. This can be tiresome may sheets are created. On the other hand, the vet clinic can use traditional filing system where a large file will be used for creating tables detailing the attributes of the pets and the owner. Also, when such a system is used, the retrieval of information will be challenging.
The Relationships between Entities
The relationship between entities is one-to-many, which means that a single row in table A can be linked with multiple rows in table B, but a single row in B is only linked with a single row in A (Lemahieu, Seppe & Baesens, 2018). The diagram below indicates the relationships between the entities.
Pet Type
Pet ID
Dog
Rabbit
Pet ID
Owner
Phone
Location
Owner ID
References
Connolly, T., & Begg, C. (2015). Database Systems: A Practical Approach to Design, Implementation, and Management (6th ed.). Upper Saddle River, New Jersey: Pearson Education, Inc.
Lemahieu, W., Seppe, B., & Baesens, B. (2018). Principles of Database Management. London, UK: Cambridge University Press.
The post DATABASE PROJECT 6 appeared first on Versed Writers.
DO MY ASSIGNMENT!Order essays, research proposal, capstone project, speech/presentation, book report/review, annotated bibliography, discussion, article critique, coursework, projects, case study, term papers, research papers, reaction paper, movie review,and more.
TOO MANY ASSIGNMENTS? Let our professional writers help you!
