Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Draw the E/R diagrams for the following business rules using Gliffy. Recognize all entities, attributes, relationships, primary keys, cardinalities and constraints where suitable. Each complete entity (comprising all attributes and primary key) receives one point and each relationship (labeled with cardinalities in both directions) receives one point.  Any constraint used correctly, receives two points.

Make sure your diagrams are clear and easy to read - print two diagrams or less per page – don’t comprise the business rules in the printout of your diagrams. Include your typed name and section on all pages. Professional quality is expected.

problem 1: A laboratory has several chemists who work on one or more projects. Chemists might also use certain types of equipment on each project. Data tracked for the chemist includes employee ID, name, and phone.  Equipment attributes comprise a serial number and cost.  Project information is tracked for a project ID and start date. When a piece of equipment is assigned to a chemist working on a specific project, the assignment date is recorded. The chemist must be assigned to at least one project and one equipment item. A given piece of equipment need not be assigned and a given project need not be assigned either a chemist or an equipment item.

problem 2: A hospital has a large number of registered physicians which comprises a physician ID and speciality. Patients are admitted to the hospital by physicians. The hospital tracks the patient ID and name.  Any patient who is admitted should have exactly one admitting physician.  A physician might optionally admit any number of patients.  Once admitted, a given patient should be treated by at least one physician.  A particular physician might treat any number of patients or might not treat any patients. Whenever a patient is treated by a physician, the hospital records the details of the treatment. Components of treatment detail comprise date, time and results.

problem 3: An art museum owns a big volume of works of art. Each work of art is describeed by an item code, title, type and size; size is further composed of height, width, and weight.  A work of art is developed by an artist; however the artist for some works is unknown.  An artist ID, name, date of birth and date of death (which is null for living artists) is recorded for each artist.  Only data about artists for works currently owned by the museum are kept in the database. At any point in time, the status of a work of art is either on display at the museum, held in storage, away from the museum as part of a traveling show, or on loan to the other gallery. If on display at the museum, the art's location in the museum is recorded. If the art work is in storage, storage date and return date from storage are recorded. A traveling show is describeed by a show ID, the city in which the show is currently appearing and the start and end dates of the show. Most of the museum works might be part of a given show and only active exhibits with at least one museum work of art need be represented in the database. Lastly, the museum wants to retain a complete history of loaning a work of art to other galleries; a gallery ID, name and city are recorded for other galleries. Each time a work of art is loaned, the museum wants to record the date the work was loaned and the date it was returned.

problem 4: A technology company gives offerings to its customers. Offerings are of two kinds; products and services.  Offerings are recognized by an ID and description.  In addition, products are describeed by product name, standard price and date of first release; services are describeed by name of the company's unit responsible for the service and conditions of the service. There are repair, maintenance and other kinds of services. A repair service has a cost and is the repair of some product; a maintenance service has an hourly rate.

Fortunately, some products never require repair. Though, there are many potential repair services for a product. The customer might purchase an offering and the company needs to keep track of when the offering was purchased and the contact person for that offering with the customer.  Unfortunately, not all offerings are purchased. Customers are recognized by an ID, name, address and phone. When a service is performed, that service is billed to a customer. As some customers purchase offerings for their clients, a customer might be billed for services he or she did not purchase, and also for ones that were purchased.

When a customer is billed for a service (though some might never require a service of any type), the company requires to keep track of the date the service was performed, the date the bill is due, and the amount due.

problem 5: PROJECTS INC., is an engineering firm with around 500 employees. A database is needed to keep track of all employees, their skills, projects assigned and departments worked in. Every employee has a unique number assigned by the firm, needed to store his or her name and date-of-birth. If an employee is currently married to the other employee of Projects, Inc., the date of marriage and who is married to whom must be stored; though, no record of marriage is needed if an employee’s spouse is not also an employee. Each employee is given a job title (for illustration, engineer, admin assistant, foreman, and so forth).

We are interested in collecting more data specific to engineers and admin assistants. The relevant data to be recorded for engineers is the kind of degree (ex: electrical, mechanical, civil, and so on); for admin assistants, it is their typing speed.

An employee does only one kind of job at any given time, and we only need to retain information for an employee’s current job. There are 11 different departments, each with a unique name. An employee can report to only one department. Each department has a phone number.

To procure different kinds of equipment, each department deals with many vendors. A vendor typically supplies equipment to many departments. We are needed to store the name and address of each vendor.

Most of the employees can work on a project. An employee can work in many projects (for illustration, Southwest Refinery, California Petrochemicals and so forth) however can only be assigned to at most one project in a given city. For each city, we are interested in its state and population. An employee can have lots of skills (preparing material requisitions, checking drawings and so forth), however (s)he might use only a given set of skills on a particular project. (For illustration, employee MURHPY may prepare requisitions for Southwest Refinery project and prepare requisitions and also check drawings for California Petrochemicals.) Employees use each skill which they possess in at least one project. Each skill is assigned a number, and we should store a short description of each skill. Projects are distinguished by project numbers and we must store the estimated cost of each and every project.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M9502

Have any Question? 


Related Questions in DBMS

Home libraryisbntitleauthor Home Library I SBN Title Author LastName Author_FlrstName

Home Library I SBN Title Author LastName Author_FlrstName Publisher Date Edition Media 369852 Cosmos Sagan Carl Random House 1980   Book 741258 No Secrets Simon Carly Elektra 1972   CD 654789 Symphony No 3 Dur Eroica Op ...

Db questions1 what is a consistent database state and how

DB QUESTIONS 1. What is a consistent database state, and how is it achieved? 2. List and discuss the five transaction properties. 3. What is a transaction log, and what is its function? 4. What is a deadlock, and how can ...

Upload your final project code and your presentation upload

Upload your final project code and your presentation. Upload all of your code in one large text file that has the .sql extension. Be sure to identify each section of code so that the reader will know what it does. All co ...

List the different types of locks used by dbms systems and

List the different types of locks used by DBMS systems and explain how they differ from each other. Additionally, suggest the suitable scenario for each of them. 400 to 500 words, at least 4 references with one website r ...

Database worksheetuse the attached database to complete the

Database Worksheet Use the attached database to complete the following: Create a simple excel spreadsheet with data to update the database. >>> This can hold any type of data to be used in this database In MS Access 1. C ...

The following assignment is based on the database

The following assignment is based on the database environment designed in the Week Three Individual Assignment. Your database project must meet the following requirements: • Create a database using professional principle ...

Brief-the aim is that your team should produce a

Brief- The aim is that your team should produce a requirements document that describes the problem to be solved and captures the requirements for an information system that supports the needs of the vehicle pool manager ...

Database management systems assignment-overview-for this

Database Management Systems Assignment- Overview- For this assignment you will implement and query a database from a supplied ER Diagram and Schema.  You will be required to write the SQL statements to create the databas ...

Database relationsusing the invoice table structure shown

Database Relations Using the INVOICE table structure shown in Table, do the following: ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE INV_NUM 211347 211347 211347 211348 211349 PROD_NUM A ...

Your assignment should be submitted in a single word doc

Your assignment should be submitted in a single Word doc (.doc or .docx). It should include your scenario diagram for Problem 1, and your Ruby source code for Problems 2 and 3. Contact me or post to our discussion board ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate