Question
In: Computer Science
Design a database for an automobile company to provide to its dealers to assist them in...
Design a database for an automobile company to provide to its dealers to assist them in maintaining customer records and dealer inventory and to assist sales staff in ordering cars. Each vehicle is identified by a vehicle identification number (VIN). Each individual vehicle is a particular model of a particular brand offered by the company (e.g., the XF is a model of the car brand Jaguar of Tata Motors). Each model can be offered with a variety of options, but an individual car may have only some (or none) of the available options. The database needs to store information about models, brands, and options, as well as information about individual dealers, customers, and cars. Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
Solutions
Expert Solution
Ans for the given problem
*************************Thank You**********************
venereology answered 1 year agoRelated Solutions
Carlson Auto Dealers Inc. sells a handmade automobile as its only product. Each automobile is identical;...
Carlson Auto Dealers Inc. sells a handmade automobile as its
only product. Each automobile is identical; however, they can be
distinguished by their unique ID number. At the beginning of 2021,
Carlson had three cars in inventory, as follows:
Car ID
Cost
203
$
69,000
207
69,000
210
72,000
During 2021, each of the three autos sold for $99,000. Additional
purchases (listed in chronological order) and sales for the year
were as follows:
Car ID
Cost
Selling Price
211
$...
Carlson Auto Dealers Inc. sells a handmade automobile as its only product. Each automobile is identical;...
Carlson Auto Dealers Inc. sells a handmade automobile as its
only product. Each automobile is identical; however, they can be
distinguished by their unique ID number. At the beginning of 2018,
Carlson had three cars in inventory, as follows:
Car ID
Cost
203
$
51,000
207
51,000
210
54,000
During 2018, each of the three autos sold for $81,000. Additional
purchases (listed in chronological order) and sales for the year
were as follows:
Car ID
Cost
Selling Price
211
$...
Carlson Auto Dealers Inc. sells a handmade automobile as its only product. Each automobile is identical
Carlson Auto Dealers Inc. sells a handmade automobile as its only product. Each automobile is identical; however, they can be distinguished by their unique ID number. At the beginning of 2021, Carlson had three cars in inventory, as follows:
Car ID..................Cost
203.......................$60,000
207........................60,000
210........................63,000
During 2021, each of the three autos sold for $90,000. Additional purchases (listed in chronological order) and sales for the year were as follows:
Required:
1. Calculate 2021 ending inventory and cost of goods sold...
Carlson Auto Dealers Inc. sells a handmade automobile as its only product. Each automobile is identical;...
Carlson Auto Dealers Inc. sells a handmade automobile as its
only product. Each automobile is identical; however, they can be
distinguished by their unique ID number. At the beginning of 2021,
Carlson had three cars in inventory, as follows:
Car ID
Cost
203
$
69,000
207
69,000
210
72,000
During 2021, each of the three autos sold for $99,000. Additional
purchases (listed in chronological order) and sales for the year
were as follows:
Car ID
Cost
Selling Price
211
$...
A manufacturing company makes auto parts and sells them to auto dealers.
A manufacturing company makes auto parts and sells them to auto dealers. Last week the company shipped 25 auto parts to a dealer. Later it found out that 5 of those parts were defective. By the time the company manager contacted the dealer 4 auto parts from that shipment had already been sold. What is the probability that 3 of those 4 parts were non-defective?
According to the National Automobile Dealers Assoc., 75% of U.S. car dealers' profits comes from repairs...
According to the National Automobile Dealers Assoc., 75% of U.S.
car dealers' profits comes from
repairs and
parts sold. However, many of the dealerships' service departments
aren't open evenings
or
weekends. The percentage of dealerships opened during the evenings
and weekends are as
follows:
Time Dealerships are Open
Percentage of Dealerships
Weekends
but not evenings
37.5
Evenings
but not weekends
13.2
Both
evenings and weekends
11.3
a. Are the
listed times mutually exclusive?
b. What is
the probability that a...
According to the National Automobile Dealers Assoc., 75% of U.S. car dealers' profits comes from repairs...
According to the National Automobile Dealers Assoc., 75% of U.S.
car dealers' profits comes from repairs and parts sold. However,
many of the dealerships' service departments aren't open evenings
or weekends. The percentage of dealerships opened during the
evenings and weekends are as follows:
Time Dealerships are open
Percentage of Dealerships
Weekends but not evenings
37.5
Evenings but not weekends
13.2
Both evenings and weekends
11.3
a. Are the listed times mutually exclusive?
b. What is the probability that a...
Database __________ which is the logical design of the database, and the database _______ which is...
Database __________ which is the logical design of the database,
and the database _______ which is a snapshot of the data in the
database at a given instant in time.
a) Instance, Schema
b) Relation, Schema
c) Relation, Domain
d) Schema, Instance
True or False: Logical database design is the process of modifying the physical database design to...
True or False:
Logical database design is the process of modifying the
physical database design to improve performance.
The two major logical database design techniques are conversion
of E-R diagrams to relational tables and data normalization.
Multivalued attributes are not permitted in unnormalized
data.
A many-to-many binary relationship in an E-R diagram requires
the creation of a total of three tables in a relational
database.
A one-to-one unary relationship in an E-R diagram requires the
creation of a total of...
Discuss the three-schema architecture and its benefits for database development and design.
Discuss the three-schema architecture and its benefits for
database development and design.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- The requirements for your assignment are: Decode the IP address 172.16.31.255 /20 Determine the following: Subnet...
- Examine the various types of contracts available to Toyota when dealing with international suppliers and advise...
- Problem 10-08 NPVs, IRRs, and MIRRs for Independent Projects Edelman Engineering is considering including two pieces...
- Give an example for market segmentation for a new company developing either products for cats or...
- Suppose you have set a specific goal for the balance in your savings account 12 years...
- Explain in very good details the hardening and procedures of Microsoft Server 2019
- Straight-Line Depreciation A building acquired at the beginning of the year at a cost of $85,300...
ADVERTISEMENT