Сhoose one Company and build the database. The company database needs to include the following aspects of corporate operations. Vehicles. Each vehicle as a vehicle identification number (VIN). Each vehicle also has a lot of properties encoded in real VINs (they are well described on Wikipedia), but you can just make them up if you want. Each property can be regarded as one attribute. Brands: Each company may have several brands (for example, GM has Chevrolet, Pontiac, Buick, Cadillac, GMC, Saturn, Hummer, Saab, Daewoo, Holden, Vauxhall, and Opel and Volkswagen has Volkswagen, Audi, Lamborghini, Bentley, Bugatti, Skoda, and SEAT). Each Brand also have some properties, and can be listed as attributes. Models: Each brand offers several models (for example, Buick’s models are the Enclave, LaCrosse, and Lucerne, and Mercury’s models are the Mariner, Milan, Sable, and Grand Marquis). Each model may come in a variety of body styles (4-door, wagon, etc.), and each body style can be regarded as one attribute. Options: Color, engine, and so on. Dealers: Dealer has their locations, the models they sale, and so on. Customers: Name, address, phone, gender, and annual income for individual buyers. Dealers buy vehicles from the manufacturer and sell them to customers. We’ll keep track of sales by date, brand, model, and color. Suppliers: Suppliers supply certain parts for certain models. Build a database in SQL Server for the automobile company you choose. The database should include all information described above. To build the database, you should build: ER diagram, Relational Schema, Populate relations and Quesries
Сhoose one Company and build the
The company database needs to include the following aspects of corporate operations.
Vehicles. Each vehicle as a vehicle identification number (VIN). Each vehicle also has a
lot of properties encoded in real VINs (they are well described on Wikipedia), but you can
just make them up if you want. Each property can be regarded as one attribute.
Brands: Each company may have several brands (for example, GM has Chevrolet, Pontiac,
Buick, Cadillac, GMC, Saturn, Hummer, Saab, Daewoo, Holden, Vauxhall, and Opel and
Volkswagen has Volkswagen, Audi, Lamborghini, Bentley, Bugatti, Skoda, and SEAT). Each
Brand also have some properties, and can be listed as attributes.
Models: Each brand offers several models (for example, Buick’s models are the Enclave,
LaCrosse, and Lucerne, and Mercury’s models are the Mariner, Milan, Sable, and Grand
Marquis). Each model may come in a variety of body styles (4-door, wagon, etc.), and each
body style can be regarded as one attribute.
Options: Color, engine, and so on.
Dealers: Dealer has their locations, the models they sale, and so on.
Customers: Name, address, phone, gender, and annual income for individual buyers.
Dealers buy vehicles from the manufacturer and sell them to customers. We’ll keep track
of sales by date, brand, model, and color.
Suppliers: Suppliers supply certain parts for certain models.
Build a database in SQL Server for the automobile company you choose. The
database should include all information described above. To build the database, you should
build: ER diagram, Relational Schema, Populate relations and Quesries
Step by step
Solved in 4 steps with 1 images
