The VedMed is a Veterinary Hospital. The hospital keeps a database of their clients, pets, employee, and inventory. This information is used to provide a better customer service and mange the everyday operations. The database includes the following information about each of the customers: customer identification number, name, address, telephone number, and e-mail address. The database records the following information about each pet that visited the hospital: pet name, type, and birth date. In addition, for each pet, a history of the visits to the doctor is kept. For each visit, the date, type of service offered, additional comments and payment amount is recorded. Detailed records about the doctors working with the hospital, is kept on the database. Part of this information is made available to the customers in order to help them with choosing a doctor that better fits their needs. The doctors' database includes: doctor's identification number, name, address, gender, area of specialization, degree earned. After visiting a pet, the doctor wrights a prescription. The prescription includes the name of the pet, name of the doctor, description, name of the medication and the quantity recommended by the doctor.

The VedMed is a Veterinary Hospital. The hospital keeps a database of their clients, pets, employee, and inventory. This information is used to provide a better customer service and mange the everyday operations. The database includes the following information about each of the customers: customer identification number, name, address, telephone number, and e-mail address. The database records the following information about each pet that visited the hospital: pet name, type, and birth date. In addition, for each pet, a history of the visits to the doctor is kept. For each visit, the date, type of service offered, additional comments and payment amount is recorded. Detailed records about the doctors working with the hospital, is kept on the database. Part of this information is made available to the customers in order to help them with choosing a doctor that better fits their needs. The doctors' database includes: doctor's identification number, name, address, gender, area of specialization, degree earned. After visiting a pet, the doctor wrights a prescription. The prescription includes the name of the pet, name of the doctor, description, name of the medication and the quantity recommended by the doctor.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Access: Tables and Controls
Alternate keys: Identify at least five keys (not already listed as PK or FK) needed by end users. These indexes would be considered Alternate or Secondary keys and are mostly used for queries and quick reporting. They may contain multiple columns.
Consider the following set of requirements to maintainaSmartBuy store database: •You should record the store with store ID,store name,and location.There are more than one stores inacity,one store isasupervised store. •Stores sell items.You should record each item as item code,name,and price.Different stores may supply different prices for same item. The database should also maintain customer information.You should record the name,address, and phone number of each customer. An invoice is written forasingle customer,butacustomer can have many invoices.You should record invoice number and the date of an invoice issued. •You should record items of each invoice which describe the items bought by the customer.You should record the quantity of each item.According to the information above,answer the following questions: a)Indicate the name of entities,attributes,and relations.You must use uppercase to name your entities. b)Draw and then…
The use of indices speeds up query processing, although it is usually a terrible idea to establish them for every possible search key. Why?
Design your application's/organization's database. You need to create the 3 tables for each of the services offered. You must provide at least 5 examples in each of the table. There must be a table in which you have prices linked to the services you are providing. THIS IS THE NAME & DESCRIPTION OF THE ORGANIZATION FOR WHICH YOU NEED TO CREATE 3 TABLES FOR EACH SERVICE PROVIDED *Name of the Organization* :: ECOHUB *Description of the Organization* :: EcoHub is a sustainability-focused organisation that seeks to encourage environmentally friendly behaviours, increase public knowledge of environmental problems, and offer solutions for people, organisations, and communities to reduce their carbon footprint and help make the world a greener place. We think that many little individual actions can have a big influence on the environment when taken together. *Services Offered by the Organization are*1. EcoConsultancy : We provide individualised eco-consultancy services to people and…
Scenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email: In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information: In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year: Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and…
The Plaza is an apartment rental company that would like to create an online management system to keep track of apartment complex units, tenants, maintenance requests, and rental payment information. Since you are taking a database class, you are asked to assist the company in designing a database based on the following specifications. Each apartment unit has a unique number.Each unit's street number,street name, city, state zip code, number of bedrooms, monthly rent, and occupancy status are recorded. Each tenant must lease at least one apartment unit for a period of time. It is important to document the lease start date and end date. The Plaza tracks each tenant's name, SSN, home mailing address, and phone number. Each tenant is assigned a unique identifier number. Each tenant should pay the monthly rental fee by the first day of each month.Any rent due not paid by the 4th day of the monthly rental period is subject to a $50.00 late fee charge with an additional $10.00 for…
Consignment shops offer a great service to our communities in that they allow us to purchase slightly used goods at very valuable prices. The original owners of these goods bring in their merchandise to selI. Upon selling the item, the consignment shop retains 25% of the sale for their services. You are working for a local shop. Every month the database, containing the sales data produces a report that details the amount sales per each original owner. Your job is to write a program that will help analyze this data. The array of sales data is as follows: owner sales = [201.45, 550.00, 117.65, 55.25, 5.95, 365.451 Your program needs to create 4 functions accomplishing the following tasks: main: This function will call all of your other functions, in the following order: Print Sales, Find Lowest and Determine Payout. It will also print the lowest sales. Print Sales: This function will print each sale. • Find Lowest: This function will find the lowest sale and print it. Determine Payout:…
Explain the hashing method of storing records.
DATABASE SYSTEMS AllTaste Restaurant is a restaurant that is famous for its taste, so it has a lot of customers. All the flavors are here, serving typical archipelago food that has spread in several cities with various mainstay menus. However, even though it already has many branches and a large number of order transactions every day, AllTaste Restaurant does not yet have an application and database to manage transactions and data. Order recording and sales reports are still done manually. AllTaste Restaurant owners know that information technology can support their business, so they plan to build applications to serve food orders both offline and online. In the database design stage, it is known as bottom-up, top-down, and inside-out approaches. Explain the three approaches! In your opinion, what approach is used for database system development at AllTaste Restaurant? Explain why you chose this approach! What techniques do you use to collect information (fact-finding technique)?…
Scenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email: In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information: In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year: Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and…