Case

Practice First

Rating

Sold

Pages

Grade

A+

Uploaded on

01-02-2024

Written in

2018/2019

It is an easy form to create a database SQL. This Practice is the first of the course and show main commands on SQL.

Institution

Course

Content preview

CREATE DATABASE PRACTICA1
USE PRACTICA1

CREATE TABLE CLIENTE (
CODIGO INT IDENTITY PRIMARY KEY NONCLUSTERED,
NOMBRE VARCHAR(30) NULL,
CIUDAD VARCHAR(30) NULL,
DIRECCION VARCHAR(50) NULL,
TELF VARCHAR(9) NULL
)

CREATE TABLE COCHE (
MATRICULA CHAR(6) PRIMARY KEY NONCLUSTERED NOT NULL,
PRECIO NUMERIC(8,2) CHECK (PRECIO > 2500) NULL,
MARCA VARCHAR(30) NULL,
MODELO VARCHAR(30) NULL,
COLOR VARCHAR(20) NULL,
COD_CLIENTE INT NOT NULL,
FOREIGN KEY (COD_CLIENTE) REFERENCES CLIENTE(CODIGO)
)

CREATE TABLE REVISION (
CODIGO INT IDENTITY PRIMARY KEY NONCLUSTERED,
CAM_FRENO CHAR(2) NULL,
CAM_FILTRO CHAR(2) NULL,
CAM_ACEITE CHAR(2) NULL,
COD_COCHE CHAR(6) NOT NULL,
FOREIGN KEY (COD_COCHE) REFERENCES COCHE(MATRICULA)
)

/*

Report Copyright Violation

Written for

Institution: National University of Engineering
Course: SI 117

All documents for this subject (1)

Document information

Uploaded on: February 1, 2024
Number of pages: 1
Written in: 2018/2019
Type: CASE
Professor(s): Raúl diaz
Grade: A+

Subjects

system engineering
create database

$9.99

Get access to the full document:

Written by students who passed

Immediately available after payment

Read online or as PDF

Get to know the seller

tttuuu

Get to know the seller

tttuuu University Peru

View profile

Sold

Member since

2 year

Number of followers

Documents

Last sold

0.0

0 reviews

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller tttuuu. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $9.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews) 47347 documents were sold in the last 30 days Founded in 2010, the go-to place to buy study notes for 16 years now

Practice First

Content preview

Written for

Document information

Subjects

Get to know the seller

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Didn't get what you expected? Choose another document

Pay as you like, start learning right away

Working on your references?

Frequently asked questions

What do I get when I buy this document?

Satisfaction guarantee: how does it work?

Who am I buying these notes from?

Will I be stuck with a subscription?

Can Stuvia be trusted?