Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need database for car dealership and should be included the following information Part I : Introduction - Background of the organization Povide a brief

I need database for car dealership and should be included the following information

Part I :

Introduction - Background of the organization

Povide a brief introduction of the sub-system and the organization in one paragraph

Problem - Brief description of the problem

What are the current problems with storing and retrieving data?

Objective of the database - how does it solve the problem?

Part II :

ER/Class Diagram--Draw the class diagram for your proposed database

Part III :

Description of tables

In a couple of sentences, provide a brief description of each table in your database. Also include a short description of the columns/attributes from each table.

Description of keys - Primary, foreign, composite

In a couple of sentences, provide a brief description of the primary, foreign and composite keys for each table.

Data types for each attributes

In a couple of sentences, provide reasoning for selecting data types for each attribute/column.

Description of relationships

In a couple of sentences provide a brief description of the relationships between the tables of your database.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft SQL Server 2012 Unleashed

Authors: Ray Rankins, Paul Bertucci

1st Edition

0133408507, 9780133408508

More Books

Students also viewed these Databases questions

Question

What is aggregate operations planning? What is its purpose?

Answered: 1 week ago