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
The Transactions- A transaction is definite as the unit of work in a database system. Database systems that deal with a huge number of transactions are also termed as transaction p

Synonyms It allows short names or alternative names for objects. Example :               CREATE SYNONYM D30               FOR EMPD30;   Now if we give command:

Design an EER schema for the following application and translate the EER schema into relational schemas (and constraints). It is possible that some requirements cannot be captured

Ways for Selecting Data Structure Algorithms operate on data structure. Therefore, selection of the best algorithm means selecting the best data structure from whole bunch. Th

how can apply joins on table

Explain Derived and Non-Derived Attribute? In few cases, two or more attribute values are related, for instance, Age and BirthDate attributes of a person. For specific person e

When are they useful? Justify with an example. The temporary tables are commonly used to support specialized rollups or exact application processing needs. Unlike a permanent t

What is aggregate function? Briefly describe it? Aggregate functions are functions that take a collection of values as input and return a one value. SQL offers 5 built-in aggre

Define Thomas write rule Thomas' write rule: The Thomas' write rule is a modification of timestamp-ordering protocol for concurrency control. Assume that transaction T i issue

A View may be defined of as a virtual table, that is, a table that does not really exist in its own right but is instead inferred from one or more underlying base data table. T