Lab 3 Converting ERDs to Tables - CSIS 325 \u2013 Lab 3(ERD to Table Conversions Instructions In this assignment you will convert an Entity-Relationship

Lab 3 Converting ERDs to Tables - CSIS 325 u2013 Lab 3(ERD...

This preview shows page 1 - 2 out of 2 pages.

CSIS 325 – Lab 3 (ERD to Table Conversions)Instructions:In this assignment, you will convert an Entity-Relationship diagram into a set of related tables.Given the following ERD, write the table definitions for the entities displayed below. You do nothave to indicate data types nor “not null” constraints in this lab. Use the format TableName ( attributeattribute…attribute). Designate primary keys with an underline and foreign keys with a broken underline. To illustrate, the Regions and Countries table definitions have been created for you below the diagram. Type your answers in this document and upload it to the appropriate Blackboard assignment link by Monday at 11:59 p.m. ET of this module/week.Note that you should read the “Table Conversions Explained” document in your Reading & Study folder. I created it to help you better understand how ERDs will ultimately be transformed into real tables.ERD for the Hourglass timekeeping database ,
Example : Regions (RegionID , RegionName) Countries(CountryID , CountryName, RegionID ) 1. Regions (RegionID ,RegionName) PK: RegionID 2. Countries (CountryID ,CountryName,RegionID) PK: CountryID FK: RegionID 3. Offices (OfficeID ,OfficeName,CountryID) PK: OfficeID FK: CountryID 4. Clients (ClientID ,LegalName,ClientName,CountryID) PK: ClientID FK: CountryID 5. ContractTypes (ContractTypeID ,ContractTypeName) PK: ContractTypeID 6. Contracts (ContractID ,ContractDesc,ContractTypeID,ClientID) PK: ContractID FK: ContractTypeID,ClientID 7. Projects (ProjectID ,ProjectName,ContractID) PK: ProjectID FK: ContractID 8. Employees (EmpID ,FirstName,LastName,Email,Salary,LivesInCountryID,OfficeID) PK: EmpID FK: LivesInCountryID, OfficeID 9. WorkHours (EmpID,ProjectID,Day,Month,Year,HoursWorked) PK: Day, Month, Year FK: EmpID,ProjectID

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture