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

Backup - restore utilities, These are designed to reduce the effects of a d...

These are designed to reduce the effects of a database failure and make sure a database is restored to a consistent state if a failure does arise. Manual backup/restore utilities n

Logical operators-logical operators, Logical Operators Rules of Preced...

Logical Operators Rules of Precedence: Order evaluated Operator 1 All comparison operators 2

Linear commit protocol, With the linear commit protocol, sites are connecte...

With the linear commit protocol, sites are connected in a chain, and the subtransaction at the left-hand end of the chain initiates the protocol. Propose a crash recovery protocol

Implementation of integrity rules, Question 1 Describe the following- ...

Question 1 Describe the following- Clustering Indexing Question 2 Explain the following with suitable real time examples- Implementation of Integrity rules

Sql, sql is relationally complete-justify

sql is relationally complete-justify

Explain the term- periodic recomputation, Explain the term- Periodic recomp...

Explain the term- Periodic recomputation Periodic recomputation: Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes p

Explain how the law ensures data protection and security, Question 1: (...

Question 1: (a) Explain the legal meaning of :- (i) Computer Service Person (ii) Data holding (b) Explain how the law ensures Data protection and Security. Qu

#cursor, #what is cursor its uses ? Explain it

#what is cursor its uses ? Explain it

DW Job Scheduling, Define a job scheduling strategy that will meet business...

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 pictori

Data model, data models are being replaced over years. Reasons and why does...

data models are being replaced over years. Reasons and why does that happen?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages