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 hashing in dbms, Describe Hashing in DBMS? Hashing: Hashing ...

Describe Hashing in DBMS? Hashing: Hashing is a technique to store data within an array so which storing, searching, inserting and deleting data is fast (in theory it's O(1))

Tables, does tables are called relations

does tables are called relations

What are the features of embedded sql explain, What are the features of emb...

What are the features of embedded SQL? Explain. Embedded SQL - SQL could be implemented within two ways. It can be used interactively or embedded in a host language or throu

What are audit trails, What are audit trails? An audit trail is a log o...

What are audit trails? An audit trail is a log of all alters to the database along with information like which user performed the change and when the alter was performed.

Normalisation, what is 3nf

what is 3nf

Schema, What is schema

What is schema

Describe interfaces for the dba, Describe Interfaces for the DBA? Inte...

Describe Interfaces for the DBA? Interfaces for the DBA - Most database systems holds privileged commands which could be used only through the DBA's staff. These involves com

Sorting-stacks, 1. Identify the comparisons and exchanges made to sort the ...

1. Identify the comparisons and exchanges made to sort the following array using the selection exchange sort technique. Note: you may not need all columns. Ori

In an e-r diagram an entity set is represent by, In an E-R diagram an entit...

In an E-R diagram an entity set is represent by? In an E-R digram entity set is represted by rectangle.

Explain physical and logical independence, Define Physical and Logical inde...

Define Physical and Logical independence Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages