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)


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.

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
Security: Data not needed by local applications is not stored at the site, therefore no unnecessary security violations may exist. But how can we carry out fragmentation? Fragm

1.  Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for each table (as shown in class).  Label the types of depe

Problem: (a) Given the following relation: Stats(Name,Sex,Children, Occupation, Salary, Tax, Audits) Write SQL code to define the following security constraints: (i) User

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 called a query -execution engine? The query implementation engine takes a query evaluation plan, implements that plan, and returns the answers to the query.

What is Hierarchical DBMS In HDBMS, data is structured in a tree like manner. There is a parent-child relationship between data items and the data model is very suitable for re

Explain the Role of a database administrator a. Defining the Schema   The DBA describes the schema which consists of the structure of the data in the application. The DBA

1. Use the Invoice table structure shown below to answer the following questions: a)  Draw the dependency diagram and identify the primary key and all dependencies, including al

What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur

How can we Classify the operations on classes  This step fundamentally means all three models functional, object and dynamic (studied in last section) must be combined so that