Question

In: Computer Science

Using WORKBENCH: 1. Create the database below via an ER Diagram in Workbench (take screen shots...

Using WORKBENCH:

1. Create the database below via an ER Diagram in Workbench (take screen shots of the diagram)

2. Go to the database table view and take a screen shot of the table(s)

3. Go to the data entry tool and enter at least three lines of data (in each table). Take screen shots.

Create a database that is in third normal form for the following:

You are a nerd and have decided to organize your comic books in a database.

You have decided to create categories for the books. The categories a a separate table because it includes the category name and a description of the category. The names might not be unique.

You also want to keep track of the size (width and length) of each book (I did say you were a nerd..LOL). Since several books are the same size, you decide to also keep this in a separate table.

You have books from several publishers, so you decide to create a publishers table. In the table you have the publisher and the address of their home office.

Finally, of course, you have the books table. The books table (of course) includes the name and author but also links to the other tables.

Be creative!

Make sure to populate all tables!

Solutions

Expert Solution

Explaination:

Following are the table in the database :

  • PUBLISHER
  • AUTHOR
  • CATEGORY
  • SIZE
  • BOOK
  • BOOK_SIZE

(1) ER Diagram to organize your comic books is given below:

The ER Diagram has following entities:

  • PUBLISHER
  • AUTHOR
  • CATEGORY
  • SIZE
  • BOOK
  • BOOK_SIZE

The Mapping Cardinality between the entities are as follows:

There is a one to many relationship between :

  • AUTHOR and BOOK as one author can write many books.
  • PUBLISHER and BOOK as one publisher can publish many books.
  • CATEGORY and BOOK as there can be many books of one category.

As one book can be of many size and many books can be there of same size. So we have BOOK_SIZE as entity which stores Size of every book.

(2) Table view of all the table are as follows :

  • PUBLISHER

  • AUTHOR

  • CATEGORY

  • SIZE

  • BOOK

  • BOOK_SIZE

(3) Following are the contents of the table :

  • PUBLISHER

  • AUTHOR

  • CATEGORY

  • SIZE

  • BOOK

  • BOOK_SIZE

venereology answered 1 year ago
Next > < Previous

Related Solutions

Create a database and design an ER diagram for the given question. Must link the related...
Create a database and design an ER diagram for the given question. Must link the related tables then implement the design using MySQL. Insert at least 5 records. Ensure that the data to be added are related to other tables. Follow this format in creating the database and table: Database format: databasename_yourname Table format: tablename_yourname QUESTION: Company ABC has the following business rules. A department employs many employees, but each employee is employed by only one department. A division operates...
Create an ER diagram for the requirements below. - Parts have a unique number, name, and...
Create an ER diagram for the requirements below. - Parts have a unique number, name, and production year. - Car company has a unique number, name and country information -Automakers make multiple cars. It has a serial number and a name. but, There can be no more than two companies making one car. -Parts are used in many cars. When a part is used in a car, Save the part usage date and quantity information.
Using the sample.sql script, create the sample database in MySQL. Submit the MySQL interactive screen that...
Using the sample.sql script, create the sample database in MySQL. Submit the MySQL interactive screen that results. create database sample; use sample; create table customer (custno int auto_increment primary key, firstname varchar(20), middle varchar(20), lastname varchar(20), address varchar(60), telnum1 varchar(10), telnum2 varchar(10), telnum3 varchar(10), pin varchar(6), email varchar(30)); create table accttype (id int primary key, type varchar(10)); insert into accttype (id, type) values (1,'check'); insert into accttype (id, type) values (2,'save'); insert into accttype (id, type) values (3,'cd'); insert into...
Database exercise: inpatient cases Create database using name RUMKIT Create tables below in that database patient(idPatient,...
Database exercise: inpatient cases Create database using name RUMKIT Create tables below in that database patient(idPatient, fullName, biologicalMother, birthdate, address) doctor(idDr, fullName, specialization, consulRates) inpatient(idPatient, entryTime, outTime, idDr, idRoom). Please make entryTime as column that is going to be filled automatically when care record is being add room(idRoom, roomName, cost) fill the data above to each table Create sql query and relational algebra expressions for the query Please give me detailed answer so I could learn from it. Thank you...
Draw the diagram (ER / MR / UML) for a database containing the following characteristics: •...
Draw the diagram (ER / MR / UML) for a database containing the following characteristics: • Presence sensor that stores presence information with its timestamp and its location. • Distance sensor that saves distance information with its timestamp and its location. • An actuator of a switch that energizes a bulb, where the record of its been with your timestamp and your location. • An actuator of a motor that opens a door, where the record of its been with...
Design and implement a relational database application of your choice using MS Workbench on MySQL a)...
Design and implement a relational database application of your choice using MS Workbench on MySQL a) Declare two relations (tables) using the SQL DDL. To each relation name, add the last 4 digits of your Student-ID. Each relation (table) should have at least 4 attributes. Insert data to both relations (tables); (15%) b) Based on your expected use of the database, choose some of the attributes of each relation as your primary keys (indexes). To each Primary Key name, add...
In MySql, using Application MYSQL Workbench and the Chinook database, please answer the following: -- 12....
In MySql, using Application MYSQL Workbench and the Chinook database, please answer the following: -- 12. SELECT the trackid, name and filesize (as shown in the bytes column) for all tracks that have a file size less than 2000000 and a GenreId of 1 or a file size less than 2000000 and a Genreid of 2 -- 13. Add a sort to the query from number 12 to sort by GenreID; -- 14. List all columns from the customer table...
Construct an ER diagram for a database system that models data of the following situation. You...
Construct an ER diagram for a database system that models data of the following situation. You are creating a database for a stock trading company. The company has clients and financial officers. Each client is either an individual or another legal entity (e.g. another company). A client has a name, social security number, address, contact information, the date that entered the database system, and also a ranking that the trading company keeps internally (high, med, low). Financial officers have a...
I need to draw an ER diagram for a future database necessary to hold application data...
I need to draw an ER diagram for a future database necessary to hold application data for students wishing to apply for an internship at a tech company. The students will provide the following information on the application: first name, last name, email, phone number, address, city, state, postal code, major, currently enrolled in school?, expected date of graduation, web framework of choice, list of programming languages in which the student is proficient, SAT score, ACT score, GPA, 4 character...
Solve problems using Minitab. Show evidence that they used the program by putting screen shots of...
Solve problems using Minitab. Show evidence that they used the program by putting screen shots of the results. Will give good rating. Exercises: 1. Among the 120 applicants for a job, only 80 are qualified. If 5 of these applicants are selected at random for an interview, answer the following: to. Identify the random process b. Define a variable c. Associate the random variable with a distribution and its parameters Solve the following questions using Minitab: d. Find the probability...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT