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 2 years ago
Next > < Previous

Related Solutions

Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database) DRAW ER DIAGRAM AS ONE FULL LIBRARY SYSTEM, NOT DIFFERENT FOR EACH ATTRIBUTE. Attributes :           Customer Cust_ID: key identifier, required, simple, single valued Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)           Inventory Book_ID:...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database) Attributes :           Customer Cust_ID: key identifier, required, simple, single valued Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)           Inventory Book_ID: Key identifier, required, simple single valued Book_Name: Key identifier, required, simple, single-valued Genre:...
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...
Using the world_x database you installed on your MySQL Workbench, create a new table named “independence”...
Using the world_x database you installed on your MySQL Workbench, create a new table named “independence” with the following attributes (columns): A field named “id” which has data type auto_increment, A field named “country_name” which has data type varchar(50), and A field named “independence_date” which has type “date.” After you create the table, run the following SQL command: INSERT INTO independence(country_name, independence_date) VALUE (‘United States’,’1776-07-04’) Submit a 1-page Microsoft Word document that shows the following: The SQL command you used...
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...
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...
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...
-Using MySQL Workbench Data Modeler, create three (3) models from the tables below. Show Table 1...
-Using MySQL Workbench Data Modeler, create three (3) models from the tables below. Show Table 1 in 3rd Normal Form. Show Table 2 in 3rd Normal Form. Merge the 3rd Normal Forms of Table 1 and Table 2 into a single 3rd Normal Form model. Note that you only can model table and column names and data types. The data shown is for your reference to determine functional, partial, and transitive dependencies. -Provide a summary of the steps you took...
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...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT