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

Describe the statement in sql which allows to change, Describe the statemen...

Describe the statement in SQL which allows to change the definition of a table? In SQL Alter statement is used to allow the changes the definition of a table.

What is a virtual table that draws its data from the result, What is a virt...

What is a virtual table that draws its data from the result of an SQL SELECT statement? View is a virtual table that draws its data from the result of an SQL SELECT statement.

Recovery management component, Ask question #Minim 100 words accepted#what ...

Ask question #Minim 100 words accepted#what is recovery management component in database management system and how it is useful

Erd, er diagram on cosmetics.

er diagram on cosmetics.

Data warehouse, XYZ is a large chain of home entertainment rental over 100 ...

XYZ is a large chain of home entertainment rental over 100 stores distributed over all states in Australia. XYZ lends entertainment products such as movies, TV shows and games on v

OLAP CUBES, 1) Define a job scheduling strategy that will meet business req...

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

With the help of a diagram defines typical element modules, With the help o...

With the help of a diagram defines the typical element modules of a DBMS? The functional elements of a database system can be widely divided into: 1) Storage manager and 2) q

What three major types of actions includes databases, What three major type...

What three major types of actions includes databases? Briefly discuss these The three major types of actions including databases are: (i) Defining: It includes specifyin

How does oracle act as odbc and give example for front end, How does Oracle...

How does Oracle act as ODBC and give examples of front end uses with ODBC? ODBC achieve portability at the level of the executable by introducing an extra level of indirection.

What are the comparison operator in sql, What are the comparison operator i...

What are the comparison operator in SQL? Comparison operator in SQL are =, LIKE and BETWEEN

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages