Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. [q.4] answer the following questions you are invit

[Q.4] Answer the following questions You are invited as a database architect to develop database schema for...

50.1K

Verified Solution

Question

Programming

[Q.4] Answer the following questions

You are invited as a database architect to develop databaseschema for maintaining patient information for the NYU medicalgroup (make necessary assumptions for the data requirements ifneeded).

  • Each physician in the Lehman medical group is uniquelyidentified by physicianID o Each physician must have first name,and last name, and phone number

  • Each patient is identified by patientID
    o Each patient must have first name, and last name, phone number,and insurance card number (if the patient has)

  • Each patient gets a treatment from a physician.

    o Each treatment is identified by a unique treatementCode

    o Each treatment is described by a simple description

  • Patients, Physicians, and Treatments are associated by apatientTreatement relationship type. The relationship type has twoattributes to record date and time of the patient visit and patientco-payment (or minimum payment if the patient does not have medicalinsurance)

  • (a) Design a conceptual schema using ER diagram for storing andmanaging the data as explained above.

  • (b) Derive the logical database schema from the conceptualschema you designed.

Answer & Explanation Solved by verified expert
3.8 Ratings (359 Votes)
ExplanationDatamodelling is the first step inthe process of database design This step is sometimes consideredto be a highlevel and abstract design phase also referred to asconceptual designData ModelThe DataModel is defined as an abstract model that organizes datadescription data semantics and consistency constraints of dataThe data model emphasizes on what data is needed and how it shouldbe organized instead of what operations will be performed on dataData Model is like an architects building plan which helps tobuild conceptual models and set a relationship between dataitemsTypes of DataModelsThereare mainly three different types of data models conceptual datamodels logical data models and physical data models and each onehas a specific purpose The data models are    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A property costs $100,000. A borrower can obtain an 80% loan with an 8% interest rate...

Finance
Q

What role does culture play in language and thinking?

Psychology
Q

Fixed load bending moment MD = 130 kN·m, live load bending moment ML = 140 kNNm Rectangular...

Civil Engineering
Q

2-3 paragraph response. Can you think of an example of an informational ad? What information is...

General Management
Q

2 A game at the fair involves a wheel with seven sectors Two of the...

Geometry
Q

A new giant superstore is being planned somewhere in the vicinity of kneebend and Anklescratch...

Basic Math
Q

Factor the expression 2x 11x 15

Algebra
Q

Financial Statement Analysis Star Electronics Assignment Star Electronics is a small manufacturer of...

Accounting
Q

22. A standard cost system initially records manufacturing costs at the standard rather than the...

Accounting
Q

1. Find cost of capital for a company of your choice. Steps involved: Determine equity...

Accounting
Q

During August 2018, Robo Company recorded the following Sales of 115,200 $90,000 on account...

Accounting
Q

Monopolistic competition means that Multiple Choice OB no new firms can afford to enter the...

Accounting