دیتابیسی برای فروشگاه موبایلی طراحی کنید که شامل دو جدول customers (مشتریان) و orders (سفارشات) باشد.
جدول مشتریان باید شامل موارد زیر باشد:
نام کامل
شماره موبایل
آدرس
سال تولد
آی دی
و جدول سفارشات باید شامل موارد زیر باشد:
باید مشخص باشد هر سفارش برای کدام کاربر است
مدل موبایل خریداری شده
برند موبایل خریداری شده
قیمت
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)
);
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 )
دانلود
تحلیل جواب با AI
Python - پایتون
PHP - پی اچ پی
JavaScript - جاوا اسکریپت
C# - سی شارپ
C & C++ - سی و سی پلاس پلاس
Kotlin - کاتلین
Java - جاوا
HTML & CSS - اچ تی ام ال و سی اس اس
Matlab - متلب
Rust - راست
Golang - گولنگ
Bash - بش
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)
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
);
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()
-- ایجاد جدول مشتریان
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)
);
برای استفاده از این بخش باید وارد حساب کاربریت بشی
ورود/ثبت نام