حالت آفلاین — محتوا از حافظهٔ کش نمایش داده می‌شود
همهٔ تمرین‌ها

دیتابیس فروشگاه موبایل

تمرین آسان 1553 visibility link download flag

دیتابیسی برای فروشگاه موبایلی طراحی کنید که شامل دو جدول customers (مشتریان) و orders (سفارشات) باشد.

جدول مشتریان باید شامل موارد زیر باشد:

نام کامل
شماره موبایل
آدرس
سال تولد
آی دی


و جدول سفارشات باید شامل موارد زیر باشد:

باید مشخص باشد هر سفارش برای کدام کاربر است
مدل موبایل خریداری شده
برند موبایل خریداری شده
قیمت

پاسخ‌ها 6

CREATE TABLE customers (
    id INT PRIMARY KEY AUTO_INCREMENT,
    full_name VARCHAR(100),
    mobile_number VARCHAR(15),
    address VARCHAR(255),
    birth_year INT
);

CREATE TABLE orders (
    id INT PRIMARY KEY AUTO_INCREMENT,
    customer_id INT,
    mobile_model VARCHAR(100),
    mobile_brand VARCHAR(100),
    price DECIMAL(10, 2),
    FOREIGN KEY (customer_id) REFERENCES customers(id)
);
پاسخ هوش مصنوعی Ai DataBase 
create database Mobileـstore
create table customers
(
cus_id int constraint PK__customer_cus_id primary key,
cus_fullname nvarchar(60),
cus_phone char(11),
cus_address nvarchar(max),
cus_brithday date
)
create table orders
(
cus_id int constraint FK__customer_cus_id foreign key references customers(cus_id),
mobile_model nvarchar(50),
mobile_brand nvarchar(30),
mobile_price money
)
Sajad.karimi DataBase 
import mysql.connector
from pandas import read_pickle

db = mysql.connector.connect(host = "localhost",user = "root",password = "",database = "mobile_shop")

mycursor = db.cursor()
# mycursor.execute("create database if not exists mobile_shop")

# mycursor.execute(
#     """
#     create table if not exists customers(id INT(6) AUTO_INCREMENT PRIMARY KEY,
#     name varchar(255),
#     lname varchar(255),
#     mobile_number varchar(255),
#     address varchar(255),
#     yeaer varchar(255))
#     """
# )
# sql = "INSERT INTO customers(name,lname,mobile_number,address,yeaer) VALUES (%s, %s, %s, %s , %s)"
# val = [("Arman","Danyy", "09113189228","mazandaran\nbabol","1380"),
#        ("Iman","Danyy","09112129599","mazandaran\nbabol","1364"),
#        ("Peyman","Danyy","09117402307","mazandaran\nbabol","1368"),
#        ("Akbar","Danyy","09112131921","mazandaran\nbabol","1339"),
#        ("Aghdas","Danyy","09117402306","mazandaran\nbabol","1342"),
#        ("Maedeh","Danyy","09112237679","mazandaran\nbabol","1366"),
#        ("Noyan","Danyy","09113189228","mazandaran\nbabol","1398"),
#        ("Vihan","Danyy","09113189228","mazandaran\nbabol","1398"),
#        ("Dorrin","Danyy","09113189228","mazandaran\nbabol","1380")]
# mycursor.executemany(sql,val)

# db.commit()

# mycursor.execute(
#     """
#     create table if not exists Orders(id INT AUTO_INCREMENT PRIMARY KEY,
#     name varchar(255),
#     brand varchar(255),
#     model varchar(255),
#     price varchar(255))
#     """
# )


sql = "insert into orders(name,brand,model,price) VALUES(%s,%s,%s,%s)"
val = [("Arman","IR","A04S","200000000"),
       ("Iman","IR","A04S","200000000"),
       ("Peyman","IR","A04S","200000000"),
       ("Akbar","IR","A04S","200000000"),
       ("Aghdas","IR","A04S","200000000"),
       ("Maedeh","IR","A04S","200000000"),
       ("Noyan","IR","A04S","200000000"),
       ("Vihan","IR","A04S","200000000"),
       ("Dorrin","IR","A04S","200000000")]
mycursor.executemany(sql,val)

db.commit()
print(db)
Sumy.amiri Python 
CREATE DATABASE IF NOT EXISTS sql_store;
USE sql_store;

DROP TABLE IF EXISTS orders;
DROP TABLE IF EXISTS customers;

CREATE TABLE customers (
    customer_id INT PRIMARY KEY AUTO_INCREMENT,
    full_name   VARCHAR(50) NOT NULL,
    phone_number VARCHAR(20) NOT NULL UNIQUE,
    address     VARCHAR(255) NOT NULL,
    birth_year  YEAR NOT NULL      
);

CREATE TABLE orders (
    order_id    INT PRIMARY KEY AUTO_INCREMENT,
    customer_id INT NOT NULL,
    model       VARCHAR(50) NOT NULL,
    brand       VARCHAR(50) NOT NULL,
    price       DECIMAL(10,2) NOT NULL,
    FOREIGN KEY fk_orders_customers (customer_id)
        REFERENCES customers(customer_id)
        ON UPDATE CASCADE
        ON DELETE CASCADE
);
Mostafa DataBase 
import sqlite3

db = sqlite3.connect("shop_db.sqlite")
cur = db.cursor()

cur.execute('''
            CREATE TABLE IF NOT EXISTS customers(
            id INTEGER PRIMARY KEY,
            f_name VARCHAR(50),
            phone VARCHAR(11),
            address STRING,
            birth_year INTEGER
            )
        ''')

db.commit()

cur.execute('''
            CREATE TABLE IF NOT EXISTS orders(
            id INTEGER PRIMARY KEY,
            model STRING,
            brand STRING,
            price INTEGER,
            user_id INTEGER
            )
        ''')

db.commit()
db.close()
User 362 DataBase 
-- ایجاد جدول مشتریان
CREATE TABLE customers (
    customer_id INT AUTO_INCREMENT PRIMARY KEY,
    full_name VARCHAR(100) NOT NULL,
    mobile_number VARCHAR(15) NOT NULL UNIQUE,
    address VARCHAR(255) NOT NULL,
    birth_year INT NOT NULL
);

-- ایجاد جدول سفارشات
CREATE TABLE orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT NOT NULL,
    mobile_model VARCHAR(100) NOT NULL,
    mobile_brand VARCHAR(100) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    FOREIGN KEY (customer_id) REFERENCES customers(customer_id)
);
Mma123 DataBase

ارسال جواب

جوابت را با Markdown بنویس و ثبت کن

×

حساب کاربری

برای استفاده از این بخش باید وارد حساب کاربریت بشی

ورود/ثبت نام
بستن