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)

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.


Related Discussions:- Create table and insert data manufacturer-dbms

What is property - properties of a database, What is property - properties ...

What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and

Single and multi valued attributes, Attributes having a one value for a par...

Attributes having a one value for a particular entity. For instance, Age is a single valued attribute of a student entity. Attributes  that  have  more  than  single  values

What are the various symbols used to draw an e-r diagram, What are the vari...

What are the various symbols used to draw an E-R diagram? Explain with the help of an example how weak entity sets are represented in an E-R diagram. Various symbols used to d

horizontal fragmentation, Horizontal Fragmentation- Horizontal fragmentati...

Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b

Explain the togaf framework for enterprise architectures, Question: (a)...

Question: (a) With the help of a diagram, explain the TOGAF framework for enterprise architectures. (b) Where would you position enterprise architectures in an enterpri

What is repository?, Problem 1 Why are the operational system keys not ...

Problem 1 Why are the operational system keys not recommended for forming data warehouse primary keys? Give any two examples 2 Explain the following performance tuning techn

Project, I have a small project that contains 3 deliverable s. I have done ...

I have a small project that contains 3 deliverable s. I have done the first one and I would like you to help me with second one

MS Access 2010 - Form Updates Table, Hi there, Have an issue with my Databa...

Hi there, Have an issue with my Database. I have: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit Whenever I add data into the Form, it will update the table as expect

Assignment, Birla Institute of Technology & Science, Pilani Work-Integrated...

Birla Institute of Technology & Science, Pilani Work-Integrated Learning Programmes Division Second Semester 2012-2013 EC-1 Assignment 2 (7.5% of the grade) Course No. : SS ZG

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd