Create table and insert data manufacturer-dbms, Database Management System

Assignment Help:

Create a table according to given data:

2302_relationship diagram.png

AmbulanceDriver(Driver_Number#, Name, Address, Birth_Date)
AmbulanceDriverTeam(Team_Number#, Driver_Number#, Join_Date, Leave_Date, Diver_Rating ): Team and AmbulanceDriver has one to many relationships, but in order to store driver history and joining in other team we need one more entity, that is why extra entity is required
Team(Team_Number#, Location)

Course(Course_Number#, CourseName, Pre_Req_Course_Number)

1. Manufacturer(Manufacturer_Number#, Name)

2. Bed(Bed_Number#, BrandName, Size, Length, Width)

3. Category(Category_Number#, Name)

4. Mattress (Mattress_Number#, BrandName)

5. MattressAndBed(Mattress_Number#,Bed_Number#, Comfort_Rating ): Mattress and Bed has many to many relationships, so this extra entity will be created.

Related Discussions:- Create table and insert data manufacturer-dbms

Farm management system, draw er diagram using entities crop,employee,depart...

draw er diagram using entities crop,employee,department,plot,cultivation plan,machinery,seed,fertilizer

Determine the object-oriented design process, An object-oriented design pro...

An object-oriented design process 1. Define the context and modes 2. Designs the system architecture 3. Identifies the principal system objects 4. Identifies concurrency in

Need for multiple access paths, Need for Multiple Access Paths In pract...

Need for Multiple Access Paths In practice, most of the online information systems need the support of multi-key files. For example, consider a banking database application hav

Skills required, wrie a report on whether a BSc n information systems devel...

wrie a report on whether a BSc n information systems develops the skills required by employers in Database administration

Describe the basic steps involved in recovery, Question: One of the tas...

Question: One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known

What is the meaning of redundant associations, Adding Redundant Association...

Adding Redundant Associations for Efficient Access The expression redundant association means using "duplicate association for proficient access". While analysis, it is not a

Mixed fragmentation, Mixed fragmentation: Sometimes, horizontal fragmentati...

Mixed fragmentation: Sometimes, horizontal fragmentation or vertical fragmentation of a database schema by itself is insufficient to sufficiently distribute the data for some appli

Explain what is aggregation, Explain what is Aggregation ? Aggregation...

Explain what is Aggregation ? Aggregation: This is used whenever we intend to show a relationship between an entity and the relationship. There is no provision for this in th

Differentiate between logical database design and physical, Differentiate b...

Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas

What is the difference between serial and sequential files, What is the dif...

What is the difference between serial and sequential files? How searching is applied on both? Ans: A serial file is one where the records have been stored in the order where

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages