Any database design with no more than 5 tables Data Management Project Requireme

Question

Any database design with no more than 5 tables

Data Management Project Requirements:
The requirements include (Requirements Analysis – Data model – In physical design format):
• Background
• Purpose
• Business goals and rules
• User requirements
• Data requirements
• Reporting requirements
• Project schedule and project costs.
• Data dictionary for all tables in data model
• SQL statements:Identify the database management system (DBMS) that will be used for the database design
• minimum of two CREATE TABLE statements (for entities defined in model)
• minimum of two SELECT statements
• one insert, update or delete statement.

Explanation / Answer

Any database design with no more than 5 tables:

It does not depends only one thing,it depends upon the requiremnt anaylys.baed on the requiremnt only we have to analyze the based on the requiremnts.

let me take an example:
Hospital Database Management Systems.

For the Design of database management system of a city medical center Doctors-Patient Visit we require the following records.
The information of doctor patients,medical centers medications and b/w their relations

first we need to analaze relations systems.

step1:creation of ER Design (entity relationship diagram)

step2:ER relationship mapping.

step3:Normalization of the above ER mapping.

step4:create tables all the req info

step:5 Insert values into tables.

step:6 select quiries baed on the require condtions

These are steps to be followd for any of the database Sytems.

if any update or delete activites need to be change the values in the databae and perform seelct quiries

Here I have given the just the outlet of the databae

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.