Project title:
Database Management Systems
Posted by:
External project from PeoplePerHour
Started:
15-Oct-2023 07:52 GMT
Description:
need help with my Database Management Systems. This task represents the database design for a part of the food delivery function at Jack and Annie’s Soup & Sandwich Service. The outcome of this process represents a portion of the database design for the system that you are working on. It will also serve as the basis for the SQL and Python tasks. The report should include the following: Logical database design This forms the initial database schema for the food delivery function at Jack and Annie’s Soup & Sandwich Service. It is based on the accompanying data model. The data model does not cover all of the delivery processes. It is assumed that the mapping is to a relational schema. For each table, you need to specify the columns that comprise the table, identify its primary key, and specify any foreign keys, including columns that serve as both primary and foreign keys. The tables should be presented in standard form. You should ensure that common column have identical names. See the handout for what constitutes a logical database design – it is not a diagram. Changes to logical database design This represents changes to the logical database design based on the restructuring of columns, consolidation of columns, and any denormalization of the tables. This may be presented as a bullet list – see the handout for reference. Final database design This represents changes to the final database design you are proposing after the application of the changes listed earlier. This should be presented in standard form. Remember to depict all keys, including columns that are both primary and foreign keys. Once again, this is not a diagram. Physical database design This includes the physical schema and the list of indexes to be used. You need to define each column, specifying its format, (type and length), and whether it excludes NULL values. Also, specify any indexes, and all forms of referential integrity that may apply. This is to be done using the standard SQL notation (for both tables and indexes), as illustrated below: CREATE TABLE CREDITCARD
Project ID:
3350192
Project category:
Project budget:
Project
Started
Company homepage development
Category : CSS, Graphic Design, HTML5, Web Development, Web Design Budget : $20 - $50 NZD
08-May-2024 10:04 GMT
Full-Time Data Entry Specialist Needed
Category : Data Entry, Data Processing, SEO, Virtual Assistant, Web Search Budget : $30 - $250 USD
08-May-2024 10:03 GMT
Fun and Emotional Wedding Reel Editing
Category : Adobe Premiere Pro, After Effects, Video Editing, Video Services, Videography Budget : ₹600 - ₹1500 INR
08-May-2024 10:03 GMT
Confirmis Site Verifier (Singapore) -- 24219
Category : Communications, Human Resources, Local Job, Photography, Travel Ready Budget : $14 - $18 USD
08-May-2024 10:03 GMT
HTML to WordPress - & Blog
Category : CSS, HTML, PHP, Web Design, WordPress Budget : ₹3000 - ₹4000 INR
08-May-2024 10:02 GMT
Laravel PHP Script Optimization & Customization
Category : HTML, Laravel, MySQL, PHP, Web Design Budget : $30 - $250 USD
08-May-2024 10:02 GMT
Création d'un site web wordpress 4 langues
Category : Graphic Design, HTML, PHP, Web Design, WordPress Budget : €250 - €750 EUR
08-May-2024 10:02 GMT
Facebook Ad Lead Generation for Courses
Category : Advertising, Facebook Marketing, Internet Marketing, Marketing, Social Media Marketing Budget : ₹1500 - ₹12500 INR
08-May-2024 10:02 GMT
Smart Contract Development for Crypto Dapp
Category : C, Programming, PHP, Software Architecture, Software Testing, Testing / QA Budget : ₹750 - ₹1250 INR
08-May-2024 10:01 GMT
Resin Miniature Model for Dungeons & Dragons
Category : 3D Animation, 3D Modelling, 3D Rendering, 3ds Max, Solidworks Budget : $30 - $250 USD
08-May-2024 10:01 GMT
Resolve AspDotNetStorefront Email Dysfunction
Category : Database Administration, Database Programming, MySQL, PHP, SMTP Budget : $10 - $30 AUD
08-May-2024 10:01 GMT
Edit 37 short videos clips for YouTube Shorts & TikTok
Category : Video Editing, Video Production, Video Services, Videography Budget : €8 - €30 EUR
08-May-2024 10:01 GMT
WordPress Boat brand professional website template arrangement
Category : Graphic Design, Internet Marketing, SEO, Web Design, WordPress Budget : €250 - €750 EUR
08-May-2024 10:00 GMT
Engaging Redesign of Driving School Website
Category : Content Writing, Graphic Design, HTML, PHP, Web Design Budget : ₹600 - ₹1500 INR
08-May-2024 10:00 GMT
make changes to a crm application (only expert in report query e pivot)
Category : Laravel, MySQL Budget : $80 - $120 USD
08-May-2024 10:00 GMT
Browse All Projects