Question

Data Modeling and Database Design Database Concepts, Eighth Edition (Kroenke, Auer, Vanderberg, Yoder) Given the data...

Data Modeling and Database Design
Database Concepts, Eighth Edition (Kroenke, Auer, Vanderberg, Yoder)

Given the data model shown below, please define the following:

1) Table names

2) Primary Keys for each table. If the key is composite, please indicate.

3) Foreign Keys for each table and what table/field the FK relates to.

4) Define which table is the "Parent" and is the "Child" in the relationship.

EMPLOYEE(EmployeeNumber, ELastName, EFirstName, EAddress, ECity, EZipCode, EDepartCode)

DEPARTMENT(DepartmentCode, DeptName, DeptDiv)

DIVISION(DivisionCode, DivName, DivVP)

EPHONE(PhoneID, EmpNum, PhoneNumber, PhoneType)

Homework Answers

Answer #1

Hi,

Here is the explanation.

Kindly rate

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You want to design a database for an automobile dealership with three locations. A vehicle's data...
You want to design a database for an automobile dealership with three locations. A vehicle's data fields include stock number (a common name for SKU (Stock Keeping Unit)), vehicle identification number (VIN), make, model, year, color and invoice cost. Identify the possible candidate keys, the likely primary key, probably foreign keys, and potential secondary keys for the Vehicle table. Identify other tables the Vehicle table might need to form a relationship (or link with).
car dealership needs to design a database for their business. It is assumed there are three...
car dealership needs to design a database for their business. It is assumed there are three tables in the database with 6 fields in each table. Give your suggestions for the most necessary fields and their proper types, propertis and PK (primary key) / FK (foreign key) You can enlarge the answer window this way. Click in the answer box, then on the bottom right of the answer box, click on the triangle of dots icon and drag the window...
Design a database with the following tables Table name: Customer customer_id lastname firstname phone c10001 Smith...
Design a database with the following tables Table name: Customer customer_id lastname firstname phone c10001 Smith John 714-877-2333 Table name: Video video_id title daily_rent V8752 ET 2.99 Table name: Transaction transaction_id customer_id video_id date_rented Please create 3 tables and enter 5 records in each table using WORD Please indicate the primary key and foreign keys of each table
Kitchen World is changing its inventory system from a file-oriented system to a relational database system....
Kitchen World is changing its inventory system from a file-oriented system to a relational database system. Identify and design at least three tables that would be needed to capture data for Kitchen World's inventory. Each table should include a primary key, three non-key attributes, and foreign keys as necessary. Make up data values for two records within each table. Create an excel spreadsheet with this data. Download it to Access and do a query for the name of the largest...
***** this is question and answer i just need the schema Data Modelling is the primary...
***** this is question and answer i just need the schema Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data. Data Modeling:- Data Modeling is the first step in database designing.It is the representation of data model, or collected data. Also shows that collected data stored in database and linked...
Draw the Crow’s Foot database notation entity-relationship diagrams (ERD) to represent the databases, based on the...
Draw the Crow’s Foot database notation entity-relationship diagrams (ERD) to represent the databases, based on the three narratives below. Use Lucid Chart or another ERD diagramming tool to create your diagram. You do not need to create the databases, but to design it using applicable business rules according to your judgment. Submit a PDF of the Entity Relationship Diagram for each database. Remember to identify in your diagrams: All the main entities and the main attributes for each entity The...
If you had to create a new table in your database called EMPLOYEE and load data...
If you had to create a new table in your database called EMPLOYEE and load data into it using SQL commands below. CREATE TABLE EMPLOYEE (               EMP_ID INT PRIMARY KEY,               EMP_FNAME VARCHAR(200) NOT NULL,               EMP_LNAME VARCHAR(200) NOT NULL,               EMP_CITY VARCHAR(500) NULL ,               EMP_STATE VARCHAR(20) NULL ) INSERT INTO EMPLOYEE VALUE (1, ‘Kevin’, ‘Lailnay’, NULL, ‘PA’) INSERT INTO EMPLOYEE VALUE (2, ‘Sarita, ‘Kawn, ‘Princeton’,’NJ’) INSERT INTO EMPLOYEE VALUE (2, ‘Gloria, ‘Pitts, ‘Allentown, ‘PA’) INSERT INTO EMPLOYEE...
Summary The Ch08_ConstructCo database stores data for a consulting company that tracks all charges to projects....
Summary The Ch08_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. The structure and contents of the Ch08_ConstructCo database are shown in Figure P8.1. Use this database to answer the following problems. Database Schema The schema for the Ch08_ConstructCo database is shown below and should be used to answer the next several problems. Click this image to view it in its own...
Oracle Database Analysis and Design This project is to develop and implement an Oracle database. See...
Oracle Database Analysis and Design This project is to develop and implement an Oracle database. See the scenario of the Investment database. This simplified Investment Portfolio case study maintains information regarding clients that invest in stocks and mutual funds. Each client has a unique taxpayer identification number. A client may invest in stocks or mutual funds. A stock is uniquely identified by its ticker, which is symbol on the stock exchange. The name of issue for a stock is the...
SQL Data: you can just copy paste it into mysql to. CREATE DATABASE University;USE University; CREATE...
SQL Data: you can just copy paste it into mysql to. CREATE DATABASE University;USE University; CREATE TABLE Student (  sid INT PRIMARY KEY,  name VARCHAR(20) NOT NULL,  address VARCHAR(20) NOT NULL,  major CHAR(2)); CREATE TABLE Professor (  pid INT PRIMARY KEY,  name VARCHAR(20) NOT NULL,  department VARCHAR(10) NOT NULL); CREATE TABLE Course (  cid INT PRIMARY KEY,  title VARCHAR(20) NOT NULL UNIQUE,  credits INT NOT NULL,  area VARCHAR(5) NOT NULL); CREATE TABLE Transcript (  sid INT,  cid INT,  pid INT,  semester VARCHAR(9),  year YEAR,  grade CHAR(1) NOT NULL,  PRIMARY KEY (sid, cid, semester, year),  FOREIGN KEY (sid) REFERENCES Student...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT