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

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)

1475_course.png

Course(Course_Number#, CourseName, Pre_Req_Course_Number)

1424_Manufacture.png

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.

Posted Date: 2/28/2013 4:09:10 AM | Location : United States







Related Discussions:- Create table and insert data manufacturer-dbms, Assignment Help, Ask Question on Create table and insert data manufacturer-dbms, Get Answer, Expert's Help, Create table and insert data manufacturer-dbms Discussions

Write discussion on Create table and insert data manufacturer-dbms
Your posts are moderated
Related Questions
what is check point in database management system

How persistent programming languages differ from traditional programming languages? Database languages vary from traditional programming languages in that they directly manipul

What exactly is the concept of Functional Dependencies? And how do we associate this concept with the logic of Super-keys, Candidate Keys, etc? Given Relation R(A,B,C,D,E) with de

what is Nested relational model? Explain with examples.

List some instances of collection types? a) sets b) arrays c) multisets

Design a gennalization and specialization hierarchy for an automobile sales company

what is the need of a log in dbms

Candidate Key:  In a relation R, a candidate key for R is a subset of the set of attributes of R, which have the differnt two properties: (1)        Uniqueness:                N

Mention the type of constraints we can specify in the CREATE command of DDL. The type of constraints that can be specified are as follows:- PRIMARY KEY, NOT NULL, UNIQUE, FOR

Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. A long-standing international treaty am