Database Question Based on the given database, answer the following questions EM
ID: 3876950 • Letter: D
Question
Database Question Based on the given database, answer the following questions EMPLOYEE NUM EMP LNAME EMP ENAME EMPINIT EMP-HIREDATE gacoos 101 News 102 Senior 03 ArboughJune 104 Ramoras Anne 105 Johnson 106 Smithfield Williamm 107 Alonzo 08 Washington Ralph 109 Smith PROJECT 11/8/00 0:00 7/12/89 0:00 2/197 0:00 11/15/88 0:00 2/1/94 0:00 22/05 0:00 0/10/94 0:00 8 822/89 0:00 7/18/99 0:00 2/11/96 0:00 4/4/89 0:00 102395 0:00 11/15/94 0:00 8/20/91 0:00 1/25/90 000 3/5/95 0:00 19/94 0:00 114/06 0:00 501 Evergreen Amber Wave 04 Rolling Tide 113 502 501 511 505 OlenkoLary 111 Wabash 112 Smithson Darlene 113 Joenbrood Delbert 114 Jones ASSIGNMENT 115 Bawang Travis 116 Prat 17 WilliamsonAngie 118 Frommer James 2.6 34/14 000 4/14 000 510 510 113 25 1.9 14 000 14 000 14 0:00 35/14 0:00 25 514 000 25 35.75 96.75 5/14 0:00 14 000 14 000 38 Systems Analyst Database Designer 105 Electrical Engineer 84.5 Mechanical Engineer 67.9 Civil Engineer Cienical Support DSS Analyst Applications Designer 48.1 Bio Technician 14000 3614 000 25 36/14 000 36/14 000 3814 000 314 0100 3614 0100 316/14 0:00 15 37/14 0:00 814 000 55.78 28.87 45.95 112 34.55 8.36 27 510 Describe the type(s) of relationship(s) between EMPLOYEE and PROJECT. (hint: there are two relationships between them: participate and manage) . Create the ERD in Crow's foot notation to show the relationships among EMPLOYEE, ASSIGNMENT, and PROJECTExplanation / Answer
The ER show characterizes the applied perspective of a database. It works around true elements and the relationship among them. At see level, the ER demonstrate is viewed as a decent alternative for outlining databases.
Substance
A substance can be a true protest, either enliven or lifeless, that can be effortlessly identifiable. For instance, in a school database, understudies, instructors, classes, and courses offered can be considered as substances. Every one of these substances have a few qualities or properties that give them their personality.
A substance set is an accumulation of comparative kinds of elements. An element set may contain substances with quality having comparative esteems. For instance, a Students set may contain every one of the understudies of a school; in like manner a Teachers set may contain every one of the educators of a school from all resources. Substance sets require not be disjoint.
Properties
Substances are spoken to by methods for their properties, called characteristics. All characteristics have values. For instance, an understudy substance may have name, class, and age as characteristics.
There exists a space or scope of qualities that can be allocated to properties. For instance, an understudy's name can't be a numeric esteem. It must be alphabetic. An understudy's age can't be negative, and so on..
Relationship writes
You share numerous associations with individuals from your family. For example, you and your mom are connected. You have just a single mother, yet she may have a few kids. You and your kin are connected—you may have numerous siblings and sisters and, obviously, they'll have numerous siblings and sisters also. In case you're hitched, both you and your life partner have a mate—each other—yet just a single at any given moment. Database connections are fundamentally the same as in that they're relationship between tables. There are three sorts of connections:
•One-to-one: Both tables can have just a single record on either side of the relationship. Every essential key esteem identifies with just a single (or no) record in the related table. They're similar to mates—you might possibly be hitched, however in the event that you are, both you and your life partner have just a single companion. Most balanced connections are constrained by business administers and don't stream normally from the information. Without such a run, you can for the most part join the two tables into one table without breaking any standardization rules.
•One-to-many: The essential key table contains just a single record that identifies with none, one, or numerous records in the related table. This relationship is like the one amongst you and a parent. You have just a single mother, yet your mom may have a few youngsters.
•Many-to-many: Each record in the two tables can identify with any number of records (or no records) in the other table. For example, on the off chance that you have a few kin, so do your kin (have numerous kin). Many-to-numerous connections require a third table, known as a partner or connecting table, on the grounds that social frameworks can't straightforwardly suit the relationship.
.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.