DB Project Brief: Database Design for a Chosen Domain Objective: The purpose of this assignment is to design a relational database for a chosen domain, covering conceptual, logical, and physical models, and to implement the database using SQL. Additionally, the tables should be normalized to at least the third normal form (3NF). Task: 1. Choose a Domain: Select a domain of interest (e.g., market, school, library, video rental, car rental, bookstore, marketplace). 2. Database Design: Conceptual Model: Create an Entity-Relationship Diagram (ERD) that includes at least five related tables. Identify entities, attributes, and relationships. Logical Model: Convert the ERD into a logical schema. Define primary keys, foreign keys, and other constraints. Normalize the tables to at least the third normal form (3NF). Physical Model: Design the physical schema for the database. Optimize the schema for performance and storage. 3. SQL Implementation: Write SQL statements to create the database and tables. Include SQL statements for inserting sample data into the tables. Provide SQL queries to demonstrate data retrieval and manipulation. Requirements: The database design should include at least five related tables. The assignment should cover conceptual, logical, and physical models. Tables must be normalized to at least the third normal form (3NF). Include SQL code for creating the database and tables, inserting data, and querying the database.Submit your assignment as a single document, including diagrams, explanations, and SQL code. Submission Deadline: Final Exam Day. Evaluation Criteria: Completeness and accuracy of the conceptual, logical, and physical models. Correctness and clarity of the SQL statements. Proper normalization of tables to at least 3NF. Overall presentation and organization of the document. Resources: Textbooks and online resources on database design and SQL. Database management systems (DBMS) documentation. Notes: Ensure your work is original and properly cited where necessary. Feel free to use any DBMS for your examples, but make sure to specify which one you are using.select toplu kaıt olarak yap ınsert delete ve update ten en az ıkı tane olacak sekılde kullan .bır tane alter table kullan .tablo olustururken mutlaka constriction (kısıtlama)kullan.5 tablo ıcın en az 5 sql olcak.ve kutuphaneyı sec o sekılde yap odevı bıde ben mıcrosof sql server kullanıyorum kodları ona uygun yaz .lutfen en ıyı ve en net sekılde hazırla odevı bundan 100 almam gerekıyor.bı de joın ıslemı yaparken 4 farlı joın kullanman gerekıyor .inner left rigth cross full outher gıbı .