A-Define logical and physical data independency and justify that they are import

Question

A-Define logical and physical data independency and justify that they are important in database

design and usage

B-Choose a DBMS that you’d like to use. Provide some evidences to show that you have some basic knowledge of the software. For instance, use the software to define a name and address database of your business associates, friends, classmates etc. You can use the following relation: (LAST NAME, FIRST NAME, SEX, ADDRESS, POSTCODE, CITY, PHONE). Enter at least five people in your data file. Print/screen shot a copy of the records. There should be no blank records.

C-Why would you use a database system instead of traditional file system

Explanation / Answer

Answers

Question A

Importances Of Design is

-->

Determine the Purpose of the Database

-->FInd And Organize information Requied

--> Divide Information into Tables

-->Turn Information Into Columns

--> Specify The primary Key

-->

Set up the Table Relationship to define Foreign Key And candiate Key

-->refine Or Rectify errors in design

--->

Apply normilize rules

QUestion B

Answer

SQl(Sequiencel query LAnguage ) is best

i.e Oracle Sqlplus 8.0

Open The software in Login Screen

default username:scott

Password :tiger

Host String :orcl

After That Create DB (Create database <DAtabaseNAme>)

After Create Table by using this Syntax

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
   ....
);

For Given Relation The Table be

SQl>create table Userinfo(lastname varchar2(20) NOT NULL,firstname varchar2(20) NOT NULL, sex varchar2(5) NOT NULL ,Address varchar2(50) NOT NULL ,postcode number(10) NOT NULL,city varchar2(10) NOT NULL,phone number(10) NOT NULL );

NOTE: NOT NULL is Constraint to We Not Allo Any No Blanck Records ths is Used

INSERTING VAlues

INSERT INTO userinfo(lastname,first name,sex,address,postcode,city,phone) values('amit','mohan','male',228 park aveny newyork,'10003','newyork','56232420);

INSERT INTO userinfo(lastname,first name,sex,address,postcode,city,phone) values('Whatt','James','male',589 park aveny newyork,'10043','newyork','7854120');

INSERT INTO userinfo(lastname,first name,sex,address,postcode,city,phone) values('Ramana','josep','female',228 park aveny california,'10003','california','2547852');

INSERT INTO userinfo(lastname,first name,sex,address,postcode,city,phone) values('amit','mohan','male',seattle,'34628','Washington DC,'9874525-9652');

After Sql Command

select *from userinfo;

it show contects of table soyou can print it

Question C

Answer

Many Resons Should Exits In Why use Database because of Size ,Cost,Efficeincey

And Sequirity So many factore Including In Database

the MAin Resons Is

1. A database management system coordinates both the physical and the logical access to the data, whereas a file-processing system coordinates only the physical access.

2. A database management system is designed to allow flexible access to data (i.e. queries), whereas a file-processing system is designed to allow predetermined access to data (i.e. compiled programs).

3. A database management system is designed to coordinate multiple users accessing the same data at the same time. A file-processing system is usually designed to allow one or more programs to access different data files at the same time. In a file-processing system, a file can be accessed by two programs concurrently only if both programs have read-only access to the file.

4. Redundancy is control in DBMS, but not in file system.

5. Unauthorized access is restricted in DBMS but not in the file system.

7. DBMS provide back up and recovery whereas data lost in file system can't be recovered.

8. DBMS provide multiple user interfaces. Data is isolated in file system.

Any Dobut pls replay

iam taking References of my knowledge and Comparing Online Content

Thanku

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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