ZuoTi.Pro
Question

Convert the Conceptual Model into Relational Model. Enter some example data into the relations. Your job...

Convert the Conceptual Model into Relational Model. Enter some example data into the relations. Your job is to decide whether to establish the relationship by posting a Foreign Key into the other table or create a separate table for the relationship. Give reason for your answer.

i need the answer to be written by computer pls. not hand written

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

Homework Answers

Answer #1

From the Conceptual Model, we have a one-to-many relationship from DEPARTMENT to FACULTY. That is a Department may have many Faculties which Each Faculty has a unique Department.

Thus we do not need to create a seperate table for the relationship. We just need a Foreign Key in FACULTY table referring to DEPARTMENT table. This foreign key represents the corresponding department of the faculty.

The Schema of these tables are given bellow:

DEPARTMENT(dept#, name, address)

FACULTY(faculty#, name, phone, dept#)

Some Example Data of the tables:

DEPARTMENT

NB: Hope this helps to get your answer. Let me know if anything else is needed from my side. Plase provide feedback to help you better.

0 0
Add a comment
Know the answer?
Add Answer to:
Convert the Conceptual Model into Relational Model. Enter some example data into the relations. Your job...
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

  • This assignment your tasks is to convert the E-R diagram to a relational model and then...

    This assignment your tasks is to convert the E-R diagram to a relational model and then to SQL. The mapping process is straightforward. Three components of the conversion process are Specify schema of relation itself Specify primary key on the relation Specify any foreign key references to other relations 1. 2. 3. dateBorn mName birthPlace IName dateDied fName IName address - oCountry ID mName ttlAmt Customers N Artists M Favors fName artStyle ID N Creates Like M startedDate theme title...

  • Hello please don't answer with your handwriting thank you Give an example of 3 relations illustrating...

    Hello please don't answer with your handwriting thank you Give an example of 3 relations illustrating primary keys and foreign keys f 3 relations illustrating primary keys and foreign keys Use your example for a simple Relational algebra query

  • I have created an ERD for the provided scenario, however I am having some trouble changing...

    I have created an ERD for the provided scenario, however I am having some trouble changing it into a Relational Model table, any help would be appreciated. The task is below, along with the ERD I came up with. Derive a Relational Model from the conceptual schema you provided in Task 1 (it should match exactly). For the purpose of this assignment, only derive the part of the database that stores the information about players, quests, beacons and treasures (considering...

  • E/R diagram: Draw a complete Doctors office system E-R diagram using UML or crow’s foot notation...

    E/R diagram: Draw a complete Doctors office system E-R diagram using UML or crow’s foot notation that includes all of the entities, attributes, identifiers. Relationships should be appropriately labeled with verb phrases. Make it neat. Once the E-R model has created, convert the E-R model to a set of relations by using rules. We will call this set of relations the initial set of relations derived from the E-R model. You use to implement your database application in MS Access....

  • For this DATABASE homework assignment you will create an Entity Relationship model for a business case...

    For this DATABASE homework assignment you will create an Entity Relationship model for a business case and then convert the model to a set of relations.  Read through the following business case for the “Drum Corps International”  Create an Entity relationship model with the necessary entities, attributes, identifiers and relationships to capture the data requirements.  All relationships should be labeled with verb phrases.  Use UML notation for this work.  Relationship lines should not cross. ...

  • Question 1 Relational model and Normalisation                                   

    Question 1 Relational model and Normalisation                                       The following table identifies the information that the funding managers trade the stocks. But this table has been wrongly designed. It has been assumed that the combination of ManagerID, StockCode and TradeDate uniquely identifies each tuple in this relation. StockTrade ManagerID ManagerName StockCode CompanyName Action Quantity Price TradeDate M101 James Cook ORG Origin Energy Buy 10,000 10.10 12-1-2019 M101 James Cook RIO Rio Tinto Sell 20,000 88.50 15-1-2019 M102 Shirley Lin ORG Origin Energy...

  • database management 4.6u Dental Office Data Model For each of the following problems, create a conceptual...

    database management 4.6u Dental Office Data Model For each of the following problems, create a conceptual data model, consisting of object sets, relationships, attributes, and so on, that can be used to answer questions similar to the questions given. Indicate cardinalities. PLEASE NOTE YOU WILL SUBMIT YOUR COPY USING ONE OF THE FOLLOWING METHODS Your Choice) to me USING THE UPLOAD LINK! Possible options include: 1. Hand drawn solutions can be a paper submission or scanned and uploaded as a...

  • QUESTION 2 Copy of 1-3 Vocab Match the vocabulary word for each definition below A relational...

    QUESTION 2 Copy of 1-3 Vocab Match the vocabulary word for each definition below A relational database chart that is used to map the infor-mation from the entity relationship diagram A. Nulls the unique identifier for each row of data B. Unique Links data in one table to the data in a second table by re-ferring to the PK column in the second table C. Table instance chart Indicates if a column must contain a value D. Foreign key (FK)...

  • SUBJECT: INFORMATION TECHNOLOGY, CLASS: ADVANCE DATABASE MANAGEMENT Hello Everyone, I need help on a project for...

    SUBJECT: INFORMATION TECHNOLOGY, CLASS: ADVANCE DATABASE MANAGEMENT Hello Everyone, I need help on a project for my ITD 256 Class. These are the questions I am suppose to answer: Project: The project should include designing a database deals with making a proposal for the database implementation. You can either try to fix an existing problem in your business or create a new database for the new projects or new clients. Please define the objective, scope, and time frame of your...

  • DATABASES You are required to design and implement a relational database to help the local community...

    DATABASES You are required to design and implement a relational database to help the local community center better serve the residents in your neighborhood. Database Specifications: In your preliminary analysis, you have determined the following basic facts about the community center and the services it provides to the residents in the neighborhood: - The community center serves multiple areas which fall into different zip codes.  - The community center provides collaborative family based care services. An immediate family 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