Question: While building a dimensional model of your organization's database, you are reading the tables of the ER model. Please identify the most accurate attribute types

While building a dimensional model of your

While building a dimensional model of your organization's database, you are reading the tables of the ER model. Please identify the most accurate attribute types of the individual attributes in the tables below: Table A TeacherID Full Name Specialty Email DepartmentID 1 David Warner DV@company.com 001 2 Sara Joseph Physics English Literature Programming SJ@company.com 002 3 Mike Brunton MB@company.com 003 1037 David Warner English Literature pv2@company.com 001 1038 Stephen Jones Marketing Sj2@company.com 004 Table B Address Phone DepartmentID Department_Name number 001 Science St Lucia, 4067 |(70) 300 002 English West End, 4101 |(70) 301 003 Computer St Lucia, INULL 4067 TeacherID 1. Primary key 2. Attribute Email DepartmentID 3. Candidate Key V Full Name V Specialty Department_name V Address Phone number

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!