In a Microsoft Excel spreadsheet, define columns with the following headings: Pr

Question

In a Microsoft Excel spreadsheet, define columns with the following headings:

Primary Key

Name of Column

Null (NorY)

Datatype

Description

Foreign Key

Foreign Key Table

Each row will contain your rows for this table.

Fill out the columns row-wise.

Using Microsoft Visio or Microsoft Paint, create an E-R model of the six tables from your spreadsheet for developing the business requirements and constraints that will maintain the business logic for your database.

The E-R model should be readable and should map to the spreadsheet and the project description.

It should have all the cardinality and optionality defined.

In Microsoft Access, create the database and tables that you identified. In Microsoft Word, write the SQL statements to create the database and tables.

Write SQL statements to populate the tables. Run the SQL statements in Microsoft Access for populating the tables.

Explanation / Answer

http://www.intensewriters.com/pages/blog/9745

http://www.justanswer.com/homework/7n8yp-ra-211.html#re.v/447/

https://www.coursehero.com/tutors-problems/Computer-Science/8441571-In-a-Microsoft-Excel-spreadsheet-define-columns-with-the-following-he/

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.