ZuoTi.Pro
Question

[10 points] Draw an ER diagram for computers at a school. Each computer is identified by...

[10 points] Draw an ER diagram for computers at a school. Each computer is identified by an ID number, make, model, date acquired, and location. Each computer is categorized as a student computer or a staff computer. If it is a student computer, an attribute is hours available. If it is a staff computer, an attribute is responsible party (owner, if you will). Include the superclass/subclass constraints in your diagram

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Superlass make model Cid 1 COMPUTER location a DATE ACQUIRED) Constraints → Total. (HOURS STAFF STUDENT Subclass Subclass Res

0 0
Add a comment
Know the answer?
Add Answer to:
[10 points] Draw an ER diagram for computers at a school. Each computer is identified by...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • ER Modeling: Assignment In order to receive credit for this assignment, you must draw your ER...

    ER Modeling: Assignment In order to receive credit for this assignment, you must draw your ER model using a compute program and then turn in on the blackboard. Your ER model should include all of the necessary entity sets, relationships and keys, as well a weak entities and superclass/subclass relationships, if needed. A company decides to implement a software to monitor its employees' web surfing, and stores history of each employee's surfing in a database, as well as all of...

  • Hello I need to Convert the ER Diagram to a relational model. Analyze each table to...

    Hello I need to Convert the ER Diagram to a relational model. Analyze each table to make sure that they are in 3rd Normal Form. Write the level of normalization for each table and state in your report why it is an acceptable level of normalization. Physical Database Design: identify the data types of each columns (in each table). Gender Register Date Name Doctor ID Patient ID Room No Patient Salary qualification Consults Tel No DOB Staff Name Gender Staff...

  • this is database course please draw the ER by this way We have been asked to...

    this is database course please draw the ER by this way We have been asked to analyze the data requirements and develop a database system to keep information for equipment hiring companies in the country The aim of this system is to monitor the hiring of equipment to dients. There are many companies in the country, and each company has at least three branches across the country. Where each branch has staff including the branch manager who is responsible for...

  • Design an ER diagram for a library management system. The library manages books, members, and books...

    Design an ER diagram for a library management system. The library manages books, members, and books borrowed by members.  The library has several branches around the city. Each branch has a name and address and is identified by a branch ID.  Each book in the system is identified by a unique ISBN along with its title, author(s), and publisher.  A publisher is identified by its name, address, and phone. Note that publishers may be based anywhere around...

  • Design an ER diagram for a library management system. The library manages books, members, and books...

    Design an ER diagram for a library management system. The library manages books, members, and books borrowed by members.  The library has several branches around the city. Each branch has a name and address and is identified by a branch ID.  Each book in the system is identified by a unique ISBN along with its title, author(s), and publisher.  A publisher is identified by its name, address, and phone. Note that publishers may be based anywhere around...

  • Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage ...

    Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage data for athletes athletic game. Requirements are as follows: Each participating team has a name and a manager. Each athlete has a unique athlete ID, and is also described by first name and last name, gender and age. A team has many athletes but an athlete only belongs to one team. Each sport has a unique code and some sport name....

  • Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course.

    Question: Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course. 1- Draw an ER diagram of ONLINE COURSE REGISRATION database, that captures all the given below requirements. Specify key attribute(s) of each entity set. For each relationship set, specify structural constraints and participation constraints. a. For each USER, the portal maintains user ID, Name, E-mail. Each user has a unique ID. Name is a Composite attributes with Frame, Midname,...

  • 3. (12 points) For each of the descriptions below, develop an ER diagram using draw.io. Create...

    3. (12 points) For each of the descriptions below, develop an ER diagram using draw.io. Create a new page in your draw.io file for each diagram and name them appropriately (e.g., “3a” and “3b”). Include entities, attributes (identifier, simple, composite, derived), relationships (cardinality, modality). a. A car company has a database where each car has an identifying serial number and a manufacturing completion date. Each car is an example of a certain model. All models have an identification number, name...

  • Would you please help me with this homework ? 1- Explain what requirements this ER diagram...

    Would you please help me with this homework ? 1- Explain what requirements this ER diagram is implementing 2- Draw an ER diagram (relationships) for the following business rules in a company: • A salesperson manages one or many other salespeople while a salesperson is managed by only one salespeople. • A salesperson can be an agent for many customers but a customer is managed by only one salesperson. • A customer can place many orders. But an order can...

  • Database 1. Draw an Entity-Relationship diagram(including cardinality ratio and participa- tion constraint) to represent the following...

    Database 1. Draw an Entity-Relationship diagram(including cardinality ratio and participa- tion constraint) to represent the following application: A DEPARTMENT has a number of TEACHERS and each TEACHER is affil- iated only with one DEPARTMENT; A STUDENT has only one TEACHER as an advisor, but a TEACHER can advise many STUDENT; on the other hand, TEACHER instructs many STUDENTS, and a STUDENT has a number of instructors. Different AGENCIES support different TEACHERS for various PROJECTS. (15 points) A trucking company is...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT