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
E-R Model This data model is based on real world that consists of basic objects named entities and of relationship among these objects. Entities are illustrated in a database

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the delet

Relationship between Security and Integrity: Database security usually refers to access, while database integrity refers to avoidance of accidental loss of consistency. But usually

Primary Key The primary key is the candidate key that is selected by the database designer as the principal denotes of identifying entities within an entity set. The left candi

#what is cursor its uses ? Explain it

Explain the Exec statement in SQL Ans: Exec statement has the structure    EXEC SQL END-EXEC   Embeded SQl statements are of a form identical to non embedded SQL statem

How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with

Question: (a) What is ODBC and what is its function? (b) What is Web application server, and how does it work from a database perspective? (c) What does e-commerce mean

Gyan Gurukul is a software company that provides software related solution. Ashutosh Dubey who is the director of Gyan Gurukul want a three-level schema architecture for the Gyan G

how oracle can be used