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 your timestamp and your location.
• A device that receives information from sensors and communicates with the
actuators, it can be an Arduino or any other board.

Solutions

Expert Solution

E-R Diagram-

This Er model has 8 main entities-

Presence sensor
Distance sensor
sensor
switch actuator
motor actuator
communicates
information
device

This Er model has has been converted into 3NF
Here each entity and its attributes are in tabular form
Data types of each attribute has been mentioned with it
The primary key as PK and foriegn key as FK has been mentioned there.

If any doubt, please feel free to ask and comment, i would like to answer them.
Thank you

venereology answered 1 month ago

Next > < Previous

Related Solutions

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...

create the UML Diagram to model a Movie/TV viewing site. Draw a complete UML class diagram...

create the UML Diagram to model a Movie/TV viewing site. Draw a complete UML class diagram which shows: Classes (Only the ones listed in bold below) Attributes in classes (remember to indicate privacy level, and type) No need to write methods Relationships between classes (has is, is a, ...) Use a program like Lucid Cart and then upload your diagram. Each movie has: name, description, length, list of actors, list of prequals and sequals Each TV Show has: name, description,...

Draw a UML diagram for the classes. Code for UML: // Date.java public class Date {...

Draw a UML diagram for the classes. Code for UML: // Date.java public class Date { public int month; public int day; public int year; public Date(int month, int day, int year) { this.month = month; this.day = day; this.year = year; } public Date() { this.month = 0; this.day = 0; this.year = 0; } } //end of Date.java // Name.java public class Name...

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...

Draw a UML diagram that describes a class that will be used to describe a product...

Draw a UML diagram that describes a class that will be used to describe a product for sale on Glamazon.com. The product has a name, a description, a price, ratings by many customers (1 to 5 stars), and a group of customer comments. New products have no ratings or comments by customers, but do have a name, description and price. The price can be changed and more customer ratings and comments can be added. A global average rating of all...

Instructions: Draw an ER diagram for the following description. Identify the keys and give the cardinality...

Instructions: Draw an ER diagram for the following description. Identify the keys and give the cardinality of all relationships (e.g. 1:1, N:1, N: M). Make sure you note your assumptions. Assume you are creating a database for a library system with the following properties: The library contains one or several copies of the same book. Every copy of a book has a copy number and is located at a specific location on a shelf. A copy is identified by the...

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...

1. draw a UML diagram that describes the Tablet Store's purchases and payment process. 2. using...

1. draw a UML diagram that describes the Tablet Store's purchases and payment process. 2. using microsoft access implement a relational database from your UML class diagram. Identify at least three fields per table. 3. describe how you would use the relational database to determine the Tablet store's account payable

What role does the entity-relationship (ER) diagram play in the database design process? Discuss the different...

What role does the entity-relationship (ER) diagram play in the database design process? Discuss the different types of information represented in the ER diagram and the symbols used to represent them. How would you approach the diagramming process?

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...

Subjects