Question

In: Computer Science

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-
  1. Presence sensor
  2. Distance sensor
  3. sensor
  4. switch actuator
  5. motor actuator
  6. communicates
  7. information
  8. 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 year 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:...
Draw the ER diagram for the following: Emerging Electric wishes to create a database with the...
Draw the ER diagram for the following: Emerging Electric wishes to create a database with the following entities and attributes: (10) • Customer, with attributes Customer ID, Name, Address (Street, City, State, Zip Code), and Telephone • Location, with attributes Location ID, Address (Street, City, State, Zip Code), and Type (values of Business or Residential) • Rate, with attributes Rate Class and RatePerKWH After interviews with the owners, you have come up with the following business rules: • Customers can...
Company X database Create an ER Diagram using UML notation for the following tables, then write...
Company X database Create an ER Diagram using UML notation for the following tables, then write out in the Relational model. Company X is a manufacturing company that binds and sells books. They have hired you to create database to track their Employees, Products, customers and their orders. All employees work with book Binding, Only some are designated as Reps for customers. Reps may have many customers. But each customer can only have 1 rep. They count to record each...
Draw an ER diagram and write a database design outline for the following prompt: You run...
Draw an ER diagram and write a database design outline for the following prompt: You run a coaching service to help high school students prepare for the SAT exam. You have a staff of coaches, each of which has an employee ID, an hourly rate (such as $20 per hour), and personal information consisting of their first name, last name, middle name/initial, address information, phone number, mobile phone number, and e-mail address. For each high school student, you want to...
draw a uml diagram for a class
draw a uml diagram for a class
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...
Draw an ER diagram containing the ConferenceSeries, the ConferenceEvent, and the ConferenceTrack entitysets where each ConferenceSeries...
Draw an ER diagram containing the ConferenceSeries, the ConferenceEvent, and the ConferenceTrack entitysets where each ConferenceSeries can be linked to zero or many ConferenceEvent entities, and each Conference Event may be linked to one or many ConferenceTracks. ConferenceTrack should not exists without a ConferenceEvent. Choose an appropriate relationship name. Then augment the model with an entityset Venue and a relationship named OrganizedAt associating each ConferenceEvent with exactly one Venue. Assume that a Venue must have run at least one ConferenceEvent....
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...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT